[Home] [Help]
775: AND jrct.customer_trx_id = cp_customer_trx_id
776: AND jrctl.customer_trx_line_id = nvl( cp_customer_trx_line_id , jrctl.customer_trx_line_id );
777:
778: /* Added for Bug 6734317 - Start */
779: CURSOR c_dist_gl_date(cp_customer_trx_id ra_cust_trx_line_gl_dist_all.customer_trx_id%type)
780: IS
781: SELECT max(gl_date) gl_date
782: FROM ra_cust_trx_line_gl_dist_all
783: WHERE customer_trx_id = cp_customer_trx_id ;
778: /* Added for Bug 6734317 - Start */
779: CURSOR c_dist_gl_date(cp_customer_trx_id ra_cust_trx_line_gl_dist_all.customer_trx_id%type)
780: IS
781: SELECT max(gl_date) gl_date
782: FROM ra_cust_trx_line_gl_dist_all
783: WHERE customer_trx_id = cp_customer_trx_id ;
784:
785: ld_dist_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE ;
786: /* Added for Bug 6734317 - End */
781: SELECT max(gl_date) gl_date
782: FROM ra_cust_trx_line_gl_dist_all
783: WHERE customer_trx_id = cp_customer_trx_id ;
784:
785: ld_dist_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE ;
786: /* Added for Bug 6734317 - End */
787:
788: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
789: v_std_text VARCHAR2(50) ;
1302: SELECT
1303: gl_dist.gl_date ,
1304: jrct.organization_id
1305: FROM
1306: ra_cust_trx_line_gl_dist_all gl_dist ,
1307: JAI_AR_TRXS jrct ,
1308: JAI_AR_TRX_LINES jrctl ,
1309: JAI_AR_TRX_TAX_LINES jrcttl ,
1310: JAI_CMN_TAXES_ALL jtc ,
1425: lv_process_flag VARCHAR2(2) ;
1426: lv_process_message VARCHAR2(4000) ;
1427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
1428: ln_surcharge_cnt NUMBER(2) := 0 ;
1429: ld_source_doc_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
1430:
1431: ln_open_interface number;--Added by zhiwei for Open Interface bug#11683927
1432: BEGIN
1433:
1848: jrctl.inventory_item_id ,
1849: gl_dist.amount
1850: FROM
1851: ra_customer_trx_all rcta ,
1852: ra_cust_trx_line_gl_dist_all gl_dist ,
1853: JAI_AR_TRXS jrct ,
1854: JAI_AR_TRX_LINES jrctl ,
1855: JAI_AR_TRX_TAX_LINES jrcttl ,
1856: JAI_CMN_TAXES_ALL jtc ,
1882:
1883: /*
1884: ||Get the sign of the Credit Memo document
1885: */
1886: CURSOR cur_get_cm_sign (cp_cm_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE )
1887: IS
1888: SELECT
1889: sign(nvl(amount,0)) app_fr_sign
1890: FROM
1887: IS
1888: SELECT
1889: sign(nvl(amount,0)) app_fr_sign
1890: FROM
1891: ra_cust_trx_line_gl_dist_all
1892: WHERE
1893: account_class = jai_constants.account_class_rec
1894: AND latest_rec_flag = jai_constants.yes
1895: AND customer_trx_id = cp_cm_customer_trx_id;
1939: lv_exists VARCHAR2(1) ;
1940: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1941: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:
1945: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1946: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1947: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1941: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:
1945: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1946: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1947: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1948: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1949:
2549: --NVL(jatl.total_amount,0) total_invoice_amount , --added by eric for inclusive tax on 26-dec,2007
2550: NVL(jatl.line_amount,0) total_invoice_amount , --added by Jia Li for inclusive tax on 2008-01-18
2551: rct.gl_date
2552: FROM
2553: ra_cust_trx_line_gl_dist_all rct
2554: , jai_ar_trx_lines jatl --added by eric for inclusive tax
2555: WHERE jatl.customer_trx_id = rct.customer_trx_id --added by eric for inclusive tax
2556: AND rct.customer_trx_id = p_ract.customer_trx_id
2557: AND rct.account_class = jai_constants.account_class_rec
2635: lv_document_type VARCHAR2(100) ;
2636: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2637: ln_apportion_factor NUMBER(3) ;
2638: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
2639: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
2640: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2641: BEGIN
2642: /*########################################################################################################
2643: || VARIABLES INITIALIZATION
3268: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end
3269: FROM
3270: ra_customer_trx_all rcta ,
3271: ra_cust_trx_types_all trx_types ,
3272: ra_cust_trx_line_gl_dist_all gl_dist ,
3273: JAI_AR_TRXS jrct ,
3274: JAI_AR_TRX_LINES jrctl ,
3275: JAI_AR_TRX_TAX_LINES jrcttl ,
3276: JAI_CMN_TAXES_ALL jtc ,
3294: );
3295:
3296: -- Added by Jia Li for inclusive taxes on 2008-01-18
3297: ----------------------------------------------------------------
3298: CURSOR cur_get_exclu_amt(cp_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE )
3299: IS
3300: SELECT
3301: SUM(a.func_tax_amount)
3302: FROM
3357: AND jdt.source_doc_type = JAI_CONSTANTS.ar_cash; --added by eric for a bug
3358: /*
3359: ||Get the applied to document CM details
3360: */
3361: CURSOR cur_get_cm_details (cp_customer_trx_id RA_CUST_TRX_LINE_GL_DIST_ALL.CUSTOMER_TRX_ID%TYPE)
3362: IS
3363: SELECT
3364: --nvl(gl_dist.acctd_amount,0) app_fr_doc_amt ,--Deleted by eric for inclusive tax
3365: --NVL(jrctl.total_amount,0) app_fr_doc_amt ,--Added by eric for Inclusisve Tax on 26-dec,2007
3376: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
3377: FROM
3378: ra_customer_trx_all rcta ,
3379: ra_cust_trx_types_all trx_types ,
3380: ra_cust_trx_line_gl_dist_all gl_dist ,
3381: JAI_AR_TRXS jrct ,
3382: JAI_AR_TRX_LINES jrctl ,
3383: JAI_AR_TRX_TAX_LINES jrcttl ,
3384: JAI_CMN_TAXES_ALL jtc ,