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_TXT_OPERATOR_PROC dependencies on AR_GTA_TRX_UTIL

Line 571: l_trx_rec AR_GTA_TRX_UTIL.TRX_REC_TYPE;

567: l_num_of_Invoices NUMBER;
568: l_num_of_lines NUMBER;
569: l_GTA_Invoice_num AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
570: l_org_id NUMBER;
571: l_trx_rec AR_GTA_TRX_UTIL.TRX_REC_TYPE;
572: l_trx_header_rec AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;
573: l_trx_line_rec AR_GTA_TRX_UTIL.TRX_line_rec_TYPE;
574: l_trx_line_tbl AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
575: :=AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();

Line 572: l_trx_header_rec AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;

568: l_num_of_lines NUMBER;
569: l_GTA_Invoice_num AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
570: l_org_id NUMBER;
571: l_trx_rec AR_GTA_TRX_UTIL.TRX_REC_TYPE;
572: l_trx_header_rec AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;
573: l_trx_line_rec AR_GTA_TRX_UTIL.TRX_line_rec_TYPE;
574: l_trx_line_tbl AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
575: :=AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();
576: l_error_msg VARCHAR2(2000);

Line 573: l_trx_line_rec AR_GTA_TRX_UTIL.TRX_line_rec_TYPE;

569: l_GTA_Invoice_num AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
570: l_org_id NUMBER;
571: l_trx_rec AR_GTA_TRX_UTIL.TRX_REC_TYPE;
572: l_trx_header_rec AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;
573: l_trx_line_rec AR_GTA_TRX_UTIL.TRX_line_rec_TYPE;
574: l_trx_line_tbl AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
575: :=AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();
576: l_error_msg VARCHAR2(2000);
577: l_fix_field VARCHAR2(100);

Line 574: l_trx_line_tbl AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE

570: l_org_id NUMBER;
571: l_trx_rec AR_GTA_TRX_UTIL.TRX_REC_TYPE;
572: l_trx_header_rec AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;
573: l_trx_line_rec AR_GTA_TRX_UTIL.TRX_line_rec_TYPE;
574: l_trx_line_tbl AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
575: :=AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();
576: l_error_msg VARCHAR2(2000);
577: l_fix_field VARCHAR2(100);
578: l_str VARCHAR2(100);

Line 575: :=AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();

571: l_trx_rec AR_GTA_TRX_UTIL.TRX_REC_TYPE;
572: l_trx_header_rec AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;
573: l_trx_line_rec AR_GTA_TRX_UTIL.TRX_line_rec_TYPE;
574: l_trx_line_tbl AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
575: :=AR_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();
576: l_error_msg VARCHAR2(2000);
577: l_fix_field VARCHAR2(100);
578: l_str VARCHAR2(100);
579: l_failed BOOLEAN;

Line 1140: ar_gta_trx_util.create_Trx(P_GTA_Trx => l_trx_rec);

1136: l_trx_rec.trx_lines:=l_trx_line_tbl;
1137:
1138: --insert into GTA table
1139: BEGIN
1140: ar_gta_trx_util.create_Trx(P_GTA_Trx => l_trx_rec);
1141:
1142: INSERT INTO AR_GTA_IMPORT_REP_TEMP( SEQ
1143: , SUCCEEDED
1144: , Customer_Name

Line 1412: --,AR_GTA_TRX_UTIL.To_Xsd_Date_String(Invoice_date)AS "InvoiceDate"--deleted by Yao for bug#8257757

1408: ,Taxpayer_ID AS "TaxpayerID"
1409: ,Invoice_Num AS "InvoiceNum"
1410: --Jogen 20-Sep-2006 bug5521629
1411: --Format date to XSD Date format
1412: --,AR_GTA_TRX_UTIL.To_Xsd_Date_String(Invoice_date)AS "InvoiceDate"--deleted by Yao for bug#8257757
1413: ,Invoice_date AS "InvoiceDate"--Added by Yao Zhang for bug#8257757
1414: --Jogen 20-Sep-2006 bug5521629
1415: ,Amount AS "Amount"
1416: ,Status AS "Status"

Line 1439: --,AR_GTA_TRX_UTIL.To_Xsd_Date_String(Invoice_date)AS "InvoiceDate"--delete by Yao for bug#8257757

1435: ,Taxpayer_ID AS "TaxpayerID"
1436: ,Invoice_Num AS "InvoiceNum"
1437: --Jogen 20-Sep-2006 bug5521629
1438: --Format date to XSD Date format
1439: --,AR_GTA_TRX_UTIL.To_Xsd_Date_String(Invoice_date)AS "InvoiceDate"--delete by Yao for bug#8257757
1440: ,Invoice_date AS "InvoiceDate"--Added by Yao for bug#8257757
1441: --Jogen 20-Sep-2006 bug5521629
1442: ,Amount AS "Amount"
1443: ,FailedReason AS "Reason"

Line 1469: AR_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);

1465: )
1466: INTO l_report_XML
1467: FROM dual;
1468:
1469: AR_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
1470:
1471: clear_imp_temp_table;
1472:
1473: --log for debug

Line 1528: l_invoice AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;

1524: , p_dup_record_tbl IN dup_record_tbl
1525: )
1526: IS
1527: l_procedure_name VARCHAR2(20):='Export_invoice';
1528: l_invoice AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1529: l_TRX_Line_REC AR_GTA_TRX_UTIL.TRX_LINE_REC_TYPE;
1530: l_lines_num NUMBER:=0;
1531: l_header_output VARCHAR2(1000);
1532:

Line 1529: l_TRX_Line_REC AR_GTA_TRX_UTIL.TRX_LINE_REC_TYPE;

1525: )
1526: IS
1527: l_procedure_name VARCHAR2(20):='Export_invoice';
1528: l_invoice AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1529: l_TRX_Line_REC AR_GTA_TRX_UTIL.TRX_LINE_REC_TYPE;
1530: l_lines_num NUMBER:=0;
1531: l_header_output VARCHAR2(1000);
1532:
1533: ln_ta_trx_id NUMBER;

Line 1844: p_GTA_trx_header AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;

1840: lb_num_flag BOOLEAN:=TRUE;
1841:
1842: ln_notification_num NUMBER:=0;
1843:
1844: p_GTA_trx_header AR_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1845:
1846: lt_dup_record_tbl dup_record_tbl := dup_record_tbl();
1847: --------------------------------------------------------------------------
1848: --add by Lv Xiao on 9-Dec-2008 for bug#7626503, end

Line 1935: IF AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(p_GTA_trx_header.gta_trx_header_id)>0

1931:
1932: --Yao Zhang add for bug8605196 begin
1933: IF p_GTA_trx_header.consolidation_flag='0'
1934: THEN
1935: IF AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(p_GTA_trx_header.gta_trx_header_id)>0
1936: THEN lv_trx_type:='INV';
1937: ELSE lv_trx_type:='CM';
1938: END IF;
1939: ELSE

Line 3252: ( p_gta_trx_header IN AR_GTA_TRX_UTIL.TRX_HEADER_REC_TYPE

3248: -- 26/12/2008 Yao Zhang Modified for bug#7670310
3249: -- 23/08/2010 Yao Zhang Modified for bug 9704932
3250: --===========================================================================
3251: FUNCTION Check_Header
3252: ( p_gta_trx_header IN AR_GTA_TRX_UTIL.TRX_HEADER_REC_TYPE
3253: )
3254: RETURN PLS_INTEGER
3255: IS
3256:

Line 3321: IF AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(p_GTA_trx_header.gta_trx_header_id)>0

3317: --following code is commented by subba to relax the validation for CM in R12.1
3318: IF (p_GTA_trx_header.invoice_type = '2') THEN
3319: IF(p_GTA_trx_header.consolidation_flag='0')
3320: THEN
3321: IF AR_GTA_TRX_UTIL.Get_Gtainvoice_Amount(p_GTA_trx_header.gta_trx_header_id)>0
3322: THEN l_trx_class:='INV';
3323: ELSE l_trx_class:='CM';
3324: END IF;
3325: ELSE

Line 3399: ( p_GTA_trx_line IN AR_GTA_TRX_UTIL.TRX_LINE_REC_TYPE

3395: -- 24-Dec-2010 Qiong fix bug#10311408
3396: -- 13-Apr-2011 Yao Zhang fix for bug#12353491
3397: --===========================================================================
3398: FUNCTION Check_Line_Length
3399: ( p_GTA_trx_line IN AR_GTA_TRX_UTIL.TRX_LINE_REC_TYPE
3400: )
3401: RETURN BOOLEAN
3402: IS
3403: l_len_before_dot_qty NUMBER :=0;