APPS.CSTPFCHK dependencies on CST_PAC_QUANTITY_LAYERS

Line 792: -- UPDATE cst_pac_quantity_layers cpql

788: -- The following statement is not required in incremental
789: -- lifo as layer_quantity is populated in package
790: -- CST_MGD_LIFO_COST_PROCESSOR.populate_layers
791: --===========================================================
792: -- UPDATE cst_pac_quantity_layers cpql
793: -- SET (last_updated_by,
794: -- last_update_date,
795: -- last_update_login,
796: -- request_id,

Line 814: -- FROM cst_pac_quantity_layers cpql

810: -- FROM sys.dual)
811: -- WHERE cpql.quantity_layer_id = i_qty_layer_id
812: -- AND EXISTS
813: -- (SELECT 'there is a layer'
814: -- FROM cst_pac_quantity_layers cpql
815: -- WHERE cpql.quantity_layer_id = i_qty_layer_id);
816: --===========================================================
817: -- The statement has not been deleted for comparison reasons
818: --===========================================================

Line 892: UPDATE cst_pac_quantity_layers cpql

888:
889:
890: l_stmt_num := 20;
891:
892: UPDATE cst_pac_quantity_layers cpql
893: SET last_update_date = sysdate,
894: last_updated_by = i_user_id,
895: last_update_login = i_login_id,
896: request_id = i_req_id,

Line 1025: FROM cst_pac_quantity_layers cpql

1021: AND cpic.cost_group_id = i_cost_group_id;
1022:
1023: CURSOR prior_period_quantity_cursor (P_cost_layer_id number) IS
1024: SELECT quantity_layer_id
1025: FROM cst_pac_quantity_layers cpql
1026: WHERE cpql.cost_layer_id = P_cost_layer_id;
1027:
1028: CURSOR prior_period_jobs_cursor IS
1029: SELECT distinct(wip_entity_id)

Line 1089: -- 3. cst_pac_quantity_layers --

1085: --------------------------------------------------------------------------------
1086: -- Copy data from previous period to current period of the following tables : --
1087: -- 1. cst_pac_item_costs --
1088: -- 2. cst_pac_item_cost_details --
1089: -- 3. cst_pac_quantity_layers --
1090: -- New cost_layer_id and quantity_layer_id are generated for every rows --
1091: -- inserted. --
1092: --------------------------------------------------------------------------------
1093: FOR l_prior_period_cost IN prior_period_cost_cursor LOOP

Line 1230: SELECT cst_pac_quantity_layers_s.nextval

1226:
1227: FOR l_prior_period_qty IN
1228: prior_period_quantity_cursor (l_prior_period_cost.cost_layer_id) LOOP
1229:
1230: SELECT cst_pac_quantity_layers_s.nextval
1231: INTO l_quantity_layer_id
1232: FROM dual;
1233:
1234: ------------------------------------------------

Line 1235: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --

1231: INTO l_quantity_layer_id
1232: FROM dual;
1233:
1234: ------------------------------------------------
1235: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --
1236: ------------------------------------------------
1237: l_stmt_num := 50;
1238: INSERT INTO cst_pac_quantity_layers (
1239: quantity_layer_id,

Line 1238: INSERT INTO cst_pac_quantity_layers (

1234: ------------------------------------------------
1235: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --
1236: ------------------------------------------------
1237: l_stmt_num := 50;
1238: INSERT INTO cst_pac_quantity_layers (
1239: quantity_layer_id,
1240: cost_layer_id,
1241: pac_period_id,
1242: cost_group_id,

Line 1270: FROM cst_pac_quantity_layers cpql

1266: i_prog_app_id,
1267: i_prog_id,
1268: SYSDATE,
1269: i_login_id
1270: FROM cst_pac_quantity_layers cpql
1271: WHERE cpql.quantity_layer_id = l_prior_period_qty.quantity_layer_id;
1272:
1273: -- =============================================================================
1274: -- Bug 4028737 fix:

Line 1278: UPDATE cst_pac_quantity_layers

1274: -- Bug 4028737 fix:
1275: -- Update begin_layer_quantity with cpic.total_layer_quantity of previous period
1276: -- =============================================================================
1277: l_stmt_num := 55;
1278: UPDATE cst_pac_quantity_layers
1279: SET begin_layer_quantity = (SELECT total_layer_quantity
1280: FROM cst_pac_item_costs
1281: WHERE cost_layer_id = l_prior_period_cost.cost_layer_id)
1282: WHERE quantity_layer_id = l_quantity_layer_id;

Line 1779: cst_pac_quantity_layers cpql

1775: )
1776: )
1777: FROM mtl_pac_txn_cost_details mptcd,
1778: cst_pac_item_cost_details cpicd,
1779: cst_pac_quantity_layers cpql
1780: WHERE mptcd.transaction_id = i_txn_id
1781: AND mptcd.pac_period_id = i_pac_period_id
1782: AND mptcd.cost_group_id = i_cost_group_id
1783: AND cpql.cost_layer_id = i_cost_layer_id

Line 1919: * The layer qty can be obtained from cst_pac_quantity_layers

1915: * For a value change periodic update cost transaction,
1916: * update the primary_quantity in mmt to the layer quantity from cpql.
1917: * Prior to this, the quantity at the beginning of the period was being
1918: * used and this caused errors in the distributions.
1919: * The layer qty can be obtained from cst_pac_quantity_layers
1920: */
1921:
1922: l_stmt_num := 60;
1923: if (l_update_flag = 0) then -- If value change is not null

Line 1926: from cst_pac_quantity_layers

1922: l_stmt_num := 60;
1923: if (l_update_flag = 0) then -- If value change is not null
1924: select nvl(layer_quantity,0)
1925: into l_onhand
1926: from cst_pac_quantity_layers
1927: where cost_group_id = i_cost_group_id and
1928: pac_period_id = i_pac_period_id and
1929: inventory_item_id = i_item_id;
1930: