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.AR_GTA_TRX_UTIL dependencies on AR_GTA_TRX_HEADERS_ALL

Line 657: ar_gta_trx_headers_all_pkg.insert_row

653: END IF;
654: -- end log
655:
656: -- insert header
657: ar_gta_trx_headers_all_pkg.insert_row
658: (p_row_id => header_row_id
659: ,p_ra_gl_date => p_gta_trx.trx_header.ra_gl_date
660: ,p_ra_gl_period => p_gta_trx.trx_header.ra_gl_period
661: ,p_set_of_books_id => p_gta_trx.trx_header.set_of_books_id

Line 895: AR_GTA_TRX_HEADERS_ALL_PKG.Query_Row

891: END IF;
892: --get trx header
893: l_trx_rec:=NULL;
894:
895: AR_GTA_TRX_HEADERS_ALL_PKG.Query_Row
896: (p_header_id => p_trx_header_id
897: ,x_trx_header_rec => l_trx_rec.trx_header);
898: --init
899: l_trx_rec.trx_lines:=trx_line_tbl_type();

Line 1060: DELETE ar_gta_trx_headers_all

1056: DELETE ar_gta_trx_lines_all
1057: WHERE gta_trx_header_id = p_gta_trx_header_id;
1058:
1059: --Delete Headers
1060: DELETE ar_gta_trx_headers_all
1061: WHERE gta_trx_header_id = p_gta_trx_header_id;
1062: END delete_header_line_cascade;
1063:
1064: --==========================================================================

Line 4452: , AR_GTA_TRX_HEADERS_ALL JGTH

4448: CURSOR c_inv_trx_type_no_inv_type
4449: IS
4450: SELECT JGTH.GTA_TRX_NUMBER, SOURCE
4451: FROM RA_CUSTOMER_TRX_ALL RCT
4452: , AR_GTA_TRX_HEADERS_ALL JGTH
4453: WHERE invoice_type is null
4454: AND JGTH.ORG_ID = p_org_id
4455: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4456: AND NOT EXISTS (SELECT JGTL.Limitation_Id

Line 4470: , AR_GTA_TRX_HEADERS_ALL JGTH

4466: CURSOR c_recycle_tax_amount_not_zero
4467: IS
4468: SELECT JGTH.GTA_TRX_NUMBER, SOURCE
4469: FROM RA_CUSTOMER_TRX_ALL RCT
4470: , AR_GTA_TRX_HEADERS_ALL JGTH
4471: WHERE invoice_type is null
4472: AND JGTH.ORG_ID = p_org_id
4473: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4474: AND EXISTS (SELECT JGTL.Limitation_Id

Line 4488: AR_GTA_TRX_HEADERS_ALL JGTH

4484: IS
4485: SELECT JGTH.GTA_TRX_NUMBER, SOURCE
4486: FROM RA_CUSTOMER_TRX_ALL RCT,
4487: RA_CUST_TRX_TYPES_ALL RCTT,
4488: AR_GTA_TRX_HEADERS_ALL JGTH
4489: WHERE invoice_type is not null
4490: AND JGTH.ORG_ID = p_org_id
4491: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4492: AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID(+)

Line 4498: FROM AR_GTA_TRX_HEADERS_ALL JGTH1

4494: AND RCTT.TYPE = 'CM'
4495: AND RCT.previous_customer_trx_id is not null
4496: AND JGTH.invoice_type <>
4497: (SELECT DISTINCT invoice_type
4498: FROM AR_GTA_TRX_HEADERS_ALL JGTH1
4499: WHERE JGTH1.RA_TRX_id = RCT.previous_customer_trx_id);
4500:
4501: -- all GTA invoices need to be updated
4502: CURSOR c_all_inv_updated

Line 4510: FROM AR_GTA_TRX_HEADERS_ALL

4506: , SOURCE
4507: , RA_TRX_ID
4508: , FP_TAX_REGISTRATION_NUMBER
4509: , ORG_ID
4510: FROM AR_GTA_TRX_HEADERS_ALL
4511: WHERE INVOICE_TYPE IS NULL
4512: AND ORG_ID = p_org_id;
4513:
4514: l_gta_trx_number ar_gta_trx_headers_all.GTA_TRX_NUMBER%TYPE;

Line 4514: l_gta_trx_number ar_gta_trx_headers_all.GTA_TRX_NUMBER%TYPE;

4510: FROM AR_GTA_TRX_HEADERS_ALL
4511: WHERE INVOICE_TYPE IS NULL
4512: AND ORG_ID = p_org_id;
4513:
4514: l_gta_trx_number ar_gta_trx_headers_all.GTA_TRX_NUMBER%TYPE;
4515: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
4516: l_gta_trx_header_id ar_gta_trx_headers_all.GTA_TRX_HEADER_ID%TYPE;
4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;
4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;

Line 4515: l_source ar_gta_trx_headers_all.SOURCE%TYPE;

4511: WHERE INVOICE_TYPE IS NULL
4512: AND ORG_ID = p_org_id;
4513:
4514: l_gta_trx_number ar_gta_trx_headers_all.GTA_TRX_NUMBER%TYPE;
4515: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
4516: l_gta_trx_header_id ar_gta_trx_headers_all.GTA_TRX_HEADER_ID%TYPE;
4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;
4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;
4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;

Line 4516: l_gta_trx_header_id ar_gta_trx_headers_all.GTA_TRX_HEADER_ID%TYPE;

4512: AND ORG_ID = p_org_id;
4513:
4514: l_gta_trx_number ar_gta_trx_headers_all.GTA_TRX_NUMBER%TYPE;
4515: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
4516: l_gta_trx_header_id ar_gta_trx_headers_all.GTA_TRX_HEADER_ID%TYPE;
4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;
4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;
4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;
4520: l_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;

Line 4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;

4513:
4514: l_gta_trx_number ar_gta_trx_headers_all.GTA_TRX_NUMBER%TYPE;
4515: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
4516: l_gta_trx_header_id ar_gta_trx_headers_all.GTA_TRX_HEADER_ID%TYPE;
4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;
4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;
4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;
4520: l_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4521: l_pre_trx_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;

Line 4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;

4514: l_gta_trx_number ar_gta_trx_headers_all.GTA_TRX_NUMBER%TYPE;
4515: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
4516: l_gta_trx_header_id ar_gta_trx_headers_all.GTA_TRX_HEADER_ID%TYPE;
4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;
4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;
4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;
4520: l_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4521: l_pre_trx_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4522: l_ar_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;

Line 4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;

4515: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
4516: l_gta_trx_header_id ar_gta_trx_headers_all.GTA_TRX_HEADER_ID%TYPE;
4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;
4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;
4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;
4520: l_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4521: l_pre_trx_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4522: l_ar_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;
4523:

Line 4520: l_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;

4516: l_gta_trx_header_id ar_gta_trx_headers_all.GTA_TRX_HEADER_ID%TYPE;
4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;
4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;
4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;
4520: l_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4521: l_pre_trx_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4522: l_ar_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;
4523:
4524:

Line 4521: l_pre_trx_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;

4517: l_ra_trx_id ar_gta_trx_headers_all.RA_TRX_ID%TYPE;
4518: l_fp_tax_registration_number ar_gta_trx_headers_all.FP_TAX_REGISTRATION_NUMBER%TYPE;
4519: l_org_id ar_gta_trx_headers_all.ORG_ID%TYPE;
4520: l_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4521: l_pre_trx_invoice_type ar_gta_trx_headers_all.INVOICE_TYPE%TYPE;
4522: l_ar_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;
4523:
4524:
4525: BEGIN

Line 4584: ,AR_GTA_TRX_HEADERS_ALL JGTH

4580: SELECT RCTT.TYPE
4581: INTO l_ar_trx_type
4582: FROM RA_CUST_TRX_TYPES_ALL RCTT
4583: ,RA_CUSTOMER_TRX_ALL RCT
4584: ,AR_GTA_TRX_HEADERS_ALL JGTH
4585: WHERE JGTH.GTA_TRX_HEADER_ID = l_gta_trx_header_id
4586: AND RCT.CUSTOMER_TRX_ID(+) = JGTH.Ra_Trx_Id
4587: AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID(+)
4588: AND RCTT.ORG_ID = l_org_id;

Line 4605: FROM AR_GTA_TRX_HEADERS_ALL JGTH

4601: THEN
4602: BEGIN
4603: SELECT DISTINCT JGTH.invoice_type
4604: INTO l_pre_trx_invoice_type
4605: FROM AR_GTA_TRX_HEADERS_ALL JGTH
4606: ,RA_CUSTOMER_TRX_ALL RCT
4607: WHERE RCT.CUSTOMER_TRX_ID(+) = l_ra_trx_id
4608: AND JGTH.RA_TRX_id = RCT.previous_customer_trx_id;
4609: EXCEPTION

Line 4630: UPDATE AR_GTA_TRX_HEADERS_ALL JGTH

4626: END LOOP; -- c_all_inv_updated%NOTFOUND;
4627: CLOSE c_all_inv_updated;
4628:
4629: -- initialize invoice type for GTA invoices
4630: UPDATE AR_GTA_TRX_HEADERS_ALL JGTH
4631: SET invoice_type = (SELECT JGTL.invoice_type
4632: FROM RA_CUSTOMER_TRX_ALL RCT,
4633: ar_gta_tax_limits_all JGTL
4634: WHERE RCT.CUSTOMER_TRX_ID = JGTH.Ra_Trx_Id