[Home] [Help]
92: 9. 2010/04/14 Bo Li For bug9305067
93: The procedure jai_cmn_rgm_recording_pkg.insert_vat_repository_entry has been called
94: in the package JAI_CMN_VAT_ACCNT_PKG. Because of the change of the jai_cmn_rgm_recording_pkg.insert_vat_repository_entry,
95: the package JAI_CMN_VAT_ACCNT_PKG should be modified.
96: The attribute column of JAI_RGM_TRX_RECORDS are also used. To follow the development standard, they should be
97: replaced by new columns with new meaningful ones
98:
99: 10. 20-Apr-2010 Allen Yang modified for bug 9602968
100: Modified procedure definition of process_order_invoice added 'DEFAULT NULL' for p_order_line_id
562: OPEN get_external_flag_cur;
563: FETCH get_external_flag_cur INTO ln_external_flag;
564: CLOSE get_external_flag_cur;
565:
566: --For 'Standard' event or manual AR trasnaction, need to check VAT invoice no. existence.
567: --while in 'External' event for ln_external_flag > 0, do not need to check the same.
568: IF nvl(ln_external_flag, 0) = 0 THEN --Add nvl by Xiao for bug#11936390
569: ---------------------------------------------------------------------------------
570: --Added by Xiao Lv for Open Interface ER bug#11683927 on 03-Mar-2011, end
1440: OPEN get_receivable_ac_id_cur(rec_cur_get_man_ar_inv_taxes.customer_trx_id);
1441: FETCH get_receivable_ac_id_cur INTO ln_balancing_ac_id;
1442: CLOSE get_receivable_ac_id_cur;
1443: ELSE
1444: --Only for 'Standard' event in Open Interface, or manual AR transaction,
1445: --VAT repository should be updated.
1446: ----------------------------------------------------------------------------------------
1447: --Added by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011, end
1448: