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_HEADERS_ALL

Line 563: L_HEADER_ID AR_Gta_Trx_Headers_All.Gta_Trx_Header_Id%TYPE;

559: --===========================================================================
560: PROCEDURE Import_Invoices
561: IS
562: l_procedure_name VARCHAR2(30):='Import_invoices';
563: L_HEADER_ID AR_Gta_Trx_Headers_All.Gta_Trx_Header_Id%TYPE;
564: l_line_seq NUMBER;
565: l_values COLUMN_VALUES:=COLUMN_VALUES(NULL);
566: l_EOF BOOLEAN;
567: l_num_of_Invoices NUMBER;

Line 569: l_GTA_Invoice_num AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;

565: l_values COLUMN_VALUES:=COLUMN_VALUES(NULL);
566: l_EOF BOOLEAN;
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;

Line 581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;

577: l_fix_field VARCHAR2(100);
578: l_str VARCHAR2(100);
579: l_failed BOOLEAN;
580: l_line_num NUMBER;
581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;
582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;
583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

Line 582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;

578: l_str VARCHAR2(100);
579: l_failed BOOLEAN;
580: l_line_num NUMBER;
581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;
582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;
583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
586: l_Invoice_date AR_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;

Line 583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;

579: l_failed BOOLEAN;
580: l_line_num NUMBER;
581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;
582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;
583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
586: l_Invoice_date AR_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
587: l_Amount AR_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;

Line 584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;

580: l_line_num NUMBER;
581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;
582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;
583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
586: l_Invoice_date AR_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
587: l_Amount AR_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
588: l_conc_succ BOOLEAN;

Line 585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

581: l_status AR_Gta_Trx_Headers_All.Status%TYPE;
582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;
583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
586: l_Invoice_date AR_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
587: l_Amount AR_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
588: l_conc_succ BOOLEAN;
589: l_failed_XML XMLTYPE;

Line 586: l_Invoice_date AR_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;

582: l_new_status AR_Gta_Trx_Headers_All.Status%TYPE;
583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
586: l_Invoice_date AR_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
587: l_Amount AR_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
588: l_conc_succ BOOLEAN;
589: l_failed_XML XMLTYPE;
590: l_succ_XML XMLTYPE;

Line 587: l_Amount AR_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;

583: l_Customer_Name AR_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
584: l_TP_TAX_REG_NUMBER AR_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
585: l_Invoice_Num AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
586: l_Invoice_date AR_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
587: l_Amount AR_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
588: l_conc_succ BOOLEAN;
589: l_failed_XML XMLTYPE;
590: l_succ_XML XMLTYPE;
591: l_report_XML XMLTYPE;

Line 599: l_vat_tbl_index AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;

595: l_proc_level NUMBER
596: :=FND_LOG.Level_Procedure;
597: --Add by Sabrina for ER#14830536 Start
598: l_vat_tbl vat_tbl_type;
599: l_vat_tbl_index AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
600: l_Invoice_Num_Sum AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
601: l_values_VAT_Header COLUMN_VALUES:=COLUMN_VALUES(NULL);
602: --Add by Sabrina for ER#14830536 End
603: BEGIN

Line 600: l_Invoice_Num_Sum AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

596: :=FND_LOG.Level_Procedure;
597: --Add by Sabrina for ER#14830536 Start
598: l_vat_tbl vat_tbl_type;
599: l_vat_tbl_index AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
600: l_Invoice_Num_Sum AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
601: l_values_VAT_Header COLUMN_VALUES:=COLUMN_VALUES(NULL);
602: --Add by Sabrina for ER#14830536 End
603: BEGIN
604: --log for debug

Line 756: FROM AR_GTA_TRX_HEADERS_ALL

752: , status
753: INTO l_header_id
754: , l_org_id
755: , l_status
756: FROM AR_GTA_TRX_HEADERS_ALL
757: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
758: AND SOURCE='AR'
759: AND latest_version_flag='Y';
760:

Line 965: SELECT ar_gta_trx_headers_all_s.NEXTVAL

961:
962:
963:
964:
965: SELECT ar_gta_trx_headers_all_s.NEXTVAL
966: INTO l_trx_header_rec.gta_trx_header_id
967: FROM dual;
968:
969: EXCEPTION

Line 1574: ar_gta_trx_headers_all_pkg.query_row( p_header_id => p_invoice_header_id

1570:
1571: --put to the temporary output
1572: x_output(1):=fnd_message.get;
1573:
1574: ar_gta_trx_headers_all_pkg.query_row( p_header_id => p_invoice_header_id
1575: , x_trx_header_rec => l_invoice
1576: );
1577:
1578: x_success:=check_header(l_invoice);

Line 1798: l_header_rec_cur AR_Gta_Trx_Headers_all%ROWTYPE;

1794: , p_draft_dup_cur IN crmemo_dup_cur_TYPE DEFAULT NULL
1795: )
1796: IS
1797: l_procedure_name VARCHAR2(30):='export_Invoices';
1798: l_header_rec_cur AR_Gta_Trx_Headers_all%ROWTYPE;
1799: l_succ_output t_invoice_export_output:=t_invoice_export_output();
1800: l_exceed_output t_invoice_export_output:=t_invoice_export_output();
1801: l_taxpayid_err_out t_invoice_export_output:=t_invoice_export_output();
1802: l_creddit_memo_err t_invoice_export_output:=t_invoice_export_output();

Line 1808: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;

1804:
1805: l_trx_export_success PLS_INTEGER;
1806: l_error_msg VARCHAR2(5000);
1807: l_conc_succ BOOLEAN;
1808: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
1809: i INTEGER;
1810: l_str VARCHAR2(1000); --Jun-22, 2006, jogen bug 5335265
1811: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1812: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

Line 1928: ar_gta_trx_headers_all_pkg.query_row( p_header_id => l_gta_trx_header_id

1924: * 'Notification Number for Issued VAT Credit memo+16-digit Notification number'
1925: * if check fails, message 'AR_GTA_CRMEMO_MISSING_PREFIX' is wroten to output
1926: * file.
1927: */
1928: ar_gta_trx_headers_all_pkg.query_row( p_header_id => l_gta_trx_header_id
1929: , x_trx_header_rec => p_GTA_trx_header
1930: );
1931:
1932: --Yao Zhang add for bug8605196 begin

Line 1944: FROM AR_GTA_TRX_HEADERS_ALL JGTH

1940: BEGIN
1941: --Yao Zhang add for bug8605196 end
1942: SELECT DISTINCT RCTT.type
1943: INTO lv_trx_type
1944: FROM AR_GTA_TRX_HEADERS_ALL JGTH
1945: , RA_CUST_TRX_TYPES_ALL RCTT
1946: , RA_CUSTOMER_TRX_ALL RCT
1947: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
1948: AND JGTH.source = 'AR'

Line 2533: l_batch_number AR_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;

2529: -------------------------------------------------------------------------------
2530:
2531: l_error_msg VARCHAR2(1000);
2532:
2533: l_batch_number AR_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;
2534: l_batch_number_ok BOOLEAN;
2535: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2536: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2537: l_invoice_type_check VARCHAR2(1); --added for invoice_type condition by Subba.

Line 2648: FROM AR_GTA_TRX_HEADERS_ALL JGTHA

2644: SELECT JGTHA.ra_trx_id
2645: , JGTHA.description
2646: , JGTHA.org_id
2647: , JGTHA.gta_trx_number
2648: FROM AR_GTA_TRX_HEADERS_ALL JGTHA
2649: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2650: AND JGTHA.status IN ('GENERATED', 'COMPLETED')
2651:
2652: AND JGTHA.description IN /*( SELECT h.description

Line 2746: FROM AR_GTA_TRX_HEADERS_ALL JGTHA

2742: SELECT JGTHA.ra_trx_id
2743: , JGTHA.description
2744: , JGTHA.org_id
2745: , JGTHA.gta_trx_number
2746: FROM AR_GTA_TRX_HEADERS_ALL JGTHA
2747: , ra_customer_trx_all ar
2748: , Ra_Cust_Trx_Types_all ctt
2749: , RA_CUST_TRX_LINE_GL_DIST_all gd
2750: , ra_batches_all b

Line 3009: l_batch_number AR_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;

3005: l_cur_draft_dup crmemo_dup_cur_TYPE;--get draft crmemo with duplicate description
3006: -------------------------------------------------------------------------------
3007: --add by Lv Xiao for bug#7626503 on 11-Dec-2008, end
3008:
3009: l_batch_number AR_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;
3010: l_batch_number_ok BOOLEAN;
3011: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3012: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3013: BEGIN

Line 3055: FROM AR_GTA_TRX_HEADERS_ALL JGTHA

3051: SELECT JGTHA.ra_trx_id
3052: , JGTHA.description
3053: , JGTHA.org_id
3054: , JGTHA.gta_trx_number
3055: FROM AR_GTA_TRX_HEADERS_ALL JGTHA
3056: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
3057: AND JGTHA.Invoice_Type<>'2'--yao zhang add for bug 7673309
3058: AND JGTHA.source='AR'--yao zhang add for bug7673309
3059: AND JGTHA.status IN ('GENERATED', 'COMPLETED')

Line 3066: FROM AR_GTA_TRX_HEADERS_ALL JGTH

3062: --modified by Lv Xiao for bug#7644803 on 16-Dec-08, begin
3063: -------------------------------------------------------------------
3064: /* AND JGTHA.description IN ( SELECT DISTINCT description
3065: FROM (SELECT description
3066: FROM AR_GTA_TRX_HEADERS_ALL JGTH
3067: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
3068: INTERSECT
3069: SELECT description
3070: FROM AR_GTA_TRX_HEADERS_ALL

Line 3070: FROM AR_GTA_TRX_HEADERS_ALL

3066: FROM AR_GTA_TRX_HEADERS_ALL JGTH
3067: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
3068: INTERSECT
3069: SELECT description
3070: FROM AR_GTA_TRX_HEADERS_ALL
3071: WHERE Generator_Id=p_generator_ID
3072: AND status='DRAFT') )*/
3073:
3074:

Line 3091: FROM AR_GTA_TRX_HEADERS_ALL JGTHA

3087: SELECT JGTHA.ra_trx_id
3088: , JGTHA.description
3089: , JGTHA.org_id
3090: , JGTHA.gta_trx_number
3091: FROM AR_GTA_TRX_HEADERS_ALL JGTHA
3092: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
3093: AND JGTHA.Invoice_Type<>'2'--Yao Zhang add for bug 7673309
3094: AND JGTHA.source='AR'--Yao Zhang add for bug 7673309
3095: AND JGTHA.status = 'DRAFT'

Line 3100: FROM AR_GTA_TRX_HEADERS_ALL JGTH

3096: AND JGTHA.generator_id = p_generator_ID
3097: AND JGTHA.org_id = p_org_id
3098: /* AND JGTHA.description IN ( SELECT DISTINCT description
3099: FROM (SELECT description
3100: FROM AR_GTA_TRX_HEADERS_ALL JGTH
3101: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
3102: INTERSECT
3103: SELECT description
3104: FROM AR_GTA_TRX_HEADERS_ALL

Line 3104: FROM AR_GTA_TRX_HEADERS_ALL

3100: FROM AR_GTA_TRX_HEADERS_ALL JGTH
3101: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
3102: INTERSECT
3103: SELECT description
3104: FROM AR_GTA_TRX_HEADERS_ALL
3105: WHERE Generator_Id=p_generator_ID
3106: AND status='DRAFT') ) ;*/
3107:
3108:

Line 3207: , AR_GTA_TRX_HEADERS_ALL JGTH

3203: SELECT DISTINCT RCTT.type
3204: INTO lv_class_type
3205: FROM RA_CUST_TRX_TYPES_ALL RCTT
3206: , RA_CUSTOMER_TRX_ALL RCT
3207: , AR_GTA_TRX_HEADERS_ALL JGTH
3208: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
3209: AND JGTH.source = 'AR'
3210: AND RCTT.org_id = p_GTA_org_id
3211: AND RCT.customer_trx_id = p_GTA_trx_id