956: /*Added by CSahoo, BUG 5344225*/
957: IF lv_profile_val <> 'BATCH' THEN
958:
959: IF
960: ( jai_rcv_trx_processing_pkg.gv_shipment_header_id is null
961: OR
962: (jai_rcv_trx_processing_pkg.gv_shipment_header_id is not null
963: AND
964: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)
958:
959: IF
960: ( jai_rcv_trx_processing_pkg.gv_shipment_header_id is null
961: OR
962: (jai_rcv_trx_processing_pkg.gv_shipment_header_id is not null
963: AND
964: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)
965: )
966: or
960: ( jai_rcv_trx_processing_pkg.gv_shipment_header_id is null
961: OR
962: (jai_rcv_trx_processing_pkg.gv_shipment_header_id is not null
963: AND
964: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)
965: )
966: or
967: ( jai_rcv_trx_processing_pkg.gv_group_id is null
968: OR
963: AND
964: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)
965: )
966: or
967: ( jai_rcv_trx_processing_pkg.gv_group_id is null
968: OR
969: (jai_rcv_trx_processing_pkg.gv_group_id is not null
970: AND
971: NVL(jai_rcv_trx_processing_pkg.gv_group_id,0) <> pr_new.group_id)
965: )
966: or
967: ( jai_rcv_trx_processing_pkg.gv_group_id is null
968: OR
969: (jai_rcv_trx_processing_pkg.gv_group_id is not null
970: AND
971: NVL(jai_rcv_trx_processing_pkg.gv_group_id,0) <> pr_new.group_id)
972: )
973: THEN
967: ( jai_rcv_trx_processing_pkg.gv_group_id is null
968: OR
969: (jai_rcv_trx_processing_pkg.gv_group_id is not null
970: AND
971: NVL(jai_rcv_trx_processing_pkg.gv_group_id,0) <> pr_new.group_id)
972: )
973: THEN
974:
975: IF lv_profile_val = 'IMMEDIATE' THEN
1013: '', '', '', '', '', '', '', '', '', '',
1014: '', '', '', '', '', '', '', '', '', '',
1015: '', '', '', '', '', '', '', ''
1016: );
1017: jai_rcv_trx_processing_pkg.gv_shipment_header_id := pr_new.shipment_header_id ;
1018: jai_rcv_trx_processing_pkg.gv_group_id := pr_new.group_id ;
1019: END IF;
1020: END IF;
1021:
1014: '', '', '', '', '', '', '', '', '', '',
1015: '', '', '', '', '', '', '', ''
1016: );
1017: jai_rcv_trx_processing_pkg.gv_shipment_header_id := pr_new.shipment_header_id ;
1018: jai_rcv_trx_processing_pkg.gv_group_id := pr_new.group_id ;
1019: END IF;
1020: END IF;
1021:
1022: