APPS.JMF_GTA_ARTRX_PROC dependencies on JMF_GTA_TRX_HEADERS_ALL

Line 323: FROM jmf_gta_trx_headers_all

319: FUNCTION get_gta_number(p_ar_trxId IN NUMBER) RETURN VARCHAR2 IS
320: gta_trx_number VARCHAR2(2000);
321: CURSOR get_gta_inv_number_c(p_ra_trx_id IN NUMBER) IS
322: SELECT gta_trx_number
323: FROM jmf_gta_trx_headers_all
324: WHERE ra_trx_id = p_ra_trx_id;
325: BEGIN
326:
327: FOR r_number IN get_gta_inv_number_c(p_ar_trxId) LOOP

Line 442: jmf_gta_trx_headers_all

438: IS
439: SELECT
440: gta_trx_number
441: FROM
442: jmf_gta_trx_headers_all
443: WHERE
444: ra_trx_id = p_ra_trx_id;
445: */
446: --12/04/2006 Jogen Hu bug 5144561

Line 1965: l_gt_invoice_number Jmf_Gta_Trx_Headers_All.gt_invoice_number%TYPE; --VARCHAR2(30);

1961: l_error_string VARCHAR2(1000);
1962: l_error_flag NUMBER := 0;
1963:
1964: --credit memo
1965: l_gt_invoice_number Jmf_Gta_Trx_Headers_All.gt_invoice_number%TYPE; --VARCHAR2(30);
1966: l_gt_invoice_class Jmf_Gta_Trx_Headers_All.GT_INVOICE_CLASS%TYPE; --VARCHAR2(10);
1967: l_origin_trx_id NUMBER(15);
1968: l_gta_invoice_count NUMBER(15);
1969: l_gt_invoice_count NUMBER(15); --added by subba for credit memo check for R12.1

Line 1966: l_gt_invoice_class Jmf_Gta_Trx_Headers_All.GT_INVOICE_CLASS%TYPE; --VARCHAR2(10);

1962: l_error_flag NUMBER := 0;
1963:
1964: --credit memo
1965: l_gt_invoice_number Jmf_Gta_Trx_Headers_All.gt_invoice_number%TYPE; --VARCHAR2(30);
1966: l_gt_invoice_class Jmf_Gta_Trx_Headers_All.GT_INVOICE_CLASS%TYPE; --VARCHAR2(10);
1967: l_origin_trx_id NUMBER(15);
1968: l_gta_invoice_count NUMBER(15);
1969: l_gt_invoice_count NUMBER(15); --added by subba for credit memo check for R12.1
1970: l_ar_inv_cnt NUMBER(15);

Line 2329: FROM jmf_gta_trx_headers_all h

2325: -- and retransfer it , else if the cust_trx_id exist, don't transfer it,
2326: -- else if the cust_trx_id is not exist, transfer it.
2327: SELECT COUNT(*)
2328: INTO l_cust_trx_id_count
2329: FROM jmf_gta_trx_headers_all h
2330: WHERE h.ra_trx_id = l_customer_trx_id;
2331:
2332: IF l_cust_trx_id_count > 0 THEN
2333: SELECT COUNT(*)

Line 2335: FROM jmf_gta_trx_headers_all h

2331:
2332: IF l_cust_trx_id_count > 0 THEN
2333: SELECT COUNT(*)
2334: INTO l_trx_id_cancel_count
2335: FROM jmf_gta_trx_headers_all h
2336: WHERE h.ra_trx_id = l_customer_trx_id
2337: AND h.latest_version_flag = 'Y'
2338: AND h.status = 'CANCEL'
2339: AND h.version > 1;

Line 2342: DELETE jmf_gta_trx_headers_all h

2338: AND h.status = 'CANCEL'
2339: AND h.version > 1;
2340:
2341: IF l_trx_id_cancel_count > 0 THEN
2342: DELETE jmf_gta_trx_headers_all h
2343: WHERE h.ra_trx_id = l_customer_trx_id
2344: AND h.latest_version_flag = 'Y'
2345: AND h.status = 'CANCEL'
2346: AND h.version > 1;

Line 2603: Jmf_Gta_Trx_Headers_All

2599: INTO
2600: l_gta_invoice_count
2601:
2602: FROM
2603: Jmf_Gta_Trx_Headers_All
2604: WHERE ra_trx_id=l_ar_cur.trx_id
2605: AND SOURCE = 'AR';
2606:
2607: IF l_gta_invoice_count > 0 THEN --credit memo associated to AR invoice which is transferred to GTA

Line 2617: Jmf_Gta_Trx_Headers_All

2613: INTO
2614: l_gt_invoice_count
2615:
2616: FROM
2617: Jmf_Gta_Trx_Headers_All
2618: WHERE ra_trx_id=l_ar_cur.trx_id
2619: AND SOURCE = 'GT';
2620:
2621: IF l_gt_invoice_count = 0 THEN --AR trx is in workbench but VAT not generated.

Line 2645: SELECT jmf_gta_trx_headers_all_s.NEXTVAL

2641:
2642: --end relaxing validation on CM for R12.1
2643:
2644: -- begin insert value into l_trx_header
2645: SELECT jmf_gta_trx_headers_all_s.NEXTVAL
2646: INTO l_trx_header.gta_trx_header_id
2647: FROM dual;
2648:
2649: --29/06/2006 Added by Shujuan Yan for bug 5263131

Line 2906: FROM Jmf_Gta_Trx_Headers_All

2902: -- this credit memo is credited with AR invoice
2903: --Select all AR invoices associated with credit memo.
2904: SELECT count(*)
2905: INTO l_ar_invoice_count
2906: FROM Jmf_Gta_Trx_Headers_All
2907: WHERE ra_trx_id = l_pre_cus_trxid
2908: AND SOURCE = 'AR';
2909:
2910: IF l_ar_invoice_count = 0 THEN

Line 2926: FROM Jmf_Gta_Trx_Headers_All

2922: then
2923: --check whether the GT invoice has been imported.
2924: SELECT count(*)
2925: INTO l_gt_invoice_count
2926: FROM Jmf_Gta_Trx_Headers_All
2927: WHERE ra_trx_id = l_pre_cus_trxid
2928: AND source='GT'; --Yao Zhang Modified fix bug 7670543
2929:
2930: IF l_gt_invoice_count = 0

Line 2938: FROM Jmf_Gta_Trx_Headers_All

2934: --Yao Zhang add begin for bug 7685610--
2935: ELSE--VAT is generated for AR transaction
2936: SELECT gt_invoice_number,gt_invoice_class
2937: INTO l_gt_invoice_number,l_gt_invoice_class
2938: FROM Jmf_Gta_Trx_Headers_All
2939: WHERE ra_trx_id = l_pre_cus_trxid
2940: AND source='GT';
2941: fnd_message.SET_NAME('JMF', 'JMF_GTA_CREDMEMO_EXPORT_IV');
2942: l_cm_desc1:=fnd_message.GET();