DBA Data[Home] [Help]

APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_ST_INVOICE_REVERSAL_GT

Line 506: r_reversal_gt JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE;

502: ln_tax_to_be_adjusted NUMBER;
503: ln_un_applied_amt NUMBER;
504: lv_reversal_flag VARCHAR2(1) := 'Y';
505: ln_reg_id number;
506: r_reversal_gt JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE;
507: r_standard_ap c_standard_ap%ROWTYPE;
508: r_matched_ap c_matched_ap%ROWTYPE;
509: r_ar c_ar%ROWTYPE;
510: r_ar_rc_st_amount c_ar_rc_st_amount%ROWTYPE;

Line 878: PROCEDURE insert_trxs (r_reversal_trx JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE) IS

874: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
875: jai_cmn_debug_contexts_pkg.print_stack;
876: END extract_reversal_trxs;
877:
878: PROCEDURE insert_trxs (r_reversal_trx JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE) IS
879: BEGIN
880: INSERT INTO JAI_ST_INVOICE_REVERSAL_GT(
881: SERIAL_NUM
882: ,INVOICE_NUM

Line 880: INSERT INTO JAI_ST_INVOICE_REVERSAL_GT(

876: END extract_reversal_trxs;
877:
878: PROCEDURE insert_trxs (r_reversal_trx JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE) IS
879: BEGIN
880: INSERT INTO JAI_ST_INVOICE_REVERSAL_GT(
881: SERIAL_NUM
882: ,INVOICE_NUM
883: ,LINE_NUMBER
884: ,match_type