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_CONSOLIDATE_PROC dependencies on AR_GTA_TRX_HEADERS_ALL

Line 441: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;

437: l_csldtion_inv_line1 ar_gta_trx_util.trx_line_rec_type;
438: l_csldtion_inv_lines_index1 NUMBER;
439: --added by jixun for ER#16613351 end
440:
441: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
442: l_bill_to_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
443: l_tp_tax_registration_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;

Line 442: l_bill_to_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;

438: l_csldtion_inv_lines_index1 NUMBER;
439: --added by jixun for ER#16613351 end
440:
441: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
442: l_bill_to_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
443: l_tp_tax_registration_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
446: l_bank_account_name ar_gta_trx_headers_all.bank_account_name%TYPE;

Line 443: l_tp_tax_registration_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;

439: --added by jixun for ER#16613351 end
440:
441: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
442: l_bill_to_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
443: l_tp_tax_registration_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
446: l_bank_account_name ar_gta_trx_headers_all.bank_account_name%TYPE;
447: l_bank_account_number ar_gta_trx_headers_all.bank_account_number%TYPE;

Line 444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;

440:
441: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
442: l_bill_to_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
443: l_tp_tax_registration_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
446: l_bank_account_name ar_gta_trx_headers_all.bank_account_name%TYPE;
447: l_bank_account_number ar_gta_trx_headers_all.bank_account_number%TYPE;
448: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;

Line 445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;

441: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
442: l_bill_to_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
443: l_tp_tax_registration_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
446: l_bank_account_name ar_gta_trx_headers_all.bank_account_name%TYPE;
447: l_bank_account_number ar_gta_trx_headers_all.bank_account_number%TYPE;
448: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
449: l_ra_trx_type Varchar2(20);

Line 446: l_bank_account_name ar_gta_trx_headers_all.bank_account_name%TYPE;

442: l_bill_to_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
443: l_tp_tax_registration_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
446: l_bank_account_name ar_gta_trx_headers_all.bank_account_name%TYPE;
447: l_bank_account_number ar_gta_trx_headers_all.bank_account_number%TYPE;
448: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
449: l_ra_trx_type Varchar2(20);
450: l_sum_amount NUMBER;

Line 447: l_bank_account_number ar_gta_trx_headers_all.bank_account_number%TYPE;

443: l_tp_tax_registration_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
446: l_bank_account_name ar_gta_trx_headers_all.bank_account_name%TYPE;
447: l_bank_account_number ar_gta_trx_headers_all.bank_account_number%TYPE;
448: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
449: l_ra_trx_type Varchar2(20);
450: l_sum_amount NUMBER;
451: l_max_amount NUMBER;

Line 448: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;

444: l_fp_tax_registration_number ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
445: l_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
446: l_bank_account_name ar_gta_trx_headers_all.bank_account_name%TYPE;
447: l_bank_account_number ar_gta_trx_headers_all.bank_account_number%TYPE;
448: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
449: l_ra_trx_type Varchar2(20);
450: l_sum_amount NUMBER;
451: l_max_amount NUMBER;
452: l_max_line NUMBER;

Line 491: FROM ar_gta_trx_headers_all jgth, ar_gta_trx_lines_all jgtl

487: jgth.bank_account_name,
488: jgth.bank_account_number,
489: jgth.invoice_type,
490: jgtl.tax_rate --Yao add for bug9655856
491: FROM ar_gta_trx_headers_all jgth, ar_gta_trx_lines_all jgtl
492: WHERE jgth.consolidation_id = p_consolidation_id
493: --Yao add for bug 9655856
494: AND jgth.gta_trx_header_id = jgtl.gta_trx_header_id
495: AND jgth.org_id = jgtl.org_id

Line 516: FROM ar_gta_trx_headers_all jgth

512: p_invoice_type IN VARCHAR2,
513: p_tax_rate IN NUMBER)--Yao add for bug 9655856
514: IS
515: SELECT jgth.gta_trx_header_id
516: FROM ar_gta_trx_headers_all jgth
517: WHERE jgth.consolidation_id = p_consolidation_id
518: AND jgth.fp_tax_registration_number=p_fp_tax_registration_number
519: AND jgth.bill_to_customer_name = p_bill_to_customer_name
520: AND (jgth.tp_tax_registration_number = p_tp_tax_registration_number OR

Line 1307: SELECT ar_gta_trx_headers_all_s.NEXTVAL

1303: IF l_result_flag IS NULL OR l_result_flag='W'
1304: THEN
1305: l_result_flag:=nvl(l_result_flag,'S');
1306: --new header sequence
1307: SELECT ar_gta_trx_headers_all_s.NEXTVAL
1308: INTO l_csldtion_inv.trx_header.gta_trx_header_id
1309: FROM dual;
1310: --copy trx header information
1311: l_csldtion_inv.trx_header.ra_gl_date :=l_csldted_inv.trx_header.ra_gl_date;

Line 1352: FROM ar_gta_trx_headers_all jgth

1348: --generate group number for consolidation invoice
1349: BEGIN
1350: SELECT MAX(group_number)+1
1351: INTO l_csldtion_inv.trx_header.group_number
1352: FROM ar_gta_trx_headers_all jgth
1353: WHERE jgth.gta_trx_number LIKE l_csldted_inv.trx_header.ra_trx_id||'-%';
1354: EXCEPTION
1355: WHEN no_data_found THEN
1356: l_csldtion_inv.trx_header.group_number:=1;

Line 1380: UPDATE ar_gta_trx_headers_all

1376:
1377: l_csldted_invs_index:=l_csldted_invs.FIRST;
1378: WHILE l_csldted_invs_index IS NOT NULL
1379: LOOP
1380: UPDATE ar_gta_trx_headers_all
1381: SET status = 'CONSOLIDATED',
1382: consolidation_flag = '1',
1383: consolidation_trx_num = l_csldtion_inv.trx_header.gta_trx_number
1384: WHERE gta_trx_header_id = l_csldted_invs(l_csldted_invs_index).trx_header.gta_trx_header_id;

Line 1428: UPDATE ar_gta_trx_headers_all

1424: --set consolidation_id to be null for failed gta invoices
1425:
1426: IF l_result_flag='E'
1427: THEN
1428: UPDATE ar_gta_trx_headers_all
1429: SET consolidation_id=NULL
1430: WHERE GTA_TRX_HEADER_ID=l_csldted_invs(l_csldted_invs_index).trx_header.gta_trx_header_id;
1431: END IF;
1432: --get ra transaction type and amount

Line 1487: UPDATE ar_gta_trx_headers_all

1483: '. OTHER_EXCEPTION ',
1484: 'Unknown error' || SQLCODE || SQLERRM);
1485:
1486: END IF;
1487: UPDATE ar_gta_trx_headers_all
1488: SET consolidation_id = NULL
1489: ,consolidation_trx_num=NULL
1490: ,consolidation_flag=NULL
1491: ,status='DRAFT'