APPS.CSTPCINT dependencies on CST_ITEM_COSTS

Line 14: * Resolve all ORGANIZATION_CODE in CST_ITEM_COSTS_INTERFACE.

10:
11: BEGIN
12:
13: /*
14: * Resolve all ORGANIZATION_CODE in CST_ITEM_COSTS_INTERFACE.
15: * This must be done first, before the following updates.
16: *
17: */
18: UPDATE CST_ITEM_COSTS_INTERFACE CICI

Line 18: UPDATE CST_ITEM_COSTS_INTERFACE CICI

14: * Resolve all ORGANIZATION_CODE in CST_ITEM_COSTS_INTERFACE.
15: * This must be done first, before the following updates.
16: *
17: */
18: UPDATE CST_ITEM_COSTS_INTERFACE CICI
19: SET
20: CICI.ORGANIZATION_ID = (
21: SELECT MP.ORGANIZATION_ID
22: FROM MTL_PARAMETERS MP

Line 29: * CST_ITEM_COSTS_INTERFACE.

25: WHERE CICI.GROUP_ID = i_group_id;
26:
27: /*
28: * Resolve all INVENTORY_ITEM_ID and COST_TYPE_ID in
29: * CST_ITEM_COSTS_INTERFACE.
30: *
31: * This must be done after the ORGANIZATION_ID is resolved.
32: */
33: location := 2;

Line 42: UPDATE CST_ITEM_COSTS_INTERFACE CICI

38: * and there are no good indices to use. Therefore the performance
39: * of the following update statement is BAD.
40: */
41:
42: UPDATE CST_ITEM_COSTS_INTERFACE CICI
43: SET
44: INVENTORY_ITEM_ID = (
45: SELECT MIF.ITEM_ID
46: FROM MTL_ITEM_FLEXFIELDS MIF

Line 53: UPDATE CST_ITEM_COSTS_INTERFACE CICI

49: )
50: WHERE CICI.GROUP_ID = i_group_id
51: AND CICI.INVENTORY_ITEM_ID IS NULL;
52:
53: UPDATE CST_ITEM_COSTS_INTERFACE CICI
54: SET
55: COST_TYPE_ID = (
56: SELECT CCT.COST_TYPE_ID
57: FROM CST_COST_TYPES CCT

Line 322: INSERT INTO CST_ITEM_COSTS (

318: BEGIN
319:
320: location := 0;
321:
322: INSERT INTO CST_ITEM_COSTS (
323: INVENTORY_ITEM_ID,
324: ORGANIZATION_ID,
325: COST_TYPE_ID,
326: LAST_UPDATE_DATE,

Line 432: FROM CST_ITEM_COSTS_INTERFACE CICI

428: i_request_id,
429: i_prog_applid,
430: i_prog_id,
431: SYSDATE
432: FROM CST_ITEM_COSTS_INTERFACE CICI
433: WHERE CICI.GROUP_ID = i_group_id;
434:
435: i_rowcount := SQL%ROWCOUNT;
436:

Line 564: DELETE FROM CST_ITEM_COSTS_INTERFACE CICI

560: BEGIN
561:
562: location := 0;
563:
564: DELETE FROM CST_ITEM_COSTS_INTERFACE CICI
565: WHERE CICI.GROUP_ID = i_group_id;
566:
567: location := 1;
568: