eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 254: FROM jai_rgm_trx_records

250:
251: CURSOR c_rgm_repository_id(cp_source IN VARCHAR2, cp_source_table_name IN VARCHAR2,
252: cp_source_document_id IN NUMBER, cp_reference_id IN NUMBER) IS
253: SELECT repository_id
254: FROM jai_rgm_trx_records
255: WHERE source = cp_source
256: AND source_table_name = cp_source_table_name
257: AND source_document_id = cp_source_document_id
258: AND reference_id = cp_reference_id;

Line 263: FROM jai_rgm_trx_records

259:
260: CURSOR c_repo_recovered_amt(cp_source IN VARCHAR2, cp_source_table_name IN VARCHAR2,
261: cp_source_document_id IN NUMBER, cp_reference_id IN NUMBER) IS
262: SELECT nvl(credit_amount, debit_amount) amount
263: FROM jai_rgm_trx_records
264: WHERE source = cp_source
265: AND source_table_name = cp_source_table_name
266: AND source_document_id = cp_source_document_id
267: AND reference_id = cp_reference_id;

Line 656: lv_source_table jai_rgm_trx_records.source_table_name%TYPE;

652: lv_match_type VARCHAR2(20);
653: ln_total_amount NUMBER;
654: ln_total_rec_amount NUMBER;
655:
656: lv_source_table jai_rgm_trx_records.source_table_name%TYPE;
657: lv_repository_name VARCHAR2(80);
658:
659:
660: BEGIN

Line 972: FROM jai_rgm_trx_records jrtr

968: WHERE aipa.invoice_id = pn_invoice_id
969: AND aipa.invoice_payment_id > nvl(pn_max_payment_id, 0)
970: AND aipa.accounting_date <= pd_to_date
971: AND NOT EXISTS (SELECT 1
972: FROM jai_rgm_trx_records jrtr
973: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
974: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
975: AND jrtr.source = 'AP_CLAIM'
976: AND jrtr.source_document_id = aipa.invoice_payment_id)

Line 992: FROM jai_rgm_trx_records jrtr

988: AND aila.prepay_invoice_id = aipa.invoice_id
989: AND (aipa.invoice_payment_id > nvl(pn_max_payment_id, 0)
990: OR (aipa.invoice_payment_id < nvl(pn_max_payment_id, 0)
991: AND NOT EXISTS (SELECT 1
992: FROM jai_rgm_trx_records jrtr
993: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
994: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
995: AND jrtr.source = 'AP_CLAIM'
996: AND jrtr.source_document_id = aipa.invoice_payment_id)))

Line 1000: FROM jai_rgm_trx_records jrtr

996: AND jrtr.source_document_id = aipa.invoice_payment_id)))
997: AND aila.accounting_date <= pd_to_date
998: AND nvl(aila.amount, 0) <> 0
999: AND NOT EXISTS (SELECT 1
1000: FROM jai_rgm_trx_records jrtr
1001: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
1002: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
1003: AND jrtr.source = 'AP_CLAIM'
1004: AND jrtr.source_document_id = aipa.invoice_payment_id)

Line 1120: ld_transaction_date JAI_RGM_TRX_RECORDS.transaction_date%TYPE;

1116: ln_recovered_amount NUMBER;
1117: ln_parent_recovered_amt NUMBER;
1118:
1119: ln_payment_amount NUMBER;
1120: ld_transaction_date JAI_RGM_TRX_RECORDS.transaction_date%TYPE;
1121: ld_accounting_date DATE;
1122: ln_validate_amount NUMBER;
1123: ln_discounted_amount NUMBER := 0;
1124: ln_payment_discount NUMBER := 0;

Line 2157: AND a.invoice_payment_id NOT IN (select source_document_id from jai_rgm_trx_records -- CHK is this required

2153: AND a.check_id = b.check_id
2154: AND a.creation_date < cp_start_date
2155: AND nvl(b.future_pay_due_date, v_today) <= v_today
2156: AND a.amount <> 0 /* ssumaith bug# 6104491 */
2157: AND a.invoice_payment_id NOT IN (select source_document_id from jai_rgm_trx_records -- CHK is this required
2158: where source = jai_constants.source_ap
2159: and source_table_name = jai_constants.ap_payments
2160: and source_document_id = a.invoice_payment_id
2161: )

Line 2262: FROM jai_rgm_trx_records

2258: logic.
2259: */
2260: CURSOR c_payment_chk(cp_source IN VARCHAR2, cp_source_table_name IN VARCHAR2, cp_source_document_id IN NUMBER) IS
2261: SELECT 1
2262: FROM jai_rgm_trx_records
2263: WHERE source = jai_constants.source_ap
2264: AND source_table_name = jai_constants.ap_payments
2265: AND source_document_id = cp_source_document_id;
2266:

Line 2283: ln_rgm_reposotory_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;

2279: ln_reference_id JAI_RGM_TRX_REFS.reference_id%TYPE;
2280: ln_parent_reference_id JAI_RGM_TRX_REFS.parent_reference_id%TYPE;
2281: ln_taxable_basis NUMBER;
2282:
2283: ln_rgm_reposotory_id JAI_RGM_TRX_RECORDS.repository_id%TYPE;
2284: ln_recovered_amount JAI_RGM_TRX_REFS.recovered_amount%TYPE;
2285: ln_recoverable_amount JAI_RGM_TRX_REFS.recoverable_amount%TYPE;
2286:
2287: ln_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

Line 2288: lv_src_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;

2284: ln_recovered_amount JAI_RGM_TRX_REFS.recovered_amount%TYPE;
2285: ln_recoverable_amount JAI_RGM_TRX_REFS.recoverable_amount%TYPE;
2286:
2287: ln_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
2288: lv_src_trx_type JAI_RGM_TRX_RECORDS.source_trx_type%TYPE;
2289: lv_process_flag VARCHAR2(2);
2290: lv_process_message VARCHAR2(1000);
2291:
2292: ln_commit_interval NUMBER(5) := 500;

Line 3027: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,

3023: PROCEDURE process (
3024: retcode OUT NOCOPY VARCHAR2,
3025: errbuf OUT NOCOPY VARCHAR2,
3026: p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,
3027: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
3028: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
3029: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
3030: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
3031: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,

Line 4471: FROM jai_rgm_trx_records rgtr

4467: AND aid.accounting_date between trunc(cp_start_date) AND (trunc(cp_till_date+1)-1/(24*60*60))
4468: AND ai.org_id = p_org_id
4469: AND aid.org_id = p_org_id
4470: AND NOT EXISTS( SELECT 1
4471: FROM jai_rgm_trx_records rgtr
4472: WHERE rgtr.source = 'AP'
4473: AND rgtr.organization_id = p_organization_id
4474: AND rgtr.source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4475: AND rgtr.source_document_id = aid.invoice_distribution_id)

Line 4524: FROM jai_rgm_trx_records rgtr

4520: AND aid.org_id = p_org_id
4521: AND aid.parent_reversal_id IS NOT NULL
4522: AND aid.cancellation_flag = 'Y'
4523: AND EXISTS(SELECT 1
4524: FROM jai_rgm_trx_records rgtr
4525: WHERE rgtr.source = 'AP'
4526: AND rgtr.organization_id = p_organization_id
4527: AND rgtr.source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4528: AND rgtr.source_document_id = aid.parent_reversal_id )

Line 4530: FROM jai_rgm_trx_records rgtr

4526: AND rgtr.organization_id = p_organization_id
4527: AND rgtr.source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4528: AND rgtr.source_document_id = aid.parent_reversal_id )
4529: AND NOT EXISTS(SELECT 1
4530: FROM jai_rgm_trx_records rgtr
4531: WHERE rgtr.source = 'AP'
4532: AND rgtr.organization_id = p_organization_id
4533: AND rgtr.source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4534: AND rgtr.source_document_id = aid.invoice_distribution_id )

Line 4542: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AP_INVOICE_DISTRIBUTIONS_ALL';

4538: AND rgtf.invoice_id = aid.invoice_id
4539: AND rgtf.organization_id = p_organization_id--Added by zhiwei for POT Bug#12970828 on 20110915
4540: AND rgtf.party_type = 'V');
4541:
4542: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AP_INVOICE_DISTRIBUTIONS_ALL';
4543: lv_called_from CONSTANT varchar2(100) := 'jai_cmn_rgm_processing_pkg.populate_repository';
4544: ln_repository_id NUMBER;
4545: ln_discounted_amt NUMBER := 0;
4546: ln_organization_id NUMBER := p_organization_id;

Line 4689: FROM jai_rgm_trx_records

4685: AND jcdt.modvat_flag = 'Y'
4686: AND jcdt.tax_id = jcta.tax_id
4687: AND jcta.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
4688: AND NOT EXISTS (SELECT 1
4689: FROM jai_rgm_trx_records
4690: WHERE SOURCE = 'AP_REVERSAL'
4691: AND source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4692: AND source_document_id = aida.invoice_distribution_id)
4693: AND EXISTS(SELECT 1

Line 4716: FROM jai_rgm_trx_records

4712: AND aia.invoice_id = pn_invoice_id
4713: AND aida.invoice_id = pn_invoice_id
4714: AND jcta.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
4715: AND NOT EXISTS (SELECT 1
4716: FROM jai_rgm_trx_records
4717: WHERE SOURCE = 'AP_REVERSAL'
4718: AND source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4719: AND source_document_id = aida.invoice_distribution_id)
4720: AND EXISTS(SELECT 1

Line 4743: FROM jai_rgm_trx_records

4739: AND jcdt.modvat_flag = 'Y'
4740: AND jcdt.tax_id = jcta.tax_id
4741: AND jcta.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
4742: AND EXISTS (SELECT 1
4743: FROM jai_rgm_trx_records
4744: WHERE SOURCE = 'AP_REVERSAL'
4745: AND source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4746: AND source_document_id = aida.invoice_distribution_id)
4747: AND NOT EXISTS (SELECT 1

Line 4748: FROM jai_rgm_trx_records jrtr,

4744: WHERE SOURCE = 'AP_REVERSAL'
4745: AND source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4746: AND source_document_id = aida.invoice_distribution_id)
4747: AND NOT EXISTS (SELECT 1
4748: FROM jai_rgm_trx_records jrtr,
4749: jai_rgm_trx_refs jrtf --Added by Qiong for bug13439861
4750: WHERE jrtr.SOURCE = 'AP_CLAIM'
4751: AND jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4752: AND jrtr.source_document_id = pn_invoice_payment_id

Line 4778: FROM jai_rgm_trx_records

4774: AND aia.invoice_id = pn_invoice_id
4775: AND aida.invoice_id = pn_invoice_id
4776: AND jcta.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
4777: AND EXISTS (SELECT 1
4778: FROM jai_rgm_trx_records
4779: WHERE SOURCE = 'AP_REVERSAL'
4780: AND source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4781: AND source_document_id = aida.invoice_distribution_id)
4782: AND NOT EXISTS (SELECT 1

Line 4783: FROM jai_rgm_trx_records jrtr,

4779: WHERE SOURCE = 'AP_REVERSAL'
4780: AND source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
4781: AND source_document_id = aida.invoice_distribution_id)
4782: AND NOT EXISTS (SELECT 1
4783: FROM jai_rgm_trx_records jrtr,
4784: jai_rgm_trx_refs jrtf--Added by Qiong for bug13439861
4785: WHERE jrtr.SOURCE = 'AP_CLAIM'
4786: AND jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4787: AND jrtr.source_document_id = pn_invoice_payment_id

Line 4826: FROM jai_rgm_trx_records jrtr,

4822: WHERE aipa.invoice_id = pn_invoice_id
4823: AND aipa.accounting_date <= p_to_date
4824: -- AND aipa.invoice_payment_id > nvl(pn_max_payment_id, 0) Commented by Chong for bug#13259755 on 27-OCT-2011
4825: AND NOT EXISTS (SELECT 1
4826: FROM jai_rgm_trx_records jrtr,
4827: jai_rgm_trx_refs jrtf--Added by Qiong for bug13439861
4828: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4829: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
4830: AND jrtr.source = 'AP_CLAIM'

Line 4858: FROM jai_rgm_trx_records jrtr

4854: /*Commented by Chong for bug#13259755 on 09-NOV-2011 Start
4855: AND (aipa.invoice_payment_id > nvl(pn_max_payment_id, 0)
4856: OR (aipa.invoice_payment_id < nvl(pn_max_payment_id, 0)
4857: AND NOT EXISTS (SELECT 1
4858: FROM jai_rgm_trx_records jrtr
4859: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4860: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
4861: AND jrtr.source = 'AP_CLAIM'
4862: AND jrtr.source_document_id = aipa.invoice_payment_id)))

Line 4865: FROM jai_rgm_trx_records jrtr,

4861: AND jrtr.source = 'AP_CLAIM'
4862: AND jrtr.source_document_id = aipa.invoice_payment_id)))
4863: Commented by Chong for bug#13259755 on 09-NOV-2011 End*/
4864: AND NOT EXISTS (SELECT 1
4865: FROM jai_rgm_trx_records jrtr,
4866: jai_rgm_trx_refs jrtf--Added by Qiong for bug13439861
4867: WHERE jrtr.source_table_name = 'AP_INVOICE_PAYMENTS_ALL'
4868: AND jrtr.source_trx_type = 'CLAIM_ACCOUNTING'
4869: AND jrtr.source = 'AP_CLAIM'