APPS.CSTPUPDT dependencies on DBMS_LOCK

Line 135: DBMS_LOCK.SLEEP(SLEEP_TIME);

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);
136: end if;
137: counter := counter + 1;
138: end LOOP;
139: if status <> 0 then

Line 156: DBMS_LOCK.SLEEP(SLEEP_TIME);

152: l_cost_type_id,
153: l_organization_id,
154: l_list_id,err_buf);
155: if status = -54 then
156: DBMS_LOCK.SLEEP(SLEEP_TIME);
157: end if;
158: counter := counter + 1;
159: end LOOP;
160: if status <> 0 then

Line 178: DBMS_LOCK.SLEEP(SLEEP_TIME);

174: l_cost_type_id,
175: l_organization_id,
176: l_res_list_id, err_buf);
177: if status = -54 then
178: DBMS_LOCK.SLEEP(SLEEP_TIME);
179: end if;
180: counter := counter + 1;
181: end LOOP;
182: if status <> 0 then

Line 199: DBMS_LOCK.SLEEP(SLEEP_TIME);

195: l_cost_type_id,
196: l_organization_id,
197: l_ovh_list_id, err_buf);
198: if status = -54 then
199: DBMS_LOCK.SLEEP(SLEEP_TIME);
200: end if;
201: counter := counter + 1;
202: end LOOP;
203: if status <> 0 then

Line 220: DBMS_LOCK.SLEEP(SLEEP_TIME);

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
220: DBMS_LOCK.SLEEP(SLEEP_TIME);
221: end if;
222: counter := counter + 1;
223: end LOOP;
224: if status <> 0 then