APPS.OEXPURGE dependencies on SO_PICKING_LINES

Line 1271: FROM so_picking_lines

1267: v_picking_line_id NUMBER := 0;
1268:
1269: CURSOR purge_lines IS
1270: SELECT picking_line_id
1271: FROM so_picking_lines
1272: WHERE picking_header_id = p_picking_header_id;
1273: BEGIN
1274:
1275: OPEN purge_lines;

Line 1286: FROM so_picking_lines

1282: OR purge_lines%NOTFOUND IS NULL; -- empty cursor
1283:
1284: SELECT picking_line_id -- Lock rows to be purged
1285: INTO syntax_required
1286: FROM so_picking_lines
1287: WHERE picking_line_id = v_picking_line_id
1288: FOR UPDATE NOWAIT;
1289:
1290: return_status := so_purge_picking_line_details( v_picking_line_id,

Line 1298: DELETE FROM so_picking_lines

1294: p_request_id );
1295: END IF;
1296:
1297: IF return_status > -1 THEN
1298: DELETE FROM so_picking_lines
1299: WHERE picking_line_id = v_picking_line_id;
1300: ELSE
1301: EXIT; -- abort additional processing
1302: END IF;

Line 1316: 'OEPUR: SO_PICKING_LINES',

1312: ROLLBACK;
1313: so_record_errors( return_status,
1314: p_request_id,
1315: v_picking_line_id,
1316: 'OEPUR: SO_PICKING_LINES',
1317: NULL );
1318: CLOSE purge_lines;
1319: RETURN return_status;
1320:

Line 1334: FROM so_picking_lines spl, so_lines sl

1330: v_picking_line_id NUMBER := 0;
1331:
1332: CURSOR purge_backorder_lines IS
1333: SELECT picking_line_id
1334: FROM so_picking_lines spl, so_lines sl
1335: WHERE spl.picking_header_id = -1
1336: AND sl.line_id = spl.order_line_id
1337: AND sl.header_id = p_header_id;
1338: BEGIN

Line 1351: FROM so_picking_lines

1347: OR purge_backorder_lines%NOTFOUND IS NULL; -- empty cursor
1348:
1349: SELECT picking_line_id -- Lock rows to be purged
1350: INTO syntax_required
1351: FROM so_picking_lines
1352: WHERE picking_line_id = v_picking_line_id
1353: FOR UPDATE NOWAIT;
1354:
1355: return_status := so_purge_picking_line_details( v_picking_line_id,

Line 1362: DELETE FROM so_picking_lines

1358: return_status:=so_purge_picking_cancellations(v_picking_line_id,
1359: p_request_id );
1360: END IF;
1361: IF return_status > -1 THEN
1362: DELETE FROM so_picking_lines
1363: WHERE picking_line_id = v_picking_line_id;
1364: ELSE
1365: EXIT; -- abort additional processing
1366: END IF;

Line 1380: 'OEPUR: SO_PICKING_LINES',

1376: ROLLBACK;
1377: so_record_errors( return_status,
1378: p_request_id,
1379: v_picking_line_id,
1380: 'OEPUR: SO_PICKING_LINES',
1381: NULL );
1382: CLOSE purge_backorder_lines;
1383: RETURN return_status;
1384: