[Home] [Help]
498: FROM
499: ra_customer_trx_all trx ,
500: JAI_AR_TRXS jtrx ,
501: ra_cust_trx_types_all trx_types ,
502: JAI_AR_TRX_LINES jtrxl ,
503: JAI_AR_TRX_TAX_LINES jtrxtl ,
504: JAI_CMN_TAXES_ALL jtc
505: WHERE
506: trx.org_id = nvl(p_org_id,trx.org_id) AND
1152: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE := -1 ;
1153: lv_process_flag VARCHAR2(2) ;
1154: lv_process_message VARCHAR2(1996) ;
1155: ln_uncommitted_transactions NUMBER(10) := 0 ;
1156: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1157: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1158: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1159: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1160: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1254: IS
1255: SELECT
1256: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1257: FROM
1258: JAI_AR_TRX_LINES jrtl ,
1259: JAI_AR_TRX_TAX_LINES jrttl
1260: WHERE
1261: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1262: jrtl.customer_trx_id = cp_inv_customer_trx_id ;
1264:
1265: /*
1266: || Get the sign of the credit memo
1267: */
1268: CURSOR cur_sign_of_cm (cp_cm_customer_trx_id JAI_AR_TRX_LINES.CUSTOMER_TRX_ID%TYPE )
1269: IS
1270: SELECT
1271: sign(nvl(sum(jrttl.tax_amount),0)) sign_of_credit_memo
1272: FROM
1269: IS
1270: SELECT
1271: sign(nvl(sum(jrttl.tax_amount),0)) sign_of_credit_memo
1272: FROM
1273: JAI_AR_TRX_LINES jrtl ,
1274: JAI_AR_TRX_TAX_LINES jrttl
1275: WHERE
1276: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1277: jrtl.customer_trx_id = cp_cm_customer_trx_id;
1285: IS
1286: SELECT
1287: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1288: FROM
1289: JAI_AR_TRX_LINES jrtl
1290: , JAI_AR_TRX_TAX_LINES jrttl
1291: , jai_cmn_taxes_all tax
1292: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1293: AND jrtl.customer_trx_id = pn_cm_customer_trx_id
1301: IS
1302: SELECT
1303: nvl(sum(jrtl.line_amount),0) inv_tot_line_amt
1304: FROM
1305: JAI_AR_TRX_LINES jrtl
1306: WHERE jrtl.customer_trx_id = pn_cm_customer_trx_id;
1307: ----------------------------------------------------------
1308:
1309: /*
1865: lv_process_message VARCHAR2(1996) ;
1866: lv_source_trx_type VARCHAR2(50) ;
1867: lv_attribute_context VARCHAR2(50) ;
1868: ln_uncommitted_transactions NUMBER(10) := 0 ;
1869: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1870: ln_location_id NUMBER(15);/*5879769*/
1871: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1872: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS';--rchandan for bug#4428980
1873:
1959: IS
1960: SELECT
1961: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1962: FROM
1963: JAI_AR_TRX_LINES jrtl ,
1964: JAI_AR_TRX_TAX_LINES jrttl
1965: WHERE
1966: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1967: jrtl.customer_trx_id = cp_inv_customer_trx_id ;
1975: IS
1976: SELECT
1977: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1978: FROM
1979: JAI_AR_TRX_LINES jrtl
1980: , JAI_AR_TRX_TAX_LINES jrttl
1981: , jai_cmn_taxes_all tax
1982: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1983: AND jrtl.customer_trx_id = pn_inv_customer_trx_id
1991: IS
1992: SELECT
1993: nvl(sum(jrtl.line_amount),0) inv_tot_line_amt
1994: FROM
1995: JAI_AR_TRX_LINES jrtl
1996: WHERE jrtl.customer_trx_id = pn_inv_customer_trx_id;
1997: --------------------------------------------------------------------------------
1998: /*
1999: || Get the ref tax lines pertaining to the invoice against which the cash receipt has been applied : -