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 1084: -- 3. cst_pac_quantity_layers --

1080: --------------------------------------------------------------------------------
1081: -- Copy data from previous period to current period of the following tables : --
1082: -- 1. cst_pac_item_costs --
1083: -- 2. cst_pac_item_cost_details --
1084: -- 3. cst_pac_quantity_layers --
1085: -- New cost_layer_id and quantity_layer_id are generated for every rows --
1086: -- inserted. --
1087: --------------------------------------------------------------------------------
1088: FOR l_prior_period_cost IN prior_period_cost_cursor LOOP

Line 1225: SELECT cst_pac_quantity_layers_s.nextval

1221:
1222: FOR l_prior_period_qty IN
1223: prior_period_quantity_cursor (l_prior_period_cost.cost_layer_id) LOOP
1224:
1225: SELECT cst_pac_quantity_layers_s.nextval
1226: INTO l_quantity_layer_id
1227: FROM dual;
1228:
1229: ------------------------------------------------

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

1226: INTO l_quantity_layer_id
1227: FROM dual;
1228:
1229: ------------------------------------------------
1230: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --
1231: ------------------------------------------------
1232: l_stmt_num := 50;
1233: INSERT INTO cst_pac_quantity_layers (
1234: quantity_layer_id,

Line 1233: INSERT INTO cst_pac_quantity_layers (

1229: ------------------------------------------------
1230: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --
1231: ------------------------------------------------
1232: l_stmt_num := 50;
1233: INSERT INTO cst_pac_quantity_layers (
1234: quantity_layer_id,
1235: cost_layer_id,
1236: pac_period_id,
1237: cost_group_id,

Line 1265: FROM cst_pac_quantity_layers cpql

1261: i_prog_app_id,
1262: i_prog_id,
1263: SYSDATE,
1264: i_login_id
1265: FROM cst_pac_quantity_layers cpql
1266: WHERE cpql.quantity_layer_id = l_prior_period_qty.quantity_layer_id;
1267:
1268: -- =============================================================================
1269: -- Bug 4028737 fix:

Line 1273: UPDATE cst_pac_quantity_layers

1269: -- Bug 4028737 fix:
1270: -- Update begin_layer_quantity with cpic.total_layer_quantity of previous period
1271: -- =============================================================================
1272: l_stmt_num := 55;
1273: UPDATE cst_pac_quantity_layers
1274: SET begin_layer_quantity = (SELECT total_layer_quantity
1275: FROM cst_pac_item_costs
1276: WHERE cost_layer_id = l_prior_period_cost.cost_layer_id)
1277: WHERE quantity_layer_id = l_quantity_layer_id;

Line 1774: cst_pac_quantity_layers cpql

1770: )
1771: )
1772: FROM mtl_pac_txn_cost_details mptcd,
1773: cst_pac_item_cost_details cpicd,
1774: cst_pac_quantity_layers cpql
1775: WHERE mptcd.transaction_id = i_txn_id
1776: AND mptcd.pac_period_id = i_pac_period_id
1777: AND mptcd.cost_group_id = i_cost_group_id
1778: AND cpql.cost_layer_id = i_cost_layer_id

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

1910: * For a value change periodic update cost transaction,
1911: * update the primary_quantity in mmt to the layer quantity from cpql.
1912: * Prior to this, the quantity at the beginning of the period was being
1913: * used and this caused errors in the distributions.
1914: * The layer qty can be obtained from cst_pac_quantity_layers
1915: */
1916:
1917: l_stmt_num := 60;
1918:

Line 1921: from cst_pac_quantity_layers

1917: l_stmt_num := 60;
1918:
1919: select nvl(layer_quantity,0)
1920: into l_onhand
1921: from cst_pac_quantity_layers
1922: where cost_group_id = i_cost_group_id and
1923: pac_period_id = i_pac_period_id and
1924: inventory_item_id = i_item_id;
1925: