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

Line 185: TYPE c_trx_header_id_type IS REF CURSOR RETURN ar_gta_trx_headers%ROWTYPE;

181: --+======================================================================*/
182:
183: --TYPE COLUMN_VALUES IS TABLE OF VARCHAR2(200);
184: TYPE t_invoice_export_output IS TABLE OF VARCHAR2(5000);
185: TYPE c_trx_header_id_type IS REF CURSOR RETURN ar_gta_trx_headers%ROWTYPE;
186:
187: --===================
188: -- CONSTANTS
189: --===================

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 793: DELETE AR_GTA_TRX_HEADERS

789: THEN
790: IF(l_status='CANCELLED' And l_values(1)='0') OR (l_status='GENERATED')
791: THEN
792: --clear the record imported before
793: DELETE AR_GTA_TRX_HEADERS
794: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
795: AND SOURCE='GT';
796:
797: DELETE AR_GTA_TRX_LINES

Line 800: FROM AR_GTA_TRX_HEADERS

796:
797: DELETE AR_GTA_TRX_LINES
798: WHERE GTA_TRX_HEADER_ID IN
799: ( SELECT GTA_TRX_HEADER_ID
800: FROM AR_GTA_TRX_HEADERS
801: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
802: AND SOURCE='GT');
803: --change the matched_flag to initiated status.
804: UPDATE AR_GTA_TRX_LINES

Line 838: DELETE AR_GTA_TRX_HEADERS

834: IF l_values(1)='0'
835: THEN
836: --If this VAT is a completed invoice,delete the VAT has been imported and then append this one
837: --otherwise,do not delete the VAT has been imported and then append this one
838: DELETE AR_GTA_TRX_HEADERS
839: WHERE GTA_TRX_NUMBER = l_GTA_Invoice_num
840: AND SOURCE = 'GT';
841:
842: DELETE AR_GTA_TRX_LINES

Line 844: FROM AR_GTA_TRX_HEADERS

840: AND SOURCE = 'GT';
841:
842: DELETE AR_GTA_TRX_LINES
843: WHERE GTA_TRX_HEADER_ID IN (SELECT GTA_TRX_HEADER_ID
844: FROM AR_GTA_TRX_HEADERS
845: WHERE GTA_TRX_NUMBER = l_GTA_Invoice_num
846: AND SOURCE = 'GT');
847: --change the matched_flag to initiated status.
848: UPDATE AR_GTA_TRX_LINES

Line 855: /*UPDATE AR_GTA_TRX_HEADERS

851: END IF;--If l_values(1)='0'
852: END IF;--IF NOT l_vat_tbl.EXISTS(l_gta_invoice_num)
853:
854: --Requested by Donghai, for workbench judge whether upgrade version
855: /*UPDATE AR_GTA_TRX_HEADERS
856: SET Status=l_new_status
857: , gt_invoice_date = l_Invoice_date
858: , gt_invoice_net_amount = l_values(10)
859: , gt_invoice_tax_amount = l_values(12)

Line 921: FROM AR_GTA_TRX_HEADERS

917: , l_trx_header_rec.ra_trx_number
918: , l_trx_header_rec.Fp_Tax_Registration_Number
919: , l_trx_header_rec.Tp_Tax_Registration_Number
920: , l_trx_header_rec.Legal_Entity_Id
921: FROM AR_GTA_TRX_HEADERS
922: WHERE GTA_TRX_HEADER_ID=l_header_id;
923:
924: --fill the data from GT
925: BEGIN

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 1387: UPDATE AR_GTA_TRX_HEADERS

1383: --Add by Sabrina for ER#14830536 Start
1384: l_vat_tbl_index := l_vat_tbl.FIRST;
1385: WHILE(l_vat_tbl_index IS NOT NULL)
1386: LOOP
1387: UPDATE AR_GTA_TRX_HEADERS
1388: SET Status = l_vat_tbl(l_vat_tbl_index).status,
1389: gt_invoice_date = l_vat_tbl(l_vat_tbl_index).gt_invoice_date,
1390: gt_invoice_net_amount = l_vat_tbl(l_vat_tbl_index).gt_invoice_net_amount,
1391: gt_invoice_tax_amount = l_vat_tbl(l_vat_tbl_index).gt_invoice_tax_amount,

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 1682: UPDATE ar_gta_trx_headers

1678: x_output(2):=l_header_output;
1679:
1680: --change GTA status
1681: --fill request_id etc. to P_INVOICE;
1682: UPDATE ar_gta_trx_headers
1683: SET status='GENERATED'
1684: , gta_batch_number =p_batch_number
1685: , export_request_id =fnd_global.CONC_REQUEST_ID
1686: , REQUEST_ID =fnd_global.CONC_REQUEST_ID

Line 1709: UPDATE ar_gta_trx_headers

1705: i:=x_output.NEXT(i);
1706: END LOOP;
1707: END IF ;
1708:
1709: UPDATE ar_gta_trx_headers
1710: SET export_request_id =fnd_global.CONC_REQUEST_ID
1711: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1712: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1713: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID

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 2416: FROM ar_gta_trx_headers

2412: --Jogen Jun-12 2006, bug5351578
2413:
2414: SELECT COUNT(*)
2415: INTO l_rows_same_batch
2416: FROM ar_gta_trx_headers
2417: WHERE gta_batch_number=x_batch_number;
2418:
2419: IF l_rows_same_batch > 0
2420: THEN

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 2603: FROM AR_GTA_TRX_HEADERS h

2599: IF P_Invoice_Type_ID <>'A' THEN --if user selects a particular invoice_type
2600: OPEN l_cur_header FOR
2601: SELECT
2602: h.*
2603: FROM AR_GTA_TRX_HEADERS h
2604: , ra_customer_trx_all ar
2605: , Ra_Cust_Trx_Types_all ctt
2606: , RA_CUST_TRX_LINE_GL_DIST_all gd
2607: , ra_batches_all b

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 2653: FROM AR_GTA_TRX_HEADERS h

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
2653: FROM AR_GTA_TRX_HEADERS h
2654: , ra_customer_trx_all ar
2655: , Ra_Cust_Trx_Types_all ctt
2656: , RA_CUST_TRX_LINE_GL_DIST_all gd
2657: , ra_batches_all b

Line 2690: FROM AR_GTA_TRX_HEADERS JGTH

2686: HAVING COUNT(h.description) > 1)*/
2687:
2688: ( SELECT DISTINCT description
2689: FROM (SELECT description
2690: FROM AR_GTA_TRX_HEADERS JGTH
2691: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2692: INTERSECT
2693: SELECT h.description
2694: FROM AR_GTA_TRX_HEADERS h

Line 2694: FROM AR_GTA_TRX_HEADERS h

2690: FROM AR_GTA_TRX_HEADERS JGTH
2691: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2692: INTERSECT
2693: SELECT h.description
2694: FROM AR_GTA_TRX_HEADERS h
2695: , ra_customer_trx_all ar
2696: , Ra_Cust_Trx_Types_all ctt
2697: , RA_CUST_TRX_LINE_GL_DIST_all gd
2698: , ra_batches_all b

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 2793: FROM AR_GTA_TRX_HEADERS h

2789: AND JGTHA.SOURCE = 'AR'
2790: AND JGTHA.invoice_type = P_Invoice_Type_ID
2791:
2792: AND JGTHA.description IN /*( SELECT h.description
2793: FROM AR_GTA_TRX_HEADERS h
2794: , ra_customer_trx_all ar
2795: , Ra_Cust_Trx_Types_all ctt
2796: , RA_CUST_TRX_LINE_GL_DIST_all gd
2797: , ra_batches_all b

Line 2830: FROM AR_GTA_TRX_HEADERS JGTH

2826: HAVING COUNT(h.description) > 1)*/
2827:
2828: ( SELECT DISTINCT description
2829: FROM (SELECT description
2830: FROM AR_GTA_TRX_HEADERS JGTH
2831: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2832: INTERSECT
2833: SELECT h.description
2834: FROM AR_GTA_TRX_HEADERS h

Line 2834: FROM AR_GTA_TRX_HEADERS h

2830: FROM AR_GTA_TRX_HEADERS JGTH
2831: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2832: INTERSECT
2833: SELECT h.description
2834: FROM AR_GTA_TRX_HEADERS h
2835: , ra_customer_trx_all ar
2836: , Ra_Cust_Trx_Types_all ctt
2837: , RA_CUST_TRX_LINE_GL_DIST_all gd
2838: , ra_batches_all b

Line 2890: FROM AR_GTA_TRX_HEADERS h

2886:
2887: /* OPEN l_cur_header FOR
2888: SELECT
2889: h.*
2890: FROM AR_GTA_TRX_HEADERS h
2891: , ra_customer_trx_all ar
2892: , Ra_Cust_Trx_Types_all ctt
2893: , RA_CUST_TRX_LINE_GL_DIST_all gd
2894: , ra_batches_all b

Line 2935: FROM AR_GTA_TRX_HEADERS

2931:
2932:
2933: OPEN l_cur_header FOR
2934: SELECT *
2935: FROM AR_GTA_TRX_HEADERS
2936: WHERE Gta_Batch_Number=P_Batch_ID
2937: AND status='GENERATED';
2938:
2939: export_Invoices(l_cur_header,P_Batch_ID, NULL, NULL);

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 3037: FROM AR_GTA_TRX_HEADERS

3033:
3034:
3035: OPEN l_cur_header FOR
3036: SELECT *
3037: FROM AR_GTA_TRX_HEADERS
3038: WHERE Generator_Id=p_generator_ID
3039: AND status='DRAFT';
3040:
3041: --add by Lv Xiao for bug#7626503 on 11-Dec-2008, 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 3076: FROM AR_GTA_TRX_HEADERS JGTH

3072: AND status='DRAFT') )*/
3073:
3074:
3075: AND JGTHA.description IN ( SELECT description
3076: FROM AR_GTA_TRX_HEADERS JGTH
3077: WHERE (( status = 'DRAFT'
3078: AND generator_id = p_generator_ID )
3079: OR status IN ('GENERATED', 'COMPLETED'))
3080: AND Invoice_Type<>'2'--yao zhang add for bug 7673309

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 3110: FROM AR_GTA_TRX_HEADERS JGTH

3106: AND status='DRAFT') ) ;*/
3107:
3108:
3109: AND JGTHA.description IN ( SELECT description
3110: FROM AR_GTA_TRX_HEADERS JGTH
3111: WHERE (( status = 'DRAFT'
3112: AND generator_id = p_generator_ID )
3113: OR status IN ('GENERATED', 'COMPLETED'))
3114: AND Invoice_Type<>'2'--Yao Zhang add for bug7673309

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