Is there an API to Insert/Update/Delete Cst_pac_item_costs, Cst_pac_quantity_layers, Cst_pac_periods tables (Doc ID 2977611.1)

Last updated on SEPTEMBER 29, 2023

Applies to:

Goal

Please suggest the Standard API to perform DML operations on below Standard tables.

INSERT INTO cst_pac_item_costs
INSERT INTO cst_pac_item_cost_details
INSERT INTO cst_pac_quantity_layers

UPDATE cst_pac_periods
  SET open_flag = 'N'
  ,period_close_date = SYSDATE
  WHERE pac_period_id = l_npacperiodid
  AND cost_type_id = l_ncosttypeid
  AND legal_entity = p_legal_entity;
  --
  UPDATE cst_pac_process_phases
  SET process_status = 4
  ,process_date = SYSDATE
  ,last_update_date = SYSDATE
  ,program_update_date = SYSDATE
  ,process_upto_date = SYSDATE
  WHERE pac_period_id = l_npacperiodid
  AND cost_group_id = p_cost_group
  AND process_phase IN (1, 2, 3, 4, 5, 6);



DELETE FROM cst_pac_quantity_layers
  WHERE cost_layer_id IN (SELECT cost_layer_id
  FROM cst_pac_item_costs
  WHERE pac_period_id = l_npacperiodid
  AND cost_group_id = p_cost_group);
  DELETE FROM cst_pac_item_cost_details
  WHERE cost_layer_id IN (SELECT cost_layer_id
  FROM cst_pac_item_costs
  WHERE pac_period_id = l_npacperiodid
  AND cost_group_id = p_cost_group);
  DELETE FROM cst_pac_item_costs
  WHERE pac_period_id = l_npacperiodid
  AND cost_group_id = p_cost_group;


insert into mtl_customer_items
insert into mtl_customer_item_xrefs
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.