APPS.CSTPUPDT dependencies on CSTPUPDT

Line 1: PACKAGE BODY CSTPUPDT AS

1: PACKAGE BODY CSTPUPDT AS
2: /* $Header: CSTPUPDB.pls 120.1 2006/02/14 17:03:10 ssreddy noship $ */
3:
4: FUNCTION cstulock (
5: table_name in varchar2,

Line 131: status := CSTPUPDT.cstulock('CST_ITEM_COSTS',l_cost_type_id,

127: /*
128: ** Lock the table of CST_ITEM_COSTS
129: */
130: while (counter < NUM_TRIES and status = -54) LOOP
131: status := CSTPUPDT.cstulock('CST_ITEM_COSTS',l_cost_type_id,
132: l_organization_id,
133: l_list_id,err_buf);
134: if status = -54 then
135: DBMS_LOCK.SLEEP(SLEEP_TIME);

Line 151: status := cstpupdt.cstulock('CST_ITEM_COST_DETAILS',

147: ** Lock the table of CST_ITEM_COST_DETAILS
148: */
149: status := -54;
150: while (counter < NUM_TRIES and status = -54) LOOP
151: status := cstpupdt.cstulock('CST_ITEM_COST_DETAILS',
152: l_cost_type_id,
153: l_organization_id,
154: l_list_id,err_buf);
155: if status = -54 then

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

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

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

Line 426: END CSTPUPDT;

422: return(return_code);
423: END cstudlc3;
424:
425:
426: END CSTPUPDT;
427: