DBA Data[Home] [Help]

APPS.CSTPUPDT dependencies on CST_RESOURCE_OVERHEADS

Line 77: CST_RESOURCE_OVERHEADS CRO

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
81: AND CLT2.LIST_ID = l_list_id1

Line 99: elsif table_name = 'CST_RESOURCE_OVERHEADS' then

95: status := SQLCODE;
96: elsif table_name = 'CST_DEPARTMENT_OVERHEADS' then
97: OPEN cdo;
98: status := SQLCODE;
99: elsif table_name = 'CST_RESOURCE_OVERHEADS' then
100: OPEN cro;
101: status := SQLCODE;
102: else
103: status := L_NO_DATA_FOUND;

Line 211: ** Lock the table of CST_RESOURCE_OVERHEADS

207: end if;
208: return(status);
209: end if;
210: /*
211: ** Lock the table of CST_RESOURCE_OVERHEADS
212: */
213: status := -54;
214: while (counter < NUM_TRIES and status = -54) LOOP
215: status := cstpupdt.cstulock('CST_RESOURCE_OVERHEADS',

Line 215: status := cstpupdt.cstulock('CST_RESOURCE_OVERHEADS',

211: ** Lock the table of CST_RESOURCE_OVERHEADS
212: */
213: status := -54;
214: while (counter < NUM_TRIES and status = -54) LOOP
215: status := cstpupdt.cstulock('CST_RESOURCE_OVERHEADS',
216: l_cost_type_id,
217: l_organization_id,
218: l_res_list_id, err_buf, l_ovh_list_id);
219: if status = -54 then