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.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_TRX_HEADERS_ALL

Line 524: L_HEADER_ID Jmf_Gta_Trx_Headers_All.Gta_Trx_Header_Id%TYPE;

520: --===========================================================================
521: PROCEDURE Import_Invoices
522: IS
523: l_procedure_name VARCHAR2(30):='Import_invoices';
524: L_HEADER_ID Jmf_Gta_Trx_Headers_All.Gta_Trx_Header_Id%TYPE;
525: l_line_seq NUMBER;
526: l_values COLUMN_VALUES:=COLUMN_VALUES(NULL);
527: l_EOF BOOLEAN;
528: l_num_of_Invoices NUMBER;

Line 530: l_GTA_Invoice_num Jmf_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;

526: l_values COLUMN_VALUES:=COLUMN_VALUES(NULL);
527: l_EOF BOOLEAN;
528: l_num_of_Invoices NUMBER;
529: l_num_of_lines NUMBER;
530: l_GTA_Invoice_num Jmf_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
531: l_org_id NUMBER;
532: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
533: l_trx_header_rec JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
534: l_trx_line_rec JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;

Line 542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;

538: l_fix_field VARCHAR2(100);
539: l_str VARCHAR2(100);
540: l_failed BOOLEAN;
541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

Line 543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;

539: l_str VARCHAR2(100);
540: l_failed BOOLEAN;
541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;

Line 544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;

540: l_failed BOOLEAN;
541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;

Line 545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;

541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
549: l_conc_succ BOOLEAN;

Line 546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
549: l_conc_succ BOOLEAN;
550: l_failed_XML XMLTYPE;

Line 547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;

543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
549: l_conc_succ BOOLEAN;
550: l_failed_XML XMLTYPE;
551: l_succ_XML XMLTYPE;

Line 548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;

544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
549: l_conc_succ BOOLEAN;
550: l_failed_XML XMLTYPE;
551: l_succ_XML XMLTYPE;
552: l_report_XML XMLTYPE;

Line 709: FROM JMF_GTA_TRX_HEADERS_ALL

705: , status
706: INTO l_header_id
707: , l_org_id
708: , l_status
709: FROM JMF_GTA_TRX_HEADERS_ALL
710: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
711: AND SOURCE='AR'
712: AND latest_version_flag='Y';
713:

Line 856: SELECT jmf_gta_trx_headers_all_s.NEXTVAL

852:
853:
854:
855:
856: SELECT jmf_gta_trx_headers_all_s.NEXTVAL
857: INTO l_trx_header_rec.gta_trx_header_id
858: FROM dual;
859:
860: EXCEPTION

Line 1410: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => p_invoice_header_id

1406:
1407: --put to the temporary output
1408: x_output(1):=fnd_message.get;
1409:
1410: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => p_invoice_header_id
1411: , x_trx_header_rec => l_invoice
1412: );
1413:
1414: x_success:=check_header(l_invoice);

Line 1613: l_header_rec_cur Jmf_Gta_Trx_Headers_all%ROWTYPE;

1609: , p_draft_dup_cur IN crmemo_dup_cur_TYPE DEFAULT NULL
1610: )
1611: IS
1612: l_procedure_name VARCHAR2(30):='export_Invoices';
1613: l_header_rec_cur Jmf_Gta_Trx_Headers_all%ROWTYPE;
1614: l_succ_output t_invoice_export_output:=t_invoice_export_output();
1615: l_exceed_output t_invoice_export_output:=t_invoice_export_output();
1616: l_taxpayid_err_out t_invoice_export_output:=t_invoice_export_output();
1617: l_creddit_memo_err t_invoice_export_output:=t_invoice_export_output();

Line 1623: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;

1619:
1620: l_trx_export_success PLS_INTEGER;
1621: l_error_msg VARCHAR2(5000);
1622: l_conc_succ BOOLEAN;
1623: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;
1624: i INTEGER;
1625: l_str VARCHAR2(1000); --Jun-22, 2006, jogen bug 5335265
1626: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1627: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

Line 1743: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => l_gta_trx_header_id

1739: * 'Notification Number for Issued VAT Credit memo+16-digit Notification number'
1740: * if check fails, message 'JMF_GTA_CRMEMO_MISSING_PREFIX' is wroten to output
1741: * file.
1742: */
1743: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => l_gta_trx_header_id
1744: , x_trx_header_rec => p_GTA_trx_header
1745: );
1746:
1747: SELECT DISTINCT RCTT.type

Line 1749: FROM JMF_GTA_TRX_HEADERS_ALL JGTH

1745: );
1746:
1747: SELECT DISTINCT RCTT.type
1748: INTO lv_trx_type
1749: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
1750: , RA_CUST_TRX_TYPES_ALL RCTT
1751: , RA_CUSTOMER_TRX_ALL RCT
1752: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
1753: AND JGTH.source = 'AR'

Line 2311: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;

2307: -------------------------------------------------------------------------------
2308:
2309: l_error_msg VARCHAR2(1000);
2310:
2311: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;
2312: l_batch_number_ok BOOLEAN;
2313: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2314: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2315: l_invoice_type_check VARCHAR2(1); --added for invoice_type condition by Subba.

Line 2426: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA

2422: SELECT JGTHA.ra_trx_id
2423: , JGTHA.description
2424: , JGTHA.org_id
2425: , JGTHA.gta_trx_number
2426: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2427: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2428: AND JGTHA.status IN ('GENERATED', 'COMPLETED')
2429:
2430: AND JGTHA.description IN /*( SELECT h.description

Line 2524: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA

2520: SELECT JGTHA.ra_trx_id
2521: , JGTHA.description
2522: , JGTHA.org_id
2523: , JGTHA.gta_trx_number
2524: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2525: , ra_customer_trx_all ar
2526: , Ra_Cust_Trx_Types_all ctt
2527: , RA_CUST_TRX_LINE_GL_DIST_all gd
2528: , ra_batches_all b

Line 2787: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;

2783: l_cur_draft_dup crmemo_dup_cur_TYPE;--get draft crmemo with duplicate description
2784: -------------------------------------------------------------------------------
2785: --add by Lv Xiao for bug#7626503 on 11-Dec-2008, end
2786:
2787: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;
2788: l_batch_number_ok BOOLEAN;
2789: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2790: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2791: BEGIN

Line 2833: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA

2829: SELECT JGTHA.ra_trx_id
2830: , JGTHA.description
2831: , JGTHA.org_id
2832: , JGTHA.gta_trx_number
2833: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2834: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2835: AND JGTHA.Invoice_Type<>'2'--yao zhang add for bug 7673309
2836: AND JGTHA.source='AR'--yao zhang add for bug7673309
2837: AND JGTHA.status IN ('GENERATED', 'COMPLETED')

Line 2844: FROM JMF_GTA_TRX_HEADERS_ALL JGTH

2840: --modified by Lv Xiao for bug#7644803 on 16-Dec-08, begin
2841: -------------------------------------------------------------------
2842: /* AND JGTHA.description IN ( SELECT DISTINCT description
2843: FROM (SELECT description
2844: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
2845: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2846: INTERSECT
2847: SELECT description
2848: FROM JMF_GTA_TRX_HEADERS_ALL

Line 2848: FROM JMF_GTA_TRX_HEADERS_ALL

2844: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
2845: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2846: INTERSECT
2847: SELECT description
2848: FROM JMF_GTA_TRX_HEADERS_ALL
2849: WHERE Generator_Id=p_generator_ID
2850: AND status='DRAFT') )*/
2851:
2852:

Line 2869: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA

2865: SELECT JGTHA.ra_trx_id
2866: , JGTHA.description
2867: , JGTHA.org_id
2868: , JGTHA.gta_trx_number
2869: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2870: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2871: AND JGTHA.Invoice_Type<>'2'--Yao Zhang add for bug 7673309
2872: AND JGTHA.source='AR'--Yao Zhang add for bug 7673309
2873: AND JGTHA.status = 'DRAFT'

Line 2878: FROM JMF_GTA_TRX_HEADERS_ALL JGTH

2874: AND JGTHA.generator_id = p_generator_ID
2875: AND JGTHA.org_id = p_org_id
2876: /* AND JGTHA.description IN ( SELECT DISTINCT description
2877: FROM (SELECT description
2878: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
2879: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2880: INTERSECT
2881: SELECT description
2882: FROM JMF_GTA_TRX_HEADERS_ALL

Line 2882: FROM JMF_GTA_TRX_HEADERS_ALL

2878: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
2879: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2880: INTERSECT
2881: SELECT description
2882: FROM JMF_GTA_TRX_HEADERS_ALL
2883: WHERE Generator_Id=p_generator_ID
2884: AND status='DRAFT') ) ;*/
2885:
2886:

Line 2985: , JMF_GTA_TRX_HEADERS_ALL JGTH

2981: SELECT DISTINCT RCTT.type
2982: INTO lv_class_type
2983: FROM RA_CUST_TRX_TYPES_ALL RCTT
2984: , RA_CUSTOMER_TRX_ALL RCT
2985: , JMF_GTA_TRX_HEADERS_ALL JGTH
2986: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
2987: AND JGTH.source = 'AR'
2988: AND RCTT.org_id = p_GTA_org_id
2989: AND RCT.customer_trx_id = p_GTA_trx_id