DBA Data[Home] [Help]

APPS.CSTPUPDT dependencies on CST_DEPARTMENT_OVERHEADS

Line 64: CST_DEPARTMENT_OVERHEADS CDO

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
68: AND CDO.COST_TYPE_ID = l_cost_type_id

Line 96: elsif table_name = 'CST_DEPARTMENT_OVERHEADS' then

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;
98: status := SQLCODE;
99: elsif table_name = 'CST_RESOURCE_OVERHEADS' then
100: OPEN cro;

Line 190: ** Lock the table of CST_DEPARTMENT_OVERHEADS

186: end if;
187: return(status);
188: end if;
189: /*
190: ** Lock the table of CST_DEPARTMENT_OVERHEADS
191: */
192: status := -54;
193: while (counter < NUM_TRIES and status = -54) LOOP
194: status := cstpupdt.cstulock('CST_DEPARTMENT_OVERHEADS',

Line 194: status := cstpupdt.cstulock('CST_DEPARTMENT_OVERHEADS',

190: ** Lock the table of CST_DEPARTMENT_OVERHEADS
191: */
192: status := -54;
193: while (counter < NUM_TRIES and status = -54) LOOP
194: status := cstpupdt.cstulock('CST_DEPARTMENT_OVERHEADS',
195: l_cost_type_id,
196: l_organization_id,
197: l_ovh_list_id, err_buf);
198: if status = -54 then