APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 9: FROM jai_rgm_trx_records

5: cp_source_table_name IN VARCHAR2,
6: cp_source_document_id IN NUMBER,
7: cp_reference_id IN NUMBER) IS
8: SELECT repository_id
9: FROM jai_rgm_trx_records
10: WHERE source = cp_source
11: AND source_table_name = cp_source_table_name
12: AND source_document_id = cp_source_document_id
13: AND reference_id = cp_reference_id;

Line 49: FROM jai_rgm_trx_records

45: cp_source_table_name IN VARCHAR2,
46: cp_source_document_id IN NUMBER,
47: cp_reference_id IN NUMBER) IS
48: SELECT nvl(credit_amount, debit_amount) amount
49: FROM jai_rgm_trx_records
50: WHERE source = cp_source
51: AND source_table_name = cp_source_table_name
52: AND source_document_id = cp_source_document_id
53: AND reference_id = cp_reference_id;

Line 173: from jai_rgm_trx_records -- CHK is this required

169: AND a.amount <> 0
170: AND jai_cmn_reverse_charge_pkg.is_rvs_chrg_liablity_dist(aida.invoice_distribution_id) = 'Y'
171: AND NOT EXISTS
172: (select 1
173: from jai_rgm_trx_records -- CHK is this required
174: where source = lv_source_reverse_charge
175: AND ((a.amount > 0 and
176: source_trx_type = 'REVERSE_PAID_ACCOUNTING') OR
177: (a.amount < 0 and

Line 263: from jai_rgm_trx_records -- CHK is this required

259: AND jrtr.invoice_id = ap_dist.invoice_id
260: AND jrtr.line_id = ap_dist.invoice_distribution_id
261: AND NOT EXISTS
262: (select 1
263: from jai_rgm_trx_records -- CHK is this required
264: where source = jai_constants.source_ap
265: AND ((prepay.amount < 0 AND
266: source_trx_type = 'REVERSE_APPLY_ACCOUNTING') OR
267: (prepay.amount > 0 AND

Line 649: ld_transaction_date JAI_RGM_TRX_RECORDS.transaction_date%TYPE;

645: ln_recovered_amount NUMBER;
646: ln_parent_recovered_amt NUMBER;
647:
648: ln_payment_amount NUMBER;
649: ld_transaction_date JAI_RGM_TRX_RECORDS.transaction_date%TYPE;
650: ld_accounting_date DATE;
651: ln_validate_amount NUMBER;
652: ln_discounted_amount NUMBER := 0;
653: ln_payment_discount NUMBER := 0;

Line 1501: FROM jai_rgm_trx_records jrr,

1497: jrr.organization_id organization_id,
1498: jrr.location_id location_id,
1499: sum(nvl(jrr.debit_amount, 0)) debit_amount,
1500: sum(nvl(jrr.trx_debit_amount, 0)) trx_debit_amount
1501: FROM jai_rgm_trx_records jrr,
1502: jai_rgm_trx_refs jrf,
1503: JAI_CMN_TAXES_ALL jct
1504: Where jrr.reference_id = jrf.reference_id
1505: AND jrr.settlement_id = pn_settlement_id

Line 1701: from jai_rgm_trx_records

1697:
1698: Cursor c_get_source(cp_repository_id NUMBER)
1699: IS
1700: select source
1701: from jai_rgm_trx_records
1702: where repository_id = cp_repository_id ;
1703:
1704:
1705: CURSOR get_inv_num_settlement IS

Line 1720: lv_source jai_rgm_trx_records.source%TYPE ;

1716: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
1717: lv_invoice_num_str VARCHAR2(300);
1718:
1719:
1720: lv_source jai_rgm_trx_records.source%TYPE ;
1721: lv_src_party_id jai_rgm_dis_src_hdrs.party_id%TYPE ;
1722: lv_reference1 gl_interface.reference1%TYPE ;
1723: ln_loop_cnt NUMBER;
1724:

Line 1865: FROM jai_rgm_trx_records jrr,

1861: jrr.location_id location_id,
1862: jrr.settlement_id settlement_id,
1863: sum(nvl(jrr.debit_amount, 0)) debit_amount,
1864: sum(nvl(jrr.trx_debit_amount, 0)) trx_debit_amount
1865: FROM jai_rgm_trx_records jrr,
1866: jai_rgm_trx_refs jrf,
1867: JAI_CMN_TAXES_ALL jct
1868: Where jrr.reference_id = jrf.reference_id
1869: AND jrr.settlement_id = pn_settlement_id

Line 1902: FROM jai_rgm_trx_records jrr,

1898: WHERE invoice_id = pn_invoice_id;
1899:
1900: CURSOR c_get_repository_flag ( pn_settlement_id NUMBER, pn_reference_id NUMBER,pn_invoice_id NUMBER, pn_invoice_line_id NUMBER, pn_tax_id NUMBER) IS
1901: SELECT 'Y'
1902: FROM jai_rgm_trx_records jrr,
1903: jai_rgm_trx_refs jrf
1904: Where jrr.reference_id = jrf.reference_id
1905: AND jrf.invoice_id = pn_invoice_id
1906: AND jrr.source = jai_constants.source_ap

Line 1916: FROM jai_rgm_trx_records jrr,

1912: AND jrf.tax_id = pn_tax_id;
1913:
1914: CURSOR c_get_service_type_code ( pn_settlement_id NUMBER, pn_invoice_id NUMBER )IS
1915: SELECT jrr.service_type_code service_type_code
1916: FROM jai_rgm_trx_records jrr,
1917: jai_rgm_trx_refs jrf
1918: Where jrr.reference_id = jrf.reference_id
1919: AND jrr.settlement_id = pn_settlement_id
1920: AND jrf.source = jai_constants.source_ap

Line 1960: lv_service_type_code jai_rgm_trx_records.service_type_code%type;

1956: lv_organization_type VARCHAR2(10);
1957: lv_process_flag VARCHAR2(15);
1958: lv_process_message VARCHAR2(4000);
1959: ln_repository_id NUMBER;
1960: lv_service_type_code jai_rgm_trx_records.service_type_code%type;
1961: lv_repository_flag VARCHAR2(2);
1962: ln_discounted_amount number :=0 ;
1963: ln_reference_id NUMBER;
1964: lv_called_from varchar2(100) := 'jai_cmn_reverse_charge_pkg.process_settlement_repository';