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_SYNC_PKG dependencies on JAI_AR_TRX_LINES

Line 110: from JAI_AR_TRX_LINES

106: from JAI_AR_TRX_TAX_LINES
107: where link_to_cust_trx_line_id
108: in
109: (select customer_trx_line_id
110: from JAI_AR_TRX_LINES
111: where customer_trx_id = pr_new.customer_trx_id
112: )
113: and tax_id in
114: (select tax_id

Line 320: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

316: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
317: lv_action VARCHAR2(20);
318: lv_return_message VARCHAR2(2000);
319: lv_return_code VARCHAR2(100) ;
320: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
321: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
322: le_error EXCEPTION;
323:
324: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

Line 321: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

317: lv_action VARCHAR2(20);
318: lv_return_message VARCHAR2(2000);
319: lv_return_code VARCHAR2(100) ;
320: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
321: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
322: le_error EXCEPTION;
323:
324: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
325: SELECT *

Line 324: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

320: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
321: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
322: le_error EXCEPTION;
323:
324: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
325: SELECT *
326: FROM
327: JAI_AR_TRX_LINES
328: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 327: JAI_AR_TRX_LINES

323:
324: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
325: SELECT *
326: FROM
327: JAI_AR_TRX_LINES
328: WHERE customer_trx_line_id = pn_customer_trx_line_id;
329: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
330:
331:

Line 404: /*Update JAI_AR_TRX_LINES

400:
401:
402:
403: --Added by Qinglei for JAI Trigger Elimination 11-May-012 begin
404: /*Update JAI_AR_TRX_LINES
405: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
406: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;*/
407: FOR c_jai_ar_trx_lines_rec IN (SELECT customer_trx_line_id
408: FROM JAI_AR_TRX_LINES

Line 407: FOR c_jai_ar_trx_lines_rec IN (SELECT customer_trx_line_id

403: --Added by Qinglei for JAI Trigger Elimination 11-May-012 begin
404: /*Update JAI_AR_TRX_LINES
405: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
406: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;*/
407: FOR c_jai_ar_trx_lines_rec IN (SELECT customer_trx_line_id
408: FROM JAI_AR_TRX_LINES
409: WHERE customer_trx_id = pr_old.customer_trx_id)
410: LOOP
411: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);

Line 408: FROM JAI_AR_TRX_LINES

404: /*Update JAI_AR_TRX_LINES
405: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
406: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;*/
407: FOR c_jai_ar_trx_lines_rec IN (SELECT customer_trx_line_id
408: FROM JAI_AR_TRX_LINES
409: WHERE customer_trx_id = pr_old.customer_trx_id)
410: LOOP
411: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
412: FETCH c_jai_ar_trx_lines into t_jai_line_rec_old;

Line 411: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);

407: FOR c_jai_ar_trx_lines_rec IN (SELECT customer_trx_line_id
408: FROM JAI_AR_TRX_LINES
409: WHERE customer_trx_id = pr_old.customer_trx_id)
410: LOOP
411: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
412: FETCH c_jai_ar_trx_lines into t_jai_line_rec_old;
413: CLOSE c_jai_ar_trx_lines;
414:
415: Update JAI_AR_TRX_LINES

Line 412: FETCH c_jai_ar_trx_lines into t_jai_line_rec_old;

408: FROM JAI_AR_TRX_LINES
409: WHERE customer_trx_id = pr_old.customer_trx_id)
410: LOOP
411: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
412: FETCH c_jai_ar_trx_lines into t_jai_line_rec_old;
413: CLOSE c_jai_ar_trx_lines;
414:
415: Update JAI_AR_TRX_LINES
416: Set Customer_Trx_Id = pr_new.Customer_Trx_ID

Line 413: CLOSE c_jai_ar_trx_lines;

409: WHERE customer_trx_id = pr_old.customer_trx_id)
410: LOOP
411: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
412: FETCH c_jai_ar_trx_lines into t_jai_line_rec_old;
413: CLOSE c_jai_ar_trx_lines;
414:
415: Update JAI_AR_TRX_LINES
416: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
417: Where Customer_Trx_Line_ID = c_jai_ar_trx_lines_rec.customer_trx_line_id;

Line 415: Update JAI_AR_TRX_LINES

411: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
412: FETCH c_jai_ar_trx_lines into t_jai_line_rec_old;
413: CLOSE c_jai_ar_trx_lines;
414:
415: Update JAI_AR_TRX_LINES
416: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
417: Where Customer_Trx_Line_ID = c_jai_ar_trx_lines_rec.customer_trx_line_id;
418:
419: lv_action := jai_constants.UPDATING;

Line 417: Where Customer_Trx_Line_ID = c_jai_ar_trx_lines_rec.customer_trx_line_id;

413: CLOSE c_jai_ar_trx_lines;
414:
415: Update JAI_AR_TRX_LINES
416: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
417: Where Customer_Trx_Line_ID = c_jai_ar_trx_lines_rec.customer_trx_line_id;
418:
419: lv_action := jai_constants.UPDATING;
420:
421: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);

Line 421: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);

417: Where Customer_Trx_Line_ID = c_jai_ar_trx_lines_rec.customer_trx_line_id;
418:
419: lv_action := jai_constants.UPDATING;
420:
421: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
422: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
423: CLOSE c_jai_ar_trx_lines;
424:
425: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 422: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;

418:
419: lv_action := jai_constants.UPDATING;
420:
421: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
422: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
423: CLOSE c_jai_ar_trx_lines;
424:
425: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
426: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y'

Line 423: CLOSE c_jai_ar_trx_lines;

419: lv_action := jai_constants.UPDATING;
420:
421: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
422: FETCH c_jai_ar_trx_lines into t_jai_line_rec_new;
423: CLOSE c_jai_ar_trx_lines;
424:
425: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
426: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y'
427: ) AND

Line 721: FROM JAI_AR_TRX_LINES

717:
718: CURSOR line_cur IS
719: SELECT customer_trx_line_id, inventory_item_id, quantity,line_number,
720: excise_exempt_type, assessable_value
721: FROM JAI_AR_TRX_LINES
722: WHERE customer_trx_id = v_customer_trx_id
723: ORDER BY customer_trx_line_id;
724:
725: CURSOR matched_qty_cur (p_customer_trx_line_id NUMBER) IS

Line 846: JAI_AR_TRX_LINES jtl,

842:
843: CURSOR c_total_Excise_amt IS
844: SELECT nvl(sum(jrtl.func_tax_amount),0)
845: FROM JAI_AR_TRXS jtrx,
846: JAI_AR_TRX_LINES jtl,
847: JAI_AR_TRX_TAX_LINES jrtl,
848: JAI_CMN_TAXES_ALL jtc ,
849: JAI_INV_ITM_SETUPS jmtl
850: WHERE jrtl.tax_id = jtc.tax_id

Line 874: FROM JAI_AR_TRX_LINES

870: JAI_CMN_TAXES_ALL jtc
871: WHERE jtc.tax_id = jrctl.tax_id
872: AND link_to_cust_trx_line_id IN
873: (SELECT customer_trx_line_id
874: FROM JAI_AR_TRX_LINES
875: WHERE customer_trx_id = pr_new.customer_trx_id
876: )
877: AND upper(jtc.tax_type) IN (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
878:

Line 919: JAI_AR_TRX_LINES jctl,

915: regime_id ,
916: regime_code
917: FROM
918: JAI_AR_TRX_TAX_LINES jcttl,
919: JAI_AR_TRX_LINES jctl,
920: JAI_CMN_TAXES_ALL jtc ,
921: jai_regime_tax_types_v jrttv
922: WHERE
923: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND

Line 940: JAI_AR_TRX_LINES jctl,

936: SELECT
937: 1
938: FROM
939: JAI_AR_TRX_TAX_LINES jcttl,
940: JAI_AR_TRX_LINES jctl,
941: JAI_CMN_TAXES_ALL jtc
942: WHERE
943: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
944: jctl.customer_trx_id = pr_new.customer_trx_id AND

Line 988: JAI_AR_TRX_LINES

984: IS
985: SELECT
986: excise_invoice_no
987: FROM
988: JAI_AR_TRX_LINES
989: WHERE
990: customer_trx_id = pr_new.customer_trx_id ;
991:
992:

Line 1040: JAI_AR_TRX_LINES jctl,

1036: SELECT regime_id ,
1037: regime_code
1038: FROM
1039: JAI_AR_TRX_TAX_LINES jcttl,
1040: JAI_AR_TRX_LINES jctl,
1041: JAI_CMN_TAXES_ALL jtc ,
1042: jai_regime_tax_types_v jrttv
1043: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1044: AND jctl.customer_trx_id = pr_new.customer_trx_id

Line 1070: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

1066: --Added by Qinglei for JAI Trigger Elimination 11-May_2012 begin
1067: lv_action VARCHAR2(20);
1068: lv_return_message VARCHAR2(2000);
1069: lv_return_code VARCHAR2(100) ;
1070: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1071: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1072: le_error EXCEPTION;
1073:
1074: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

Line 1071: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

1067: lv_action VARCHAR2(20);
1068: lv_return_message VARCHAR2(2000);
1069: lv_return_code VARCHAR2(100) ;
1070: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1071: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1072: le_error EXCEPTION;
1073:
1074: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1075: SELECT *

Line 1074: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

1070: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1071: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1072: le_error EXCEPTION;
1073:
1074: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1075: SELECT *
1076: FROM
1077: JAI_AR_TRX_LINES
1078: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 1077: JAI_AR_TRX_LINES

1073:
1074: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1075: SELECT *
1076: FROM
1077: JAI_AR_TRX_LINES
1078: WHERE customer_trx_line_id = pn_customer_trx_line_id;
1079: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
1080:
1081: --Added by Zhiwei for JAI Trigger elimination begin

Line 1469: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);

1465: END IF;
1466:
1467: IF NVL(v_item_class,'~') not in ('OTIN') THEN
1468: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1469: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1470: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
1471: CLOSE c_jai_ar_trx_lines;
1472:
1473: UPDATE JAI_AR_TRX_LINES

Line 1470: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;

1466:
1467: IF NVL(v_item_class,'~') not in ('OTIN') THEN
1468: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1469: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1470: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
1471: CLOSE c_jai_ar_trx_lines;
1472:
1473: UPDATE JAI_AR_TRX_LINES
1474: SET EXCISE_INVOICE_NO = v_invoice_no ,

Line 1471: CLOSE c_jai_ar_trx_lines;

1467: IF NVL(v_item_class,'~') not in ('OTIN') THEN
1468: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1469: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1470: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
1471: CLOSE c_jai_ar_trx_lines;
1472:
1473: UPDATE JAI_AR_TRX_LINES
1474: SET EXCISE_INVOICE_NO = v_invoice_no ,
1475: EXCISE_INVOICE_DATE = SYSDATE

Line 1473: UPDATE JAI_AR_TRX_LINES

1469: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1470: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
1471: CLOSE c_jai_ar_trx_lines;
1472:
1473: UPDATE JAI_AR_TRX_LINES
1474: SET EXCISE_INVOICE_NO = v_invoice_no ,
1475: EXCISE_INVOICE_DATE = SYSDATE
1476: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND
1477: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND

Line 1482: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);

1478: CUSTOMER_TRX_ID = v_customer_trx_id;
1479:
1480: lv_action := jai_constants.UPDATING;
1481:
1482: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1483: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1484: CLOSE c_jai_ar_trx_lines;
1485:
1486: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 1483: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;

1479:
1480: lv_action := jai_constants.UPDATING;
1481:
1482: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1483: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1484: CLOSE c_jai_ar_trx_lines;
1485:
1486: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
1487: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y'

Line 1484: CLOSE c_jai_ar_trx_lines;

1480: lv_action := jai_constants.UPDATING;
1481:
1482: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1483: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1484: CLOSE c_jai_ar_trx_lines;
1485:
1486: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
1487: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y'
1488: ) AND

Line 1753: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);

1749: End ;
1750:
1751:
1752: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1753: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1754: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1755: CLOSE c_jai_ar_trx_lines;
1756:
1757: UPDATE JAI_AR_TRX_LINES

Line 1754: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;

1750:
1751:
1752: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1753: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1754: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1755: CLOSE c_jai_ar_trx_lines;
1756:
1757: UPDATE JAI_AR_TRX_LINES
1758: SET PAYMENT_REGISTER = v_excise_paid_register

Line 1755: CLOSE c_jai_ar_trx_lines;

1751:
1752: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1753: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1754: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1755: CLOSE c_jai_ar_trx_lines;
1756:
1757: UPDATE JAI_AR_TRX_LINES
1758: SET PAYMENT_REGISTER = v_excise_paid_register
1759: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND

Line 1757: UPDATE JAI_AR_TRX_LINES

1753: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1754: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1755: CLOSE c_jai_ar_trx_lines;
1756:
1757: UPDATE JAI_AR_TRX_LINES
1758: SET PAYMENT_REGISTER = v_excise_paid_register
1759: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND
1760: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND
1761: CUSTOMER_TRX_ID = v_customer_trx_id;

Line 1763: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);

1759: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND
1760: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND
1761: CUSTOMER_TRX_ID = v_customer_trx_id;
1762:
1763: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1764: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1765: CLOSE c_jai_ar_trx_lines;
1766:
1767: lv_action := jai_constants.UPDATING;

Line 1764: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;

1760: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND
1761: CUSTOMER_TRX_ID = v_customer_trx_id;
1762:
1763: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1764: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1765: CLOSE c_jai_ar_trx_lines;
1766:
1767: lv_action := jai_constants.UPDATING;
1768:

Line 1765: CLOSE c_jai_ar_trx_lines;

1761: CUSTOMER_TRX_ID = v_customer_trx_id;
1762:
1763: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1764: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1765: CLOSE c_jai_ar_trx_lines;
1766:
1767: lv_action := jai_constants.UPDATING;
1768:
1769: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 1897: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);

1893: return ;
1894: END;
1895:
1896: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1897: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1898: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
1899: CLOSE c_jai_ar_trx_lines;
1900:
1901: UPDATE JAI_AR_TRX_LINES

Line 1898: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;

1894: END;
1895:
1896: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1897: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1898: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
1899: CLOSE c_jai_ar_trx_lines;
1900:
1901: UPDATE JAI_AR_TRX_LINES
1902: SET PAYMENT_REGISTER = v_excise_paid_register

Line 1899: CLOSE c_jai_ar_trx_lines;

1895:
1896: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
1897: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1898: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
1899: CLOSE c_jai_ar_trx_lines;
1900:
1901: UPDATE JAI_AR_TRX_LINES
1902: SET PAYMENT_REGISTER = v_excise_paid_register
1903: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND

Line 1901: UPDATE JAI_AR_TRX_LINES

1897: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1898: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_old;
1899: CLOSE c_jai_ar_trx_lines;
1900:
1901: UPDATE JAI_AR_TRX_LINES
1902: SET PAYMENT_REGISTER = v_excise_paid_register
1903: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND
1904: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND
1905: CUSTOMER_TRX_ID = v_customer_trx_id;

Line 1907: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);

1903: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id AND
1904: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND
1905: CUSTOMER_TRX_ID = v_customer_trx_id;
1906:
1907: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1908: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1909: CLOSE c_jai_ar_trx_lines;
1910:
1911: lv_action := jai_constants.UPDATING;

Line 1908: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;

1904: INVENTORY_ITEM_ID = LINE_REC.inventory_item_id AND
1905: CUSTOMER_TRX_ID = v_customer_trx_id;
1906:
1907: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1908: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1909: CLOSE c_jai_ar_trx_lines;
1910:
1911: lv_action := jai_constants.UPDATING;
1912:

Line 1909: CLOSE c_jai_ar_trx_lines;

1905: CUSTOMER_TRX_ID = v_customer_trx_id;
1906:
1907: OPEN c_jai_ar_trx_lines(LINE_REC.customer_trx_line_id);
1908: FETCH c_jai_ar_trx_lines INTO t_jai_line_rec_new;
1909: CLOSE c_jai_ar_trx_lines;
1910:
1911: lv_action := jai_constants.UPDATING;
1912:
1913: IF ( ( ( t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 2228: JAI_AR_TRX_LINES jctl,

2224: SELECT regime_id ,
2225: regime_code
2226: FROM
2227: JAI_AR_TRX_TAX_LINES jcttl,
2228: JAI_AR_TRX_LINES jctl,
2229: JAI_CMN_TAXES_ALL jtc ,
2230: jai_regime_tax_types_v jrttv
2231: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2232: AND jctl.customer_trx_id = pr_new.customer_trx_id

Line 2260: JAI_AR_TRX_LINES jctl,

2256: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
2257: IS
2258: SELECT 1
2259: FROM JAI_AR_TRX_TAX_LINES jcttl,
2260: JAI_AR_TRX_LINES jctl,
2261: JAI_CMN_TAXES_ALL jtc
2262: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2263: AND jctl.customer_trx_id = pr_new.customer_trx_id
2264: AND jcttl.tax_id = jtc.tax_id

Line 2316: JAI_AR_TRX_LINES jctl ,

2312: jcttl.creation_date ,
2313: jtc.tax_type ,
2314: jcttl.tax_rate
2315: FROM
2316: JAI_AR_TRX_LINES jctl ,
2317: JAI_AR_TRX_TAX_LINES jcttl ,
2318: JAI_CMN_TAXES_ALL jtc ,
2319: (
2320: SELECT jrttv1.tax_type tax_type