APPS.CSTPUPDT dependencies on CST_RESOURCE_COSTS

Line 52: CST_RESOURCE_COSTS CRC

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
56: AND CRC.COST_TYPE_ID = l_cost_type_id

Line 93: elsif table_name = 'CST_RESOURCE_COSTS' then

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;
95: status := SQLCODE;
96: elsif table_name = 'CST_DEPARTMENT_OVERHEADS' then
97: OPEN cdo;

Line 169: ** Lock the table of CST_RESOURCE_COSTS

165: return(status);
166: end if;
167: if (l_res_list_id is not null and l_ovh_list_id is not null) then
168: /*
169: ** Lock the table of CST_RESOURCE_COSTS
170: */
171: status := -54;
172: while (counter < NUM_TRIES and status = -54) LOOP
173: status := cstpupdt.cstulock('CST_RESOURCE_COSTS',

Line 173: status := cstpupdt.cstulock('CST_RESOURCE_COSTS',

169: ** Lock the table of CST_RESOURCE_COSTS
170: */
171: status := -54;
172: while (counter < NUM_TRIES and status = -54) LOOP
173: status := cstpupdt.cstulock('CST_RESOURCE_COSTS',
174: l_cost_type_id,
175: l_organization_id,
176: l_res_list_id, err_buf);
177: if status = -54 then