DBA Data[Home] [Help]

APPS.OEXPURGE dependencies on SO_FREIGHT_CHARGES

Line 442: FROM so_freight_charges

438: syntax_required NUMBER := 0;
439:
440: CURSOR SO_LOCK_RECORDS IS
441: SELECT picking_header_id
442: FROM so_freight_charges
443: WHERE picking_header_id = p_picking_header_id
444: FOR UPDATE NOWAIT;
445: BEGIN
446: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged

Line 449: DELETE FROM so_freight_charges -- Delete all rows to be purged

445: BEGIN
446: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged
447: CLOSE SO_LOCK_RECORDS;
448:
449: DELETE FROM so_freight_charges -- Delete all rows to be purged
450: WHERE picking_header_id = p_picking_header_id;
451:
452: RETURN SQLCODE;
453:

Line 461: 'OEPUR: SO_FREIGHT_CHARGES',

457: ROLLBACK;
458: so_record_errors( return_status,
459: p_request_id,
460: p_picking_header_id,
461: 'OEPUR: SO_FREIGHT_CHARGES',
462: NULL );
463: CLOSE SO_LOCK_RECORDS;
464: RETURN return_status;
465: