APPS.OE_ORDER_PURGE_PVT dependencies on OE_LINE_SETS

Line 3291: FROM OE_LINE_SETS

3287: IS
3288:
3289: CURSOR c_line_sets IS
3290: SELECT LINE_ID,SET_ID
3291: FROM OE_LINE_SETS
3292: WHERE LINE_ID = p_line_id;
3293:
3294: l_set_id NUMBER;
3295: l_line_id NUMBER;

Line 3314: FROM oe_line_sets

3310:
3311: -- Lock the line sets record.
3312: SELECT set_id,line_id
3313: INTO l_lock_set_id,l_lock_line_id
3314: FROM oe_line_sets
3315: WHERE set_id = l_set_id
3316: AND line_id = l_line_id
3317: FOR UPDATE NOWAIT;
3318:

Line 3319: DELETE FROM OE_LINE_SETS

3315: WHERE set_id = l_set_id
3316: AND line_id = l_line_id
3317: FOR UPDATE NOWAIT;
3318:
3319: DELETE FROM OE_LINE_SETS
3320: WHERE SET_ID = l_set_id
3321: AND LINE_ID = l_line_id;
3322:
3323: END LOOP;