APPS.CSTPUPDT dependencies on CST_ITEM_COSTS

Line 18: + ORDERED USE_NL(CIC CL) INDEX(CL CST_LISTS_U1) INDEX(CIC CST_ITEM_COSTS_U1)

14: status number;
15: L_NO_DATA_FOUND number := 100;
16:
17: /* Removed hint from follwing Insert stmt for POSCO issue: Bug #1665358.
18: + ORDERED USE_NL(CIC CL) INDEX(CL CST_LISTS_U1) INDEX(CIC CST_ITEM_COSTS_U1)
19: */
20: CURSOR cc is
21: SELECT
22: CIC.INVENTORY_ITEM_ID

Line 25: CST_ITEM_COSTS CIC

21: SELECT
22: CIC.INVENTORY_ITEM_ID
23: FROM
24: CST_LISTS CL,
25: CST_ITEM_COSTS CIC
26: WHERE CIC.ORGANIZATION_ID = l_organization_id
27: AND CIC.COST_TYPE_ID = l_cost_type_id
28: AND CL.LIST_ID = l_list_id
29: AND CL.ENTITY_ID = CIC.INVENTORY_ITEM_ID

Line 87: if table_name = 'CST_ITEM_COSTS' then

83: AND CRO.COST_TYPE_ID = l_cost_type_id
84: FOR UPDATE OF CRO.LAST_UPDATED_BY NOWAIT;
85:
86: BEGIN
87: if table_name = 'CST_ITEM_COSTS' then
88: OPEN cc;
89: status := SQLCODE;
90: elsif table_name = 'CST_ITEM_COST_DETAILS' then
91: OPEN cd;

Line 128: ** Lock the table of CST_ITEM_COSTS

124: resource busy and acquire with NOWAIT specified */
125: counter number := 0;
126: BEGIN
127: /*
128: ** Lock the table of CST_ITEM_COSTS
129: */
130: while (counter < NUM_TRIES and status = -54) LOOP
131: status := CSTPUPDT.cstulock('CST_ITEM_COSTS',l_cost_type_id,
132: l_organization_id,

Line 131: status := CSTPUPDT.cstulock('CST_ITEM_COSTS',l_cost_type_id,

127: /*
128: ** Lock the table of CST_ITEM_COSTS
129: */
130: while (counter < NUM_TRIES and status = -54) LOOP
131: status := CSTPUPDT.cstulock('CST_ITEM_COSTS',l_cost_type_id,
132: l_organization_id,
133: l_list_id,err_buf);
134: if status = -54 then
135: DBMS_LOCK.SLEEP(SLEEP_TIME);

Line 252: FROM cst_item_costs cic

248: return_code number;
249:
250: CURSOR del_cur1 IS
251: SELECT inventory_item_id
252: FROM cst_item_costs cic
253: WHERE cic.organization_id = l_organization_id
254: AND cic.cost_type_id = l_cost_type_id;
255:
256: BEGIN

Line 258: DELETE CST_ITEM_COSTS cic

254: AND cic.cost_type_id = l_cost_type_id;
255:
256: BEGIN
257: FOR del_cic_cur IN del_cur1 loop
258: DELETE CST_ITEM_COSTS cic
259: WHERE organization_id = l_organization_id
260: AND cost_type_id = 1
261: AND inventory_item_id = del_cic_cur.inventory_item_id;
262: END LOOP;

Line 286: FROM cst_item_costs_temp cict;

282: return_code number;
283:
284: CURSOR del_cur2 IS
285: SELECT inventory_item_id
286: FROM cst_item_costs_temp cict;
287:
288: BEGIN
289: FOR del_cicd_cur IN del_cur2 loop
290: DELETE CST_ITEM_COST_DETAILS cicd

Line 434: TYPE cilt_item_tbl_type IS TABLE OF cst_item_costs.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

430: RETURN INTEGER IS
431:
432: return_code number;
433:
434: TYPE cilt_item_tbl_type IS TABLE OF cst_item_costs.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
435: cilt_item_id cilt_item_tbl_type ;
436:
437: bulk_limit NUMBER := 2000;
438: l_stmt_num NUMBER;

Line 442: FROM CST_ITEM_COSTS CIC1,

438: l_stmt_num NUMBER;
439:
440: CURSOR CILT_CUR is
441: SELECT CIC1.inventory_item_id
442: FROM CST_ITEM_COSTS CIC1,
443: CST_ITEM_COSTS CIC2,
444: CST_ITEM_LIST_TEMP CLT
445: WHERE CIC1.organization_id = l_org_id
446: AND CIC1.cost_type_id = b_cm_frozen_standard

Line 443: CST_ITEM_COSTS CIC2,

439:
440: CURSOR CILT_CUR is
441: SELECT CIC1.inventory_item_id
442: FROM CST_ITEM_COSTS CIC1,
443: CST_ITEM_COSTS CIC2,
444: CST_ITEM_LIST_TEMP CLT
445: WHERE CIC1.organization_id = l_org_id
446: AND CIC1.cost_type_id = b_cm_frozen_standard
447: AND CIC1.inventory_item_id = CLT.inventory_item_id