APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 172: FROM JAI_CMN_MATCH_RECEIPTS a, JAI_CMN_RG_23D_TRXS b

168:
169: CURSOR matched_receipt_cur(p_customer_trx_line_id IN NUMBER) IS
170: SELECT a.receipt_id, a.quantity_applied, b.transaction_type,b.qty_to_adjust,
171: b.rate_per_unit,b.excise_duty_rate
172: FROM JAI_CMN_MATCH_RECEIPTS a, JAI_CMN_RG_23D_TRXS b
173: WHERE a.ref_line_id = p_customer_trx_line_id
174: AND a.receipt_id = b.register_id
175: AND a.quantity_applied > 0 ;
176: CURSOR tax_rate_cur(p_customer_trx_line_id IN NUMBER, p_receipt_id IN NUMBER)

Line 225: lv_ship_status JAI_CMN_MATCH_RECEIPTS.ship_status%type ;

221:
222: VSQLERRM varchar2(250);
223: vsqlstmt varchar2(20);
224:
225: lv_ship_status JAI_CMN_MATCH_RECEIPTS.ship_status%type ;
226:
227: /*
228: || Start of bug 4566054
229: ||Code added by aiyer for the bug 4566054

Line 927: UPDATE JAI_CMN_MATCH_RECEIPTS

923: --jai_om_rg_pkg.ja_in_rg23_part_II_entry, so after the call for these two procedures,
924: --program returns, and RG register will not be updated.
925: IF ln_external_flag > 0 THEN
926: lv_ship_status := 'CLOSED' ;
927: UPDATE JAI_CMN_MATCH_RECEIPTS
928: SET ship_status = lv_ship_status
929: WHERE ref_line_id = l_rec.customer_trx_line_id;
930: RETURN;
931: END IF;

Line 1059: UPDATE JAI_CMN_MATCH_RECEIPTS

1055: );
1056:
1057: lv_ship_status := 'CLOSED' ;
1058:
1059: UPDATE JAI_CMN_MATCH_RECEIPTS
1060: set ship_status = lv_ship_status --'CLOSED' /* Modified by Ramananda for removal of SQL LITERALs */
1061: where ref_line_id = l_rec.customer_trx_line_id;
1062: END LOOP;
1063: END IF;