APPS.OEXPURGE dependencies on SO_ORDER_HOLDS

Line 1025: FROM so_order_holds

1021: CURSOR purge_holds IS
1022: SELECT DISTINCT NVL( hold_release_id, 0 ),
1023: NVL( hold_source_id, 0 ),
1024: order_hold_id
1025: FROM so_order_holds
1026: WHERE header_id = p_header_id;
1027: BEGIN
1028: OPEN purge_holds;
1029:

Line 1050: FROM so_order_holds

1046:
1047: IF return_status > -1 THEN
1048: SELECT header_id
1049: INTO syntax_required
1050: FROM so_order_holds
1051: WHERE order_hold_id = v_order_hold_id
1052: FOR UPDATE NOWAIT;
1053:
1054: DELETE FROM so_order_holds

Line 1054: DELETE FROM so_order_holds

1050: FROM so_order_holds
1051: WHERE order_hold_id = v_order_hold_id
1052: FOR UPDATE NOWAIT;
1053:
1054: DELETE FROM so_order_holds
1055: WHERE order_hold_id = v_order_hold_id;
1056: ELSE
1057: EXIT; -- abort additional processing
1058: END IF;

Line 1072: 'OEPUR: SO_ORDER_HOLDS',

1068: ROLLBACK;
1069: so_record_errors( return_status,
1070: p_request_id,
1071: v_order_hold_id,
1072: 'OEPUR: SO_ORDER_HOLDS',
1073: NULL );
1074: CLOSE purge_holds;
1075: RETURN return_status;
1076: