[Home] [Help]
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
20: CURSOR cc is
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
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
35: CURSOR cd is
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
47: CURSOR crc is
48: SELECT
49: CRC.RESOURCE_ID
50: FROM
51: CST_LISTS_TEMP CLT,
52: CST_RESOURCE_COSTS CRC
53: WHERE CRC.ORGANIZATION_ID = l_organization_id
54: AND CLT.LIST_ID = l_list_id
55: AND CLT.NUMBER_1 = CRC.RESOURCE_ID
59: CURSOR cdo is
60: SELECT
61: CDO.DEPARTMENT_ID
62: FROM
63: CST_LISTS_TEMP CLT,
64: CST_DEPARTMENT_OVERHEADS CDO
65: WHERE CDO.ORGANIZATION_ID = l_organization_id
66: AND CLT.LIST_ID = l_list_id
67: AND CLT.NUMBER_1 = CDO.OVERHEAD_ID
71: CURSOR cro is
72: SELECT
73: CRO.RESOURCE_ID
74: FROM
75: CST_LISTS_TEMP CLT1,
76: CST_LISTS_TEMP CLT2,
77: CST_RESOURCE_OVERHEADS CRO
78: WHERE CRO.ORGANIZATION_ID = l_organization_id
79: AND CLT1.LIST_ID = l_list_id
72: SELECT
73: CRO.RESOURCE_ID
74: FROM
75: CST_LISTS_TEMP CLT1,
76: CST_LISTS_TEMP CLT2,
77: CST_RESOURCE_OVERHEADS CRO
78: WHERE CRO.ORGANIZATION_ID = l_organization_id
79: AND CLT1.LIST_ID = l_list_id
80: AND CLT1.NUMBER_1 = CRO.RESOURCE_ID