APPS.CSTPUPDT dependencies on CST_ITEM_COST_DETAILS

Line 33: + ORDERED USE_NL(CICD CL) INDEX(CL CST_LISTS_U1) INDEX(CICD CST_ITEM_COST_DETAILS_N1)

29: AND CL.ENTITY_ID = CIC.INVENTORY_ITEM_ID
30: FOR UPDATE OF CIC.LAST_UPDATED_BY NOWAIT;
31:
32: /* Removed hint from follwing Insert stmt for POSCO issue: Bug #1665358.
33: + ORDERED USE_NL(CICD CL) INDEX(CL CST_LISTS_U1) INDEX(CICD CST_ITEM_COST_DETAILS_N1)
34: */
35: CURSOR cd is
36: SELECT
37: CICD.INVENTORY_ITEM_ID

Line 40: CST_ITEM_COST_DETAILS CICD

36: SELECT
37: CICD.INVENTORY_ITEM_ID
38: FROM
39: CST_LISTS CL,
40: CST_ITEM_COST_DETAILS CICD
41: WHERE CICD.ORGANIZATION_ID = l_organization_id
42: AND CL.LIST_ID = l_list_id
43: AND CL.ENTITY_ID = CICD.INVENTORY_ITEM_ID
44: AND CICD.COST_TYPE_ID = l_cost_type_id

Line 90: elsif table_name = 'CST_ITEM_COST_DETAILS' then

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;
92: status := SQLCODE;
93: elsif table_name = 'CST_RESOURCE_COSTS' then
94: OPEN crc;

Line 147: ** Lock the table of CST_ITEM_COST_DETAILS

143: end if;
144: return(status);
145: end if;
146: /*
147: ** Lock the table of CST_ITEM_COST_DETAILS
148: */
149: status := -54;
150: while (counter < NUM_TRIES and status = -54) LOOP
151: status := cstpupdt.cstulock('CST_ITEM_COST_DETAILS',

Line 151: status := cstpupdt.cstulock('CST_ITEM_COST_DETAILS',

147: ** Lock the table of CST_ITEM_COST_DETAILS
148: */
149: status := -54;
150: while (counter < NUM_TRIES and status = -54) LOOP
151: status := cstpupdt.cstulock('CST_ITEM_COST_DETAILS',
152: l_cost_type_id,
153: l_organization_id,
154: l_list_id,err_buf);
155: if status = -54 then

Line 290: DELETE CST_ITEM_COST_DETAILS cicd

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
291: WHERE organization_id = l_organization_id
292: AND cost_type_id = 1
293: AND inventory_item_id = del_cicd_cur.inventory_item_id;
294: END LOOP;