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.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_AR_TRX_LINES

Line 46: FROM JAI_AR_TRX_LINES

42: WHERE customer_trx_id = v_header_id;
43:
44: CURSOR OLD_CUSTOMER_TRX_ID_CUR IS
45: SELECT Customer_Trx_Id
46: FROM JAI_AR_TRX_LINES
47: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
48:
49: cursor c_bill_only_invoice(cp_customer_trx_line_id number, cp_process_name oe_wf_line_assign_v.process_name%type ) is
50: select 1

Line 79: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS

75: AND A.tax_id = c.tax_id
76: and c.tax_type <> lc_modvat_tax
77: ORDER BY A.tax_line_no;
78:
79: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
80: SELECT *
81: FROM
82: JAI_AR_TRX_LINES
83: WHERE customer_trx_line_id = pn_customer_trx_line_id

Line 82: JAI_AR_TRX_LINES

78:
79: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
80: SELECT *
81: FROM
82: JAI_AR_TRX_LINES
83: WHERE customer_trx_line_id = pn_customer_trx_line_id
84: AND customer_trx_id = pn_customer_trx_id;
85: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
86: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

Line 85: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

81: FROM
82: JAI_AR_TRX_LINES
83: WHERE customer_trx_line_id = pn_customer_trx_line_id
84: AND customer_trx_id = pn_customer_trx_id;
85: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
86: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
87:
88: cursor c_get_rec(cn_customer_trx_id number)
89: is

Line 86: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

82: JAI_AR_TRX_LINES
83: WHERE customer_trx_line_id = pn_customer_trx_line_id
84: AND customer_trx_id = pn_customer_trx_id;
85: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
86: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
87:
88: cursor c_get_rec(cn_customer_trx_id number)
89: is
90: select *

Line 345: FROM JAI_AR_TRX_LINES

341: rec_so_lines JA_SO_LINES_INFO%rowtype;
342:
343: CURSOR DUPLICATE_LINES_CUR IS
344: SELECT 1
345: FROM JAI_AR_TRX_LINES
346: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
347:
348: --Variables
349: x number;

Line 399: v_ar3_form_no JAI_AR_TRX_LINES.ar3_form_no%TYPE;

395: v_preprinted_excise_inv_no VARCHAR2(50);
396: v_excise_exempt_type VARCHAR2(60);
397: v_excise_exempt_refno VARCHAR2(30);
398: v_excise_exempt_date DATE;
399: v_ar3_form_no JAI_AR_TRX_LINES.ar3_form_no%TYPE;
400: v_ar3_form_date Date;
401: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
402: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
403: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;

Line 401: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;

397: v_excise_exempt_refno VARCHAR2(30);
398: v_excise_exempt_date DATE;
399: v_ar3_form_no JAI_AR_TRX_LINES.ar3_form_no%TYPE;
400: v_ar3_form_date Date;
401: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
402: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
403: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
404: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
405: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE;

Line 402: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;

398: v_excise_exempt_date DATE;
399: v_ar3_form_no JAI_AR_TRX_LINES.ar3_form_no%TYPE;
400: v_ar3_form_date Date;
401: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
402: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
403: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
404: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
405: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE;
406: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;

Line 403: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;

399: v_ar3_form_no JAI_AR_TRX_LINES.ar3_form_no%TYPE;
400: v_ar3_form_date Date;
401: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
402: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
403: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
404: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
405: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE;
406: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
407: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;

Line 404: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;

400: v_ar3_form_date Date;
401: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
402: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
403: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
404: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
405: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE;
406: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
407: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
408: v_service_type VARCHAR2(30);

Line 405: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE;

401: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
402: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
403: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
404: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
405: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE;
406: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
407: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
408: v_service_type VARCHAR2(30);
409: v_line_count NUMBER;

Line 474: from JAI_AR_TRX_LINES

470: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
471:
472: cursor c_get_amounts is
473: select sum(tax_amount) tax_amt , sum(line_amount) line_amt
474: from JAI_AR_TRX_LINES
475: where customer_trx_id = pr_new.customer_trx_id;
476:
477: cursor c_default_location(CP_ORGANIZATION_ID number) is
478: select DEFAULT_LOCATION_BILL_ONLY

Line 725: insert into the JAI_AR_TRX_TAX_LINES table and then insert into the JAI_AR_TRX_LINES table.

721: end if;
722: end if;
723:
724: /*
725: insert into the JAI_AR_TRX_TAX_LINES table and then insert into the JAI_AR_TRX_LINES table.
726: pr_new.interface_line_attribute6 = order_line_id
727: pr_new.interface_line_context = 'ORDER ENTRY'
728: */
729:

Line 1028: INSERT INTO JAI_AR_TRX_LINES (

1024:
1025:
1026:
1027:
1028: INSERT INTO JAI_AR_TRX_LINES (
1029: customer_trx_line_id ,
1030: line_number ,
1031: customer_trx_id ,
1032: description ,

Line 1102: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);

1098: rec_so_lines.vat_assessable_value ,
1099: rec_so_lines.service_type_code
1100: );
1101: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1102: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);
1103: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
1104: CLOSE c_jai_ar_trx_lines;
1105:
1106: lv_action := jai_constants.INSERTING;

Line 1103: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;

1099: rec_so_lines.service_type_code
1100: );
1101: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1102: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);
1103: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
1104: CLOSE c_jai_ar_trx_lines;
1105:
1106: lv_action := jai_constants.INSERTING;
1107:

Line 1104: CLOSE c_jai_ar_trx_lines;

1100: );
1101: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1102: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);
1103: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
1104: CLOSE c_jai_ar_trx_lines;
1105:
1106: lv_action := jai_constants.INSERTING;
1107:
1108: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (

Line 1746: Insert into JAI_AR_TRX_LINES

1742: NVL(r_add.SHIP_TO_SITE_USE_ID, r_add.BILL_TO_SITE_USE_ID),'C');
1743:
1744: for so_line_rec in c_get_om_lines(v_config_line_id)
1745: Loop
1746: Insert into JAI_AR_TRX_LINES
1747: (
1748: customer_trx_line_id ,
1749: customer_trx_id ,
1750: line_number ,

Line 1820: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

1816: v_service_type
1817: );
1818:
1819: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1820: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
1821: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
1822: CLOSE c_jai_ar_trx_lines;
1823:
1824: lv_action := jai_constants.INSERTING;

Line 1821: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;

1817: );
1818:
1819: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1820: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
1821: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
1822: CLOSE c_jai_ar_trx_lines;
1823:
1824: lv_action := jai_constants.INSERTING;
1825:

Line 1822: CLOSE c_jai_ar_trx_lines;

1818:
1819: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1820: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
1821: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
1822: CLOSE c_jai_ar_trx_lines;
1823:
1824: lv_action := jai_constants.INSERTING;
1825:
1826: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (

Line 1840: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);

1836: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
1837:
1838: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1839: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
1840: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1841: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);*/
1842: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1843: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1844: G_MODULE_NAME || l_api_name || '.IN',

Line 1846: ||' Inserted jai_ar_trx_lines for TRX LINE ID ='||v_customer_trx_line_id

1842: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1843: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1844: G_MODULE_NAME || l_api_name || '.IN',
1845: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
1846: ||' Inserted jai_ar_trx_lines for TRX LINE ID ='||v_customer_trx_line_id
1847: ||' ;Trx id ='||v_header_id
1848: );
1849: end if;
1850:

Line 2695: INSERT INTO JAI_AR_TRX_LINES (

2691: fetch JA_SO_LINES_INFO into rec_so_lines;
2692: close JA_SO_LINES_INFO;
2693:
2694:
2695: INSERT INTO JAI_AR_TRX_LINES (
2696: customer_trx_line_id ,
2697: line_number ,
2698: customer_trx_id ,
2699: description ,

Line 2769: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

2765: ln_vat_assessable_value,
2766: rec_so_lines.service_type_code
2767: );
2768: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
2769: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
2770: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
2771: CLOSE c_jai_ar_trx_lines;
2772:
2773: lv_action := jai_constants.INSERTING;

Line 2770: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;

2766: rec_so_lines.service_type_code
2767: );
2768: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
2769: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
2770: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
2771: CLOSE c_jai_ar_trx_lines;
2772:
2773: lv_action := jai_constants.INSERTING;
2774:

Line 2771: CLOSE c_jai_ar_trx_lines;

2767: );
2768: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
2769: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
2770: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
2771: CLOSE c_jai_ar_trx_lines;
2772:
2773: lv_action := jai_constants.INSERTING;
2774:
2775: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (

Line 2799: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);

2795: --WHERE customer_trx_line_id = v_customer_trx_line_id;
2796:
2797: IF v_old_customer_trx_id <> v_header_id THEN
2798: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
2799: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);
2800: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
2801: CLOSE c_jai_ar_trx_lines;
2802:
2803: UPDATE JAI_AR_TRX_LINES

Line 2800: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;

2796:
2797: IF v_old_customer_trx_id <> v_header_id THEN
2798: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
2799: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);
2800: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
2801: CLOSE c_jai_ar_trx_lines;
2802:
2803: UPDATE JAI_AR_TRX_LINES
2804: SET customer_trx_id = v_header_id

Line 2801: CLOSE c_jai_ar_trx_lines;

2797: IF v_old_customer_trx_id <> v_header_id THEN
2798: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
2799: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);
2800: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
2801: CLOSE c_jai_ar_trx_lines;
2802:
2803: UPDATE JAI_AR_TRX_LINES
2804: SET customer_trx_id = v_header_id
2805: WHERE customer_trx_line_id = v_customer_trx_line_id;

Line 2803: UPDATE JAI_AR_TRX_LINES

2799: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);
2800: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
2801: CLOSE c_jai_ar_trx_lines;
2802:
2803: UPDATE JAI_AR_TRX_LINES
2804: SET customer_trx_id = v_header_id
2805: WHERE customer_trx_line_id = v_customer_trx_line_id;
2806:
2807: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

Line 2807: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

2803: UPDATE JAI_AR_TRX_LINES
2804: SET customer_trx_id = v_header_id
2805: WHERE customer_trx_line_id = v_customer_trx_line_id;
2806:
2807: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
2808: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
2809: CLOSE c_jai_ar_trx_lines;
2810:
2811: lv_action := jai_constants.UPDATING;

Line 2808: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;

2804: SET customer_trx_id = v_header_id
2805: WHERE customer_trx_line_id = v_customer_trx_line_id;
2806:
2807: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
2808: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
2809: CLOSE c_jai_ar_trx_lines;
2810:
2811: lv_action := jai_constants.UPDATING;
2812:

Line 2809: CLOSE c_jai_ar_trx_lines;

2805: WHERE customer_trx_line_id = v_customer_trx_line_id;
2806:
2807: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
2808: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
2809: CLOSE c_jai_ar_trx_lines;
2810:
2811: lv_action := jai_constants.UPDATING;
2812:
2813: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 3173: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS

3169: AND A.sup_inv_type = b.supp_inv_type
3170: AND C.cust_trx_type_id = D.cust_trx_type_id
3171: AND b.supp_inv_type = DECODE(D.TYPE,'DM','DB','CM','CR','INV','SI');
3172:
3173: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
3174: SELECT *
3175: FROM
3176: JAI_AR_TRX_LINES
3177: WHERE customer_trx_line_id = pn_customer_trx_line_id

Line 3176: JAI_AR_TRX_LINES

3172:
3173: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
3174: SELECT *
3175: FROM
3176: JAI_AR_TRX_LINES
3177: WHERE customer_trx_line_id = pn_customer_trx_line_id
3178: AND customer_trx_id = pn_customer_trx_id;
3179:
3180: cursor c_get_rec(cn_customer_trx_id number)

Line 3257: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

3253: FROM ra_customer_trx_all
3254: WHERE customer_trx_id = pr_new.customer_trx_id
3255: AND org_id = pr_new.org_id;
3256:
3257: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
3258: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
3259:
3260: --Variables
3261: v_exchange_rate NUMBER;

Line 3258: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

3254: WHERE customer_trx_id = pr_new.customer_trx_id
3255: AND org_id = pr_new.org_id;
3256:
3257: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
3258: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
3259:
3260: --Variables
3261: v_exchange_rate NUMBER;
3262: x NUMBER;

Line 3756: INSERT INTO JAI_AR_TRX_LINES (

3752:
3753: v_service_type:=get_service_type( NVL(r_add.SHIP_TO_CUSTOMER_ID ,r_add.BILL_TO_CUSTOMER_ID) ,
3754: NVL(r_add.SHIP_TO_SITE_USE_ID, r_add.BILL_TO_SITE_USE_ID),'C');
3755:
3756: INSERT INTO JAI_AR_TRX_LINES (
3757: customer_trx_line_id ,
3758: line_number ,
3759: customer_trx_id ,
3760: description ,

Line 3801: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

3797: v_last_update_login,
3798: v_service_type
3799: );
3800: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
3801: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
3802: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
3803: CLOSE c_jai_ar_trx_lines;
3804:
3805: lv_action := jai_constants.INSERTING;

Line 3802: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;

3798: v_service_type
3799: );
3800: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
3801: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
3802: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
3803: CLOSE c_jai_ar_trx_lines;
3804:
3805: lv_action := jai_constants.INSERTING;
3806:

Line 3803: CLOSE c_jai_ar_trx_lines;

3799: );
3800: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
3801: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
3802: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
3803: CLOSE c_jai_ar_trx_lines;
3804:
3805: lv_action := jai_constants.INSERTING;
3806:
3807: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (

Line 4104: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

4100: END IF;
4101: END IF;
4102:
4103: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
4104: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
4105: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
4106: CLOSE c_jai_ar_trx_lines;
4107:
4108: UPDATE JAI_AR_TRX_LINES

Line 4105: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;

4101: END IF;
4102:
4103: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
4104: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
4105: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
4106: CLOSE c_jai_ar_trx_lines;
4107:
4108: UPDATE JAI_AR_TRX_LINES
4109: SET payment_register = v_reg_type,

Line 4106: CLOSE c_jai_ar_trx_lines;

4102:
4103: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
4104: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
4105: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
4106: CLOSE c_jai_ar_trx_lines;
4107:
4108: UPDATE JAI_AR_TRX_LINES
4109: SET payment_register = v_reg_type,
4110: excise_invoice_no = v_exc_invoice_no,

Line 4108: UPDATE JAI_AR_TRX_LINES

4104: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
4105: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
4106: CLOSE c_jai_ar_trx_lines;
4107:
4108: UPDATE JAI_AR_TRX_LINES
4109: SET payment_register = v_reg_type,
4110: excise_invoice_no = v_exc_invoice_no,
4111: excise_invoice_date = trunc(sysdate)
4112: WHERE

Line 4117: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

4113: customer_trx_line_id = v_customer_trx_line_id AND
4114: inventory_item_id = pr_new.inventory_item_id AND
4115: customer_trx_id = v_header_id;
4116:
4117: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
4118: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
4119: CLOSE c_jai_ar_trx_lines;
4120:
4121: lv_action := jai_constants.UPDATING;

Line 4118: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;

4114: inventory_item_id = pr_new.inventory_item_id AND
4115: customer_trx_id = v_header_id;
4116:
4117: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
4118: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
4119: CLOSE c_jai_ar_trx_lines;
4120:
4121: lv_action := jai_constants.UPDATING;
4122:

Line 4119: CLOSE c_jai_ar_trx_lines;

4115: customer_trx_id = v_header_id;
4116:
4117: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
4118: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
4119: CLOSE c_jai_ar_trx_lines;
4120:
4121: lv_action := jai_constants.UPDATING;
4122:
4123: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 4337: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;

4333:
4334: vsqlerrm VARCHAR2(240);
4335:
4336:
4337: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
4338: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
4339: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
4340: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
4341: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;

Line 4338: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;

4334: vsqlerrm VARCHAR2(240);
4335:
4336:
4337: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
4338: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
4339: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
4340: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
4341: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
4342:

Line 4339: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;

4335:
4336:
4337: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
4338: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
4339: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
4340: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
4341: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
4342:
4343:

Line 4340: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;

4336:
4337: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
4338: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
4339: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
4340: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
4341: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
4342:
4343:
4344:

Line 4341: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;

4337: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
4338: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
4339: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
4340: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
4341: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
4342:
4343:
4344:
4345: --lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;

Line 4489: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

4485: ---------------------------------------------------------
4486: --Added by Zhiwei for JAI Trigger elimination end
4487:
4488: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
4489: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
4490: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
4491:
4492: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
4493: SELECT *

Line 4490: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

4486: --Added by Zhiwei for JAI Trigger elimination end
4487:
4488: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
4489: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
4490: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
4491:
4492: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
4493: SELECT *
4494: FROM

Line 4492: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS

4488: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
4489: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
4490: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
4491:
4492: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
4493: SELECT *
4494: FROM
4495: JAI_AR_TRX_LINES
4496: WHERE customer_trx_line_id = pn_customer_trx_line_id

Line 4495: JAI_AR_TRX_LINES

4491:
4492: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
4493: SELECT *
4494: FROM
4495: JAI_AR_TRX_LINES
4496: WHERE customer_trx_line_id = pn_customer_trx_line_id
4497: AND customer_trx_id = pn_customer_trx_id;
4498: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
4499:

Line 4831: FROM JAI_AR_TRX_LINES

4827:
4828:
4829: CURSOR DUPLICATE_LINES_CUR IS
4830: SELECT 1
4831: FROM JAI_AR_TRX_LINES
4832: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
4833:
4834: CURSOR OLD_CUSTOMER_TRX_ID_CUR IS
4835: SELECT Customer_Trx_Id

Line 4836: FROM JAI_AR_TRX_LINES

4832: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
4833:
4834: CURSOR OLD_CUSTOMER_TRX_ID_CUR IS
4835: SELECT Customer_Trx_Id
4836: FROM JAI_AR_TRX_LINES
4837: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
4838:
4839: CURSOR CREATED_FROM_CUR IS
4840: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,

Line 5009: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

5005:
5006: ---------------------------------------------------------
5007: --Added by Zhiwei for JAI Trigger elimination end
5008: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
5009: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
5010: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
5011:
5012: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
5013: SELECT *

Line 5010: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

5006: ---------------------------------------------------------
5007: --Added by Zhiwei for JAI Trigger elimination end
5008: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
5009: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
5010: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
5011:
5012: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
5013: SELECT *
5014: FROM

Line 5012: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS

5008: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
5009: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
5010: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
5011:
5012: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
5013: SELECT *
5014: FROM
5015: JAI_AR_TRX_LINES
5016: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id

Line 5015: JAI_AR_TRX_LINES

5011:
5012: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
5013: SELECT *
5014: FROM
5015: JAI_AR_TRX_LINES
5016: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id
5017: AND customer_trx_line_id = pn_customer_trx_line_id;
5018: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
5019: l_api_name CONSTANT VARCHAR2(30) := 'POP_JAI_RMACM()';

Line 5061: from JAI_AR_TRX_LINES

5057: ORDER BY tax_line_no;
5058:
5059: cursor c_get_amounts is
5060: select sum(tax_amount) tax_amt , sum(line_amount) line_amt
5061: from JAI_AR_TRX_LINES
5062: where customer_trx_id = pr_new.customer_trx_id;
5063:
5064: cursor c_default_location(CP_ORGANIZATION_ID number) is
5065: select DEFAULT_LOCATION_BILL_ONLY

Line 5297: insert into the JAI_AR_TRX_TAX_LINES table and then insert into the JAI_AR_TRX_LINES table.

5293: end if;
5294: end if;
5295:
5296: /*
5297: insert into the JAI_AR_TRX_TAX_LINES table and then insert into the JAI_AR_TRX_LINES table.
5298: pr_new.interface_line_attribute6 = order_line_id
5299: pr_new.interface_line_context = 'ORDER ENTRY'
5300: */
5301:

Line 5599: INSERT INTO JAI_AR_TRX_LINES (

5595:
5596:
5597:
5598:
5599: INSERT INTO JAI_AR_TRX_LINES (
5600: customer_trx_line_id,
5601: line_number,
5602: customer_trx_id,
5603: description,

Line 5644: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);

5640: fnd_global.login_id ,
5641: rec_so_lines.service_type_code
5642: );
5643: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
5644: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);
5645: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
5646: CLOSE c_jai_ar_trx_lines;
5647:
5648: lv_action := jai_constants.INSERTING;

Line 5645: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;

5641: rec_so_lines.service_type_code
5642: );
5643: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
5644: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);
5645: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
5646: CLOSE c_jai_ar_trx_lines;
5647:
5648: lv_action := jai_constants.INSERTING;
5649:

Line 5646: CLOSE c_jai_ar_trx_lines;

5642: );
5643: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
5644: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);
5645: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
5646: CLOSE c_jai_ar_trx_lines;
5647:
5648: lv_action := jai_constants.INSERTING;
5649:
5650: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (

Line 6052: INSERT INTO JAI_AR_TRX_LINES

6048: v_tax_amount :=0;
6049: END IF;
6050:
6051:
6052: INSERT INTO JAI_AR_TRX_LINES
6053: (customer_trx_line_id,
6054: line_number,
6055: customer_trx_id,
6056: description,

Line 6097: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

6093: v_last_update_login,
6094: v_service_type
6095: );
6096: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6097: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
6098: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
6099: CLOSE c_jai_ar_trx_lines;
6100:
6101: lv_action := jai_constants.INSERTING;

Line 6098: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;

6094: v_service_type
6095: );
6096: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6097: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
6098: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
6099: CLOSE c_jai_ar_trx_lines;
6100:
6101: lv_action := jai_constants.INSERTING;
6102:

Line 6099: CLOSE c_jai_ar_trx_lines;

6095: );
6096: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6097: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
6098: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
6099: CLOSE c_jai_ar_trx_lines;
6100:
6101: lv_action := jai_constants.INSERTING;
6102:
6103: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (

Line 6125: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);

6121: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
6122:
6123: IF v_old_customer_trx_id <> v_header_id THEN
6124: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6125: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);
6126: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
6127: CLOSE c_jai_ar_trx_lines;
6128:
6129: UPDATE JAI_AR_TRX_LINES

Line 6126: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;

6122:
6123: IF v_old_customer_trx_id <> v_header_id THEN
6124: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6125: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);
6126: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
6127: CLOSE c_jai_ar_trx_lines;
6128:
6129: UPDATE JAI_AR_TRX_LINES
6130: SET Customer_Trx_Id = v_header_id

Line 6127: CLOSE c_jai_ar_trx_lines;

6123: IF v_old_customer_trx_id <> v_header_id THEN
6124: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6125: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);
6126: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
6127: CLOSE c_jai_ar_trx_lines;
6128:
6129: UPDATE JAI_AR_TRX_LINES
6130: SET Customer_Trx_Id = v_header_id
6131: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;

Line 6129: UPDATE JAI_AR_TRX_LINES

6125: OPEN c_jai_ar_trx_lines(v_old_customer_trx_id,v_customer_trx_line_id);
6126: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
6127: CLOSE c_jai_ar_trx_lines;
6128:
6129: UPDATE JAI_AR_TRX_LINES
6130: SET Customer_Trx_Id = v_header_id
6131: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
6132:
6133: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

Line 6133: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);

6129: UPDATE JAI_AR_TRX_LINES
6130: SET Customer_Trx_Id = v_header_id
6131: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
6132:
6133: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
6134: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
6135: CLOSE c_jai_ar_trx_lines;
6136:
6137: lv_action := jai_constants.UPDATING;

Line 6134: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;

6130: SET Customer_Trx_Id = v_header_id
6131: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
6132:
6133: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
6134: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
6135: CLOSE c_jai_ar_trx_lines;
6136:
6137: lv_action := jai_constants.UPDATING;
6138:

Line 6135: CLOSE c_jai_ar_trx_lines;

6131: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
6132:
6133: OPEN c_jai_ar_trx_lines(v_header_id,v_customer_trx_line_id);
6134: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
6135: CLOSE c_jai_ar_trx_lines;
6136:
6137: lv_action := jai_constants.UPDATING;
6138:
6139: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 6253: ln_quantity jai_ar_trx_lines.quantity%type;

6249: AND b.customer_trx_id = r_new.customer_trx_id
6250: AND NVL(A.org_id,0) = NVL(r_new.org_id,0);
6251:
6252: r_trx_type c_transaction_type%rowtype;
6253: ln_quantity jai_ar_trx_lines.quantity%type;
6254:
6255:
6256: cursor c_ra_customer_trx is
6257: select trx_number, trx_date, batch_source_id, set_of_books_id

Line 6282: from jai_ar_trx_lines

6278: r_jai_tax_line c_jai_tax_line%rowtype;
6279:
6280: cursor c_jai_ra_customer_trx_line is
6281: select customer_trx_line_id
6282: from jai_ar_trx_lines
6283: where customer_trx_line_id = r_new.customer_trx_line_id;
6284: r_jai_ra_customer_trx_line c_jai_ra_customer_trx_line%rowtype;
6285:
6286: cursor c_get_project_id(cp_project_code in varchar2) is

Line 6351: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

6347:
6348: ---------------------------------------------------------
6349: --Added by Zhiwei for JAI Trigger elimination end
6350: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
6351: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
6352: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
6353:
6354: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
6355: SELECT *

Line 6352: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

6348: ---------------------------------------------------------
6349: --Added by Zhiwei for JAI Trigger elimination end
6350: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
6351: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
6352: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
6353:
6354: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
6355: SELECT *
6356: FROM

Line 6354: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS

6350: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
6351: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
6352: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
6353:
6354: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
6355: SELECT *
6356: FROM
6357: JAI_AR_TRX_LINES
6358: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id

Line 6357: JAI_AR_TRX_LINES

6353:
6354: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
6355: SELECT *
6356: FROM
6357: JAI_AR_TRX_LINES
6358: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id
6359: AND customer_trx_line_id = pn_customer_trx_line_id;
6360: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
6361: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_PROJECTS_TAXES()';

Line 6544: /* insert into jai_ar_trx_lines */

6540: ln_line_tax_amt := nvl(ln_line_tax_amt,0) + ln_tax_amount;
6541: END IF;
6542: end loop;
6543:
6544: /* insert into jai_ar_trx_lines */
6545: open c_jai_ra_customer_trx_line;
6546: fetch c_jai_ra_customer_trx_line into r_jai_ra_customer_trx_line;
6547: close c_jai_ra_customer_trx_line;
6548:

Line 6550: INSERT INTO jai_ar_trx_lines (

6546: fetch c_jai_ra_customer_trx_line into r_jai_ra_customer_trx_line;
6547: close c_jai_ra_customer_trx_line;
6548:
6549: if r_jai_ra_customer_trx_line.customer_trx_line_id is null then
6550: INSERT INTO jai_ar_trx_lines (
6551: customer_trx_line_id ,
6552: line_number ,
6553: customer_trx_id ,
6554: description ,

Line 6623: OPEN c_jai_ar_trx_lines(r_new.customer_trx_id,ln_line_customer_trx_line_id);

6619: r_jai_pa_draft_inv_line.service_type_code
6620: );
6621:
6622: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6623: OPEN c_jai_ar_trx_lines(r_new.customer_trx_id,ln_line_customer_trx_line_id);
6624: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
6625: CLOSE c_jai_ar_trx_lines;
6626:
6627: lv_action := jai_constants.INSERTING;

Line 6624: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;

6620: );
6621:
6622: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6623: OPEN c_jai_ar_trx_lines(r_new.customer_trx_id,ln_line_customer_trx_line_id);
6624: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
6625: CLOSE c_jai_ar_trx_lines;
6626:
6627: lv_action := jai_constants.INSERTING;
6628:

Line 6625: CLOSE c_jai_ar_trx_lines;

6621:
6622: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
6623: OPEN c_jai_ar_trx_lines(r_new.customer_trx_id,ln_line_customer_trx_line_id);
6624: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
6625: CLOSE c_jai_ar_trx_lines;
6626:
6627: lv_action := jai_constants.INSERTING;
6628:
6629: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER (

Line 6758: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

6754:
6755: ---------------------------------------------------------
6756: --Added by Zhiwei for JAI Trigger elimination end
6757: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
6758: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
6759: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
6760:
6761: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
6762: SELECT *

Line 6759: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

6755: ---------------------------------------------------------
6756: --Added by Zhiwei for JAI Trigger elimination end
6757: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
6758: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
6759: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
6760:
6761: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
6762: SELECT *
6763: FROM

Line 6761: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS

6757: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
6758: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
6759: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
6760:
6761: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
6762: SELECT *
6763: FROM
6764: JAI_AR_TRX_LINES
6765: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id

Line 6764: JAI_AR_TRX_LINES

6760:
6761: CURSOR c_jai_ar_trx_lines(pn_customer_trx_id NUMBER,pn_customer_trx_line_id NUMBER) IS
6762: SELECT *
6763: FROM
6764: JAI_AR_TRX_LINES
6765: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id
6766: AND customer_trx_line_id = pn_customer_trx_line_id;
6767: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
6768: l_api_name CONSTANT VARCHAR2(30) := 'GET_LEGAL_ENTITY_ID()';