DBA Data[Home] [Help]

APPS.JAI_RCV_RT_TRIGGER_PKG dependencies on JAI_RCV_TRX_PROCESSING_PKG

Line 1114: ( jai_rcv_trx_processing_pkg.gv_shipment_header_id is null

1110: /*Added by CSahoo, BUG 5344225*/
1111: IF lv_profile_val <> 'BATCH' THEN
1112:
1113: IF
1114: ( jai_rcv_trx_processing_pkg.gv_shipment_header_id is null
1115: OR
1116: (jai_rcv_trx_processing_pkg.gv_shipment_header_id is not null
1117: AND
1118: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)

Line 1116: (jai_rcv_trx_processing_pkg.gv_shipment_header_id is not null

1112:
1113: IF
1114: ( jai_rcv_trx_processing_pkg.gv_shipment_header_id is null
1115: OR
1116: (jai_rcv_trx_processing_pkg.gv_shipment_header_id is not null
1117: AND
1118: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)
1119: )
1120: or

Line 1118: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)

1114: ( jai_rcv_trx_processing_pkg.gv_shipment_header_id is null
1115: OR
1116: (jai_rcv_trx_processing_pkg.gv_shipment_header_id is not null
1117: AND
1118: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)
1119: )
1120: or
1121: ( jai_rcv_trx_processing_pkg.gv_group_id is null
1122: OR

Line 1121: ( jai_rcv_trx_processing_pkg.gv_group_id is null

1117: AND
1118: NVL(jai_rcv_trx_processing_pkg.gv_shipment_header_id,0) <> pr_new.shipment_header_id)
1119: )
1120: or
1121: ( jai_rcv_trx_processing_pkg.gv_group_id is null
1122: OR
1123: (jai_rcv_trx_processing_pkg.gv_group_id is not null
1124: AND
1125: NVL(jai_rcv_trx_processing_pkg.gv_group_id,0) <> pr_new.group_id)

Line 1123: (jai_rcv_trx_processing_pkg.gv_group_id is not null

1119: )
1120: or
1121: ( jai_rcv_trx_processing_pkg.gv_group_id is null
1122: OR
1123: (jai_rcv_trx_processing_pkg.gv_group_id is not null
1124: AND
1125: NVL(jai_rcv_trx_processing_pkg.gv_group_id,0) <> pr_new.group_id)
1126: )
1127: THEN

Line 1125: NVL(jai_rcv_trx_processing_pkg.gv_group_id,0) <> pr_new.group_id)

1121: ( jai_rcv_trx_processing_pkg.gv_group_id is null
1122: OR
1123: (jai_rcv_trx_processing_pkg.gv_group_id is not null
1124: AND
1125: NVL(jai_rcv_trx_processing_pkg.gv_group_id,0) <> pr_new.group_id)
1126: )
1127: THEN
1128:
1129: IF lv_profile_val = 'IMMEDIATE' THEN

Line 1171: jai_rcv_trx_processing_pkg.gv_shipment_header_id := pr_new.shipment_header_id ;

1167: '', '', '', '', '', '', '', '', '', '',
1168: '', '', '', '', '', '', '', '', '', '',
1169: '', '', '', '', '', '', '', ''
1170: );
1171: jai_rcv_trx_processing_pkg.gv_shipment_header_id := pr_new.shipment_header_id ;
1172: jai_rcv_trx_processing_pkg.gv_group_id := pr_new.group_id ;
1173: END IF;
1174: END IF;
1175:

Line 1172: jai_rcv_trx_processing_pkg.gv_group_id := pr_new.group_id ;

1168: '', '', '', '', '', '', '', '', '', '',
1169: '', '', '', '', '', '', '', ''
1170: );
1171: jai_rcv_trx_processing_pkg.gv_shipment_header_id := pr_new.shipment_header_id ;
1172: jai_rcv_trx_processing_pkg.gv_group_id := pr_new.group_id ;
1173: END IF;
1174: END IF;
1175:
1176: