APPS.CSTPUPDT dependencies on CSTPUPDT

Line 1: PACKAGE BODY CSTPUPDT AS

1: PACKAGE BODY CSTPUPDT AS
2: /* $Header: CSTPUPDB.pls 120.2 2011/12/19 09:25:12 pregoel ship $ */
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 543: err_buf := 'cstpupdt.cst_del_cilt (' || l_stmt_num || ')' || substrb(sqlerrm,1,60);

539:
540: EXCEPTION
541: WHEN OTHERS THEN
542: return_code := SQLCODE;
543: err_buf := 'cstpupdt.cst_del_cilt (' || l_stmt_num || ')' || substrb(sqlerrm,1,60);
544: return(return_code);
545: END cst_del_cilt;
546:
547: END CSTPUPDT;

Line 547: END CSTPUPDT;

543: err_buf := 'cstpupdt.cst_del_cilt (' || l_stmt_num || ')' || substrb(sqlerrm,1,60);
544: return(return_code);
545: END cst_del_cilt;
546:
547: END CSTPUPDT;
548: