APPS.AR_GTA_ARTRX_PROC dependencies on AR_GTA_TRX_HEADERS_ALL

Line 350: FROM ar_gta_trx_headers_all

346: FUNCTION get_gta_number(p_ar_trxId IN NUMBER) RETURN VARCHAR2 IS
347: gta_trx_number VARCHAR2(2000);
348: CURSOR get_gta_inv_number_c(p_ra_trx_id IN NUMBER) IS
349: SELECT gta_trx_number
350: FROM ar_gta_trx_headers_all
351: WHERE ra_trx_id = p_ra_trx_id;
352: BEGIN
353:
354: FOR r_number IN get_gta_inv_number_c(p_ar_trxId) LOOP

Line 470: ar_gta_trx_headers_all

466: IS
467: SELECT
468: gta_trx_number
469: FROM
470: ar_gta_trx_headers_all
471: WHERE
472: ra_trx_id = p_ra_trx_id;
473: */
474: --12/04/2006 Jogen Hu bug 5144561

Line 2019: l_gt_invoice_number AR_Gta_Trx_Headers_All.gt_invoice_number%TYPE; --VARCHAR2(30);

2015: l_error_string VARCHAR2(1000);
2016: l_error_flag NUMBER := 0;
2017:
2018: --credit memo
2019: l_gt_invoice_number AR_Gta_Trx_Headers_All.gt_invoice_number%TYPE; --VARCHAR2(30);
2020: l_gt_invoice_class AR_Gta_Trx_Headers_All.GT_INVOICE_CLASS%TYPE; --VARCHAR2(10);
2021: l_origin_trx_id NUMBER(15);
2022: l_gta_invoice_count NUMBER(15);
2023: l_gt_invoice_count NUMBER(15); --added by subba for credit memo check for R12.1

Line 2020: l_gt_invoice_class AR_Gta_Trx_Headers_All.GT_INVOICE_CLASS%TYPE; --VARCHAR2(10);

2016: l_error_flag NUMBER := 0;
2017:
2018: --credit memo
2019: l_gt_invoice_number AR_Gta_Trx_Headers_All.gt_invoice_number%TYPE; --VARCHAR2(30);
2020: l_gt_invoice_class AR_Gta_Trx_Headers_All.GT_INVOICE_CLASS%TYPE; --VARCHAR2(10);
2021: l_origin_trx_id NUMBER(15);
2022: l_gta_invoice_count NUMBER(15);
2023: l_gt_invoice_count NUMBER(15); --added by subba for credit memo check for R12.1
2024: l_ar_inv_cnt NUMBER(15);

Line 2425: FROM ar_gta_trx_headers_all h

2421: -- and retransfer it , else if the cust_trx_id exist, don't transfer it,
2422: -- else if the cust_trx_id is not exist, transfer it.
2423: SELECT COUNT(*)
2424: INTO l_cust_trx_id_count
2425: FROM ar_gta_trx_headers_all h
2426: WHERE h.ra_trx_id = l_customer_trx_id;
2427:
2428: IF l_cust_trx_id_count > 0 THEN
2429: SELECT COUNT(*)

Line 2431: FROM ar_gta_trx_headers_all h

2427:
2428: IF l_cust_trx_id_count > 0 THEN
2429: SELECT COUNT(*)
2430: INTO l_trx_id_cancel_count
2431: FROM ar_gta_trx_headers_all h
2432: WHERE h.ra_trx_id = l_customer_trx_id
2433: AND h.latest_version_flag = 'Y'
2434: AND h.status = 'CANCEL'
2435: AND h.version > 1;

Line 2438: DELETE ar_gta_trx_headers_all h

2434: AND h.status = 'CANCEL'
2435: AND h.version > 1;
2436:
2437: IF l_trx_id_cancel_count > 0 THEN
2438: DELETE ar_gta_trx_headers_all h
2439: WHERE h.ra_trx_id = l_customer_trx_id
2440: AND h.latest_version_flag = 'Y'
2441: AND h.status = 'CANCEL'
2442: AND h.version > 1;

Line 2726: AR_Gta_Trx_Headers_All

2722: INTO
2723: l_gta_invoice_count
2724:
2725: FROM
2726: AR_Gta_Trx_Headers_All
2727: WHERE ra_trx_id=l_ar_cur.trx_id
2728: AND SOURCE = 'AR';
2729:
2730: IF l_gta_invoice_count > 0 THEN --credit memo associated to AR invoice which is transferred to GTA

Line 2740: AR_Gta_Trx_Headers_All

2736: INTO
2737: l_gt_invoice_count
2738:
2739: FROM
2740: AR_Gta_Trx_Headers_All
2741: WHERE ra_trx_id=l_ar_cur.trx_id
2742: AND SOURCE = 'GT';
2743:
2744: IF l_gt_invoice_count = 0 THEN --AR trx is in workbench but VAT not generated.

Line 2768: SELECT ar_gta_trx_headers_all_s.NEXTVAL

2764:
2765: --end relaxing validation on CM for R12.1
2766:
2767: -- begin insert value into l_trx_header
2768: SELECT ar_gta_trx_headers_all_s.NEXTVAL
2769: INTO l_trx_header.gta_trx_header_id
2770: FROM dual;
2771:
2772: --yao zhang add for bug 8234250 begin

Line 3235: FROM ar_gta_trx_headers_all

3231: -- this credit memo is credited with AR invoice
3232: --Select all AR invoices associated with credit memo.
3233: SELECT COUNT(*)
3234: INTO l_ar_invoice_count
3235: FROM ar_gta_trx_headers_all
3236: WHERE ra_trx_id = l_pre_cus_trxid
3237: AND SOURCE = 'AR';
3238: IF l_ar_invoice_count = 0 THEN
3239: --AR invoice has not been transfered to GTA

Line 3250: FROM AR_Gta_Trx_Headers_All

3246: THEN
3247: --check whether the GT invoice has been imported.
3248: SELECT count(*)
3249: INTO l_gt_invoice_count
3250: FROM AR_Gta_Trx_Headers_All
3251: WHERE ra_trx_id = l_pre_cus_trxid
3252: AND source = 'GT'; --Yao Zhang Modified fix bug 7670543
3253:
3254: IF l_gt_invoice_count = 0 THEN

Line 3263: FROM AR_Gta_Trx_Headers_All

3259: ELSE
3260: --VAT is generated for AR transaction
3261: SELECT gt_invoice_number, gt_invoice_class
3262: INTO l_gt_invoice_number, l_gt_invoice_class
3263: FROM AR_Gta_Trx_Headers_All
3264: WHERE ra_trx_id = l_pre_cus_trxid
3265: AND source = 'GT';
3266: fnd_message.SET_NAME('AR',
3267: 'AR_GTA_CREDMEMO_EXPORT_IV');