[Home] [Help]
803: FROM
804: ra_customer_trx_all trx ,
805: JAI_AR_TRXS jtrx ,
806: ra_cust_trx_types_all trx_types ,
807: JAI_AR_TRX_LINES jtrxl ,
808: JAI_AR_TRX_TAX_LINES jtrxtl ,
809: ra_customer_trx_lines_all rctla , /*14121914*/
810: JAI_CMN_TAXES_ALL jtc ,
811: ra_cust_trx_line_gl_dist_all gd--Added by Qiong for bug13540741
889: ---------------------------------------------------------------------------
890: CURSOR chk_external_event(cn_customer_trx_line_id in number)
891: IS
892: select 1
893: from JAI_AR_TRX_LINES line
894: where customer_trx_line_id = cn_customer_trx_line_id --rec_c_fetch_inv_cm_rec.link_to_cust_trx_line_id
895: and NVL(interface_flag, '###') = 'Y'
896: and NVL(interface_event,'###') = JAI_OPEN_API_PKG.GV_TAXABLE_EVENT_EXTERNAL;
897:
1707: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE := -1 ;
1708: lv_process_flag VARCHAR2(2) ;
1709: lv_process_message VARCHAR2(1996) ;
1710: ln_uncommitted_transactions NUMBER(10) := 0 ;
1711: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1712: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1713: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1714: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1715: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1823: IS
1824: SELECT
1825: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1826: FROM
1827: JAI_AR_TRX_LINES jrtl ,
1828: JAI_AR_TRX_TAX_LINES jrttl
1829: WHERE
1830: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1831: jrtl.customer_trx_id = cp_inv_customer_trx_id ;
1833:
1834: /*
1835: || Get the sign of the credit memo
1836: */
1837: CURSOR cur_sign_of_cm (cp_cm_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE )
1838: IS
1839: SELECT
1840: sign(nvl(sum(jrttl.tax_amount),0)) sign_of_credit_memo
1841: FROM
1838: IS
1839: SELECT
1840: sign(nvl(sum(jrttl.tax_amount),0)) sign_of_credit_memo
1841: FROM
1842: JAI_AR_TRX_LINES jrtl ,
1843: JAI_AR_TRX_TAX_LINES jrttl
1844: WHERE
1845: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1846: jrtl.customer_trx_id = cp_cm_customer_trx_id;
1854: IS
1855: SELECT
1856: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1857: FROM
1858: JAI_AR_TRX_LINES jrtl
1859: , JAI_AR_TRX_TAX_LINES jrttl
1860: , jai_cmn_taxes_all tax
1861: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1862: AND jrtl.customer_trx_id = pn_cm_customer_trx_id
1870: IS
1871: SELECT
1872: nvl(sum(jrtl.line_amount),0) inv_tot_line_amt
1873: FROM
1874: JAI_AR_TRX_LINES jrtl
1875: WHERE jrtl.customer_trx_id = pn_cm_customer_trx_id;
1876: ----------------------------------------------------------
1877:
1878: /*
2572: lv_process_message VARCHAR2(1996) ;
2573: lv_source_trx_type VARCHAR2(50) ;
2574: lv_attribute_context VARCHAR2(50) ;
2575: ln_uncommitted_transactions NUMBER(10) := 0 ;
2576: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
2577: ln_location_id NUMBER(15);/*5879769*/
2578: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
2579: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS';--rchandan for bug#4428980
2580:
2693: IS
2694: SELECT
2695: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
2696: FROM
2697: JAI_AR_TRX_LINES jrtl ,
2698: JAI_AR_TRX_TAX_LINES jrttl ,
2699: jai_cmn_taxes_all tax
2700: WHERE
2701: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
2717: IS
2718: SELECT
2719: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
2720: FROM
2721: JAI_AR_TRX_LINES jrtl
2722: , JAI_AR_TRX_TAX_LINES jrttl
2723: , jai_cmn_taxes_all tax
2724: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
2725: AND jrtl.customer_trx_id = pn_inv_customer_trx_id
2737: IS
2738: SELECT
2739: nvl(sum(jrtl.line_amount),0) inv_tot_line_amt
2740: FROM
2741: JAI_AR_TRX_LINES jrtl
2742: WHERE jrtl.customer_trx_id = pn_inv_customer_trx_id
2743: AND jrtl.customer_trx_line_id = nvl(pn_inv_cus_trx_line_id, jrtl.customer_trx_line_id);
2744: --------------------------------------------------------------------------------
2745: /*
3541: jai_constants.tax_type_sh_service_edu_cess);
3542:
3543: CURSOR get_total_amt_cur (pn_invoice_id IN NUMBER) IS
3544: SELECT SUM(total_amount)
3545: FROM jai_ar_trx_lines
3546: WHERE customer_trx_id = pn_invoice_id;
3547:
3548: CURSOR get_claim_entries_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
3549: SELECT jcta.tax_type, (jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100) tax_amt,
3854: line.service_type_code
3855: from jai_rgm_trx_refs refs,
3856: jai_ar_trxs trx,
3857: jai_ar_trx_tax_lines tax,
3858: jai_ar_trx_lines line
3859: where refs.reference_id = cp_reference_id--r_ar_ref_records.reference_id
3860: and refs.line_id = tax.customer_trx_line_id
3861: and refs.invoice_id = trx.customer_trx_id
3862: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id