DBA Data[Home] [Help]

APPS.CSTPSCCR dependencies on DBMS_LOCK

Line 549: DBMS_LOCK.SLEEP(SLEEP_TIME);

545: status := CSTPSCCR.cstrlock('CST_ITEM_COSTS',l_dest_cost_type_id,
546: l_default_cost_type_id,
547: l_rollup_id,err_buf,l_locking_flag);
548: if status = -54 then
549: DBMS_LOCK.SLEEP(SLEEP_TIME);
550: end if;
551: counter := counter + 1;
552: END LOOP;
553: end if;

Line 579: DBMS_LOCK.SLEEP(SLEEP_TIME);

575: status := CSTPSCCR.cstrlock('CST_ITEM_COST_DETAILS',
576: l_dest_cost_type_id, l_default_cost_type_id,
577: l_rollup_id,err_buf,l_locking_flag);
578: if status = -54 then
579: DBMS_LOCK.SLEEP(SLEEP_TIME);
580: end if;
581: counter := counter + 1;
582: END LOOP;
583: end if;