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

Line 360: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

356: PROCEDURE POPULATE_COPIED_TRANSACTIONS(PR_NEW T_REC%TYPE,
357: PV_ACTION VARCHAR2,
358: PV_RETURN_CODE OUT NOCOPY VARCHAR2,
359: PV_RETURN_MESSAGE OUT NOCOPY VARCHAR2) IS
360: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
361: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
362: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
363: SELECT *
364: FROM jai_ar_trx_lines

Line 361: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

357: PV_ACTION VARCHAR2,
358: PV_RETURN_CODE OUT NOCOPY VARCHAR2,
359: PV_RETURN_MESSAGE OUT NOCOPY VARCHAR2) IS
360: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
361: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
362: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
363: SELECT *
364: FROM jai_ar_trx_lines
365: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 362: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

358: PV_RETURN_CODE OUT NOCOPY VARCHAR2,
359: PV_RETURN_MESSAGE OUT NOCOPY VARCHAR2) IS
360: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
361: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
362: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
363: SELECT *
364: FROM jai_ar_trx_lines
365: WHERE customer_trx_line_id = pn_customer_trx_line_id;
366: lv_action VARCHAR2(20);

Line 364: FROM jai_ar_trx_lines

360: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
361: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
362: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
363: SELECT *
364: FROM jai_ar_trx_lines
365: WHERE customer_trx_line_id = pn_customer_trx_line_id;
366: lv_action VARCHAR2(20);
367: lv_return_message VARCHAR2(2000);
368: lv_return_code VARCHAR2(100);

Line 447: FROM JAI_AR_TRX_LINES

443: gl_date,
444: tax_amount,
445: total_amount,
446: assessable_value
447: FROM JAI_AR_TRX_LINES
448: WHERE customer_trx_id = p_parent_header_id
449: ORDER BY customer_trx_line_id;
450:
451: CURSOR TAX_INFO_CUR(p_parent_line_id IN NUMBER) IS

Line 595: INSERT INTO JAI_AR_TRX_LINES

591: 'C');
592:
593: FOR rec in LINES_INFO_CUR(v_parent_header_id) LOOP
594:
595: INSERT INTO JAI_AR_TRX_LINES
596: (customer_trx_line_id,
597: line_number,
598: customer_trx_id,
599: description,

Line 636: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);

632: v_last_updated_by,
633: v_last_update_login,
634: v_service_type)
635: returning customer_trx_line_id into v_customer_trx_line_id;
636: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
637: FETCH c_jai_ar_trx_lines
638: INTO t_jai_line_rec_new;
639: CLOSE c_jai_ar_trx_lines;
640:

Line 637: FETCH c_jai_ar_trx_lines

633: v_last_update_login,
634: v_service_type)
635: returning customer_trx_line_id into v_customer_trx_line_id;
636: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
637: FETCH c_jai_ar_trx_lines
638: INTO t_jai_line_rec_new;
639: CLOSE c_jai_ar_trx_lines;
640:
641: lv_action := JAI_CONSTANTS.INSERTING;

Line 639: CLOSE c_jai_ar_trx_lines;

635: returning customer_trx_line_id into v_customer_trx_line_id;
636: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
637: FETCH c_jai_ar_trx_lines
638: INTO t_jai_line_rec_new;
639: CLOSE c_jai_ar_trx_lines;
640:
641: lv_action := JAI_CONSTANTS.INSERTING;
642: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER(pr_old => t_jai_line_rec_old,
643: pr_new => t_jai_line_rec_new,

Line 722: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);

718: END IF;
719:
720: END LOOP;
721:
722: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
723: FETCH c_jai_ar_trx_lines
724: INTO t_jai_line_rec_old;
725: CLOSE c_jai_ar_trx_lines;
726:

Line 723: FETCH c_jai_ar_trx_lines

719:
720: END LOOP;
721:
722: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
723: FETCH c_jai_ar_trx_lines
724: INTO t_jai_line_rec_old;
725: CLOSE c_jai_ar_trx_lines;
726:
727: UPDATE JAI_AR_TRX_LINES

Line 725: CLOSE c_jai_ar_trx_lines;

721:
722: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
723: FETCH c_jai_ar_trx_lines
724: INTO t_jai_line_rec_old;
725: CLOSE c_jai_ar_trx_lines;
726:
727: UPDATE JAI_AR_TRX_LINES
728: SET tax_amount = v_line_tax_amount,
729: total_amount = nvl(line_amount, 0) + v_line_tax_amount

Line 727: UPDATE JAI_AR_TRX_LINES

723: FETCH c_jai_ar_trx_lines
724: INTO t_jai_line_rec_old;
725: CLOSE c_jai_ar_trx_lines;
726:
727: UPDATE JAI_AR_TRX_LINES
728: SET tax_amount = v_line_tax_amount,
729: total_amount = nvl(line_amount, 0) + v_line_tax_amount
730: WHERE customer_trx_line_id = v_customer_trx_line_id;
731:

Line 732: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);

728: SET tax_amount = v_line_tax_amount,
729: total_amount = nvl(line_amount, 0) + v_line_tax_amount
730: WHERE customer_trx_line_id = v_customer_trx_line_id;
731:
732: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
733: FETCH c_jai_ar_trx_lines
734: INTO t_jai_line_rec_new;
735: CLOSE c_jai_ar_trx_lines;
736: lv_action := JAI_CONSTANTS.UPDATING;

Line 733: FETCH c_jai_ar_trx_lines

729: total_amount = nvl(line_amount, 0) + v_line_tax_amount
730: WHERE customer_trx_line_id = v_customer_trx_line_id;
731:
732: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
733: FETCH c_jai_ar_trx_lines
734: INTO t_jai_line_rec_new;
735: CLOSE c_jai_ar_trx_lines;
736: lv_action := JAI_CONSTANTS.UPDATING;
737: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 735: CLOSE c_jai_ar_trx_lines;

731:
732: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
733: FETCH c_jai_ar_trx_lines
734: INTO t_jai_line_rec_new;
735: CLOSE c_jai_ar_trx_lines;
736: lv_action := JAI_CONSTANTS.UPDATING;
737: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
738: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
739: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND

Line 802: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

798:
799: v_currency_code gl_sets_of_books.currency_code%type;
800: lv_api_name CONSTANT VARCHAR2(200) := 'UPDATE_TRX_NUMBER';
801: lv_debug_info VARCHAR2(4000);
802: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
803: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
804: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
805: SELECT *
806: FROM jai_ar_trx_lines

Line 803: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

799: v_currency_code gl_sets_of_books.currency_code%type;
800: lv_api_name CONSTANT VARCHAR2(200) := 'UPDATE_TRX_NUMBER';
801: lv_debug_info VARCHAR2(4000);
802: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
803: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
804: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
805: SELECT *
806: FROM jai_ar_trx_lines
807: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 804: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

800: lv_api_name CONSTANT VARCHAR2(200) := 'UPDATE_TRX_NUMBER';
801: lv_debug_info VARCHAR2(4000);
802: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
803: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
804: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
805: SELECT *
806: FROM jai_ar_trx_lines
807: WHERE customer_trx_line_id = pn_customer_trx_line_id;
808: lv_action VARCHAR2(20);

Line 806: FROM jai_ar_trx_lines

802: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
803: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
804: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
805: SELECT *
806: FROM jai_ar_trx_lines
807: WHERE customer_trx_line_id = pn_customer_trx_line_id;
808: lv_action VARCHAR2(20);
809: lv_return_message VARCHAR2(2000);
810: lv_return_code VARCHAR2(100);

Line 828: FOR c_jai_ar_trx_lines_rec IN (SELECT customer_trx_line_id

824: Update JAI_AR_TRXS
825: Set Customer_Trx_ID = pr_new.Customer_Trx_ID
826: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;
827:
828: FOR c_jai_ar_trx_lines_rec IN (SELECT customer_trx_line_id
829: FROM JAI_AR_TRX_LINES
830: WHERE customer_trx_id =
831: pr_old.customer_trx_id) LOOP
832:

Line 829: FROM JAI_AR_TRX_LINES

825: Set Customer_Trx_ID = pr_new.Customer_Trx_ID
826: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;
827:
828: FOR c_jai_ar_trx_lines_rec IN (SELECT customer_trx_line_id
829: FROM JAI_AR_TRX_LINES
830: WHERE customer_trx_id =
831: pr_old.customer_trx_id) LOOP
832:
833: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);

Line 833: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);

829: FROM JAI_AR_TRX_LINES
830: WHERE customer_trx_id =
831: pr_old.customer_trx_id) LOOP
832:
833: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
834: FETCH c_jai_ar_trx_lines
835: INTO t_jai_line_rec_old;
836: CLOSE c_jai_ar_trx_lines;
837:

Line 834: FETCH c_jai_ar_trx_lines

830: WHERE customer_trx_id =
831: pr_old.customer_trx_id) LOOP
832:
833: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
834: FETCH c_jai_ar_trx_lines
835: INTO t_jai_line_rec_old;
836: CLOSE c_jai_ar_trx_lines;
837:
838: Update JAI_AR_TRX_LINES

Line 836: CLOSE c_jai_ar_trx_lines;

832:
833: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
834: FETCH c_jai_ar_trx_lines
835: INTO t_jai_line_rec_old;
836: CLOSE c_jai_ar_trx_lines;
837:
838: Update JAI_AR_TRX_LINES
839: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
840: Where Customer_Trx_ID = pr_old.Customer_Trx_ID

Line 838: Update JAI_AR_TRX_LINES

834: FETCH c_jai_ar_trx_lines
835: INTO t_jai_line_rec_old;
836: CLOSE c_jai_ar_trx_lines;
837:
838: Update JAI_AR_TRX_LINES
839: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
840: Where Customer_Trx_ID = pr_old.Customer_Trx_ID
841: AND customer_trx_line_id =
842: c_jai_ar_trx_lines_rec.customer_trx_line_id;

Line 842: c_jai_ar_trx_lines_rec.customer_trx_line_id;

838: Update JAI_AR_TRX_LINES
839: Set Customer_Trx_Id = pr_new.Customer_Trx_ID
840: Where Customer_Trx_ID = pr_old.Customer_Trx_ID
841: AND customer_trx_line_id =
842: c_jai_ar_trx_lines_rec.customer_trx_line_id;
843:
844: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
845: FETCH c_jai_ar_trx_lines
846: INTO t_jai_line_rec_new;

Line 844: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);

840: Where Customer_Trx_ID = pr_old.Customer_Trx_ID
841: AND customer_trx_line_id =
842: c_jai_ar_trx_lines_rec.customer_trx_line_id;
843:
844: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
845: FETCH c_jai_ar_trx_lines
846: INTO t_jai_line_rec_new;
847: CLOSE c_jai_ar_trx_lines;
848: lv_action := JAI_CONSTANTS.UPDATING;

Line 845: FETCH c_jai_ar_trx_lines

841: AND customer_trx_line_id =
842: c_jai_ar_trx_lines_rec.customer_trx_line_id;
843:
844: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
845: FETCH c_jai_ar_trx_lines
846: INTO t_jai_line_rec_new;
847: CLOSE c_jai_ar_trx_lines;
848: lv_action := JAI_CONSTANTS.UPDATING;
849: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 847: CLOSE c_jai_ar_trx_lines;

843:
844: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
845: FETCH c_jai_ar_trx_lines
846: INTO t_jai_line_rec_new;
847: CLOSE c_jai_ar_trx_lines;
848: lv_action := JAI_CONSTANTS.UPDATING;
849: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
850: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
851: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND

Line 916: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

912: pv_return_code out NOCOPY varchar2,
913: pv_return_message out NOCOPY varchar2) IS
914: lv_api_name CONSTANT VARCHAR2(200) := 'RECALCULATE_TAX';
915: lv_debug_info VARCHAR2(4000);
916: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
917: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
918: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
919: SELECT *
920: FROM jai_ar_trx_lines

Line 917: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

913: pv_return_message out NOCOPY varchar2) IS
914: lv_api_name CONSTANT VARCHAR2(200) := 'RECALCULATE_TAX';
915: lv_debug_info VARCHAR2(4000);
916: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
917: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
918: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
919: SELECT *
920: FROM jai_ar_trx_lines
921: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 918: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

914: lv_api_name CONSTANT VARCHAR2(200) := 'RECALCULATE_TAX';
915: lv_debug_info VARCHAR2(4000);
916: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
917: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
918: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
919: SELECT *
920: FROM jai_ar_trx_lines
921: WHERE customer_trx_line_id = pn_customer_trx_line_id;
922: lv_action VARCHAR2(20);

Line 920: FROM jai_ar_trx_lines

916: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
917: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
918: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
919: SELECT *
920: FROM jai_ar_trx_lines
921: WHERE customer_trx_line_id = pn_customer_trx_line_id;
922: lv_action VARCHAR2(20);
923: lv_return_message VARCHAR2(2000);
924: lv_return_code VARCHAR2(100);

Line 1005: From JAI_AR_TRX_LINES

1001: Unit_Code,
1002: Line_Amount,
1003: Quantity,
1004: unit_selling_price
1005: From JAI_AR_TRX_LINES
1006: Where Customer_Trx_ID = v_header_id;
1007:
1008: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
1009:

Line 1008: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;

1004: unit_selling_price
1005: From JAI_AR_TRX_LINES
1006: Where Customer_Trx_ID = v_header_id;
1007:
1008: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
1009:
1010: LN_TCS_EXISTS NUMBER;
1011: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1012: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;

Line 1277: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);

1273:
1274: v_service_type := JAI_AR_RCTLA_TRIGGER_PKG.get_service_type(v_customer_id,
1275: v_ship_to_site_use_id,
1276: 'C');
1277: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);
1278: FETCH c_jai_ar_trx_lines
1279: INTO t_jai_line_rec_old;
1280: CLOSE c_jai_ar_trx_lines;
1281:

Line 1278: FETCH c_jai_ar_trx_lines

1274: v_service_type := JAI_AR_RCTLA_TRIGGER_PKG.get_service_type(v_customer_id,
1275: v_ship_to_site_use_id,
1276: 'C');
1277: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);
1278: FETCH c_jai_ar_trx_lines
1279: INTO t_jai_line_rec_old;
1280: CLOSE c_jai_ar_trx_lines;
1281:
1282: UPDATE JAI_AR_TRX_LINES

Line 1280: CLOSE c_jai_ar_trx_lines;

1276: 'C');
1277: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);
1278: FETCH c_jai_ar_trx_lines
1279: INTO t_jai_line_rec_old;
1280: CLOSE c_jai_ar_trx_lines;
1281:
1282: UPDATE JAI_AR_TRX_LINES
1283: SET tax_category_id = v_tax_category_id,
1284: service_type_code = v_service_type,

Line 1282: UPDATE JAI_AR_TRX_LINES

1278: FETCH c_jai_ar_trx_lines
1279: INTO t_jai_line_rec_old;
1280: CLOSE c_jai_ar_trx_lines;
1281:
1282: UPDATE JAI_AR_TRX_LINES
1283: SET tax_category_id = v_tax_category_id,
1284: service_type_code = v_service_type,
1285: assessable_value = nvl(v_price_list, 0),
1286: vat_assessable_value = ln_vat_assessable_value,

Line 1295: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);

1291: last_updated_by = v_last_updated_by,
1292: last_update_login = v_last_update_login
1293: WHERE Customer_Trx_Line_ID = rec.customer_trx_line_id;
1294:
1295: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);
1296: FETCH c_jai_ar_trx_lines
1297: INTO t_jai_line_rec_new;
1298: CLOSE c_jai_ar_trx_lines;
1299: lv_action := JAI_CONSTANTS.UPDATING;

Line 1296: FETCH c_jai_ar_trx_lines

1292: last_update_login = v_last_update_login
1293: WHERE Customer_Trx_Line_ID = rec.customer_trx_line_id;
1294:
1295: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);
1296: FETCH c_jai_ar_trx_lines
1297: INTO t_jai_line_rec_new;
1298: CLOSE c_jai_ar_trx_lines;
1299: lv_action := JAI_CONSTANTS.UPDATING;
1300: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 1298: CLOSE c_jai_ar_trx_lines;

1294:
1295: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);
1296: FETCH c_jai_ar_trx_lines
1297: INTO t_jai_line_rec_new;
1298: CLOSE c_jai_ar_trx_lines;
1299: lv_action := JAI_CONSTANTS.UPDATING;
1300: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
1301: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
1302: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND

Line 1394: from JAI_AR_TRX_LINES

1390: select 1
1391: from JAI_AR_TRX_TAX_LINES
1392: where link_to_cust_trx_line_id in
1393: (select customer_trx_line_id
1394: from JAI_AR_TRX_LINES
1395: where customer_trx_id = pr_new.customer_trx_id)
1396: and tax_id in (select tax_id
1397: from JAI_CMN_TAXES_ALL
1398: where vat_flag = 'Y'

Line 1594: JAI_AR_TRX_LINES jctl,

1590:
1591: CURSOR cur_vat_taxes_exist IS
1592: SELECT regime_id, regime_code
1593: FROM JAI_AR_TRX_TAX_LINES jcttl,
1594: JAI_AR_TRX_LINES jctl,
1595: JAI_CMN_TAXES_ALL jtc,
1596: jai_regime_tax_types_v jrttv
1597: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1598: AND jctl.customer_trx_id = pr_new.customer_trx_id

Line 1619: JAI_AR_TRX_LINES jctl,

1615:
1616: CURSOR c_chk_vat_reversal(cp_tax_type jai_cmn_taxes_all.tax_type%TYPE) IS
1617: SELECT 1
1618: FROM JAI_AR_TRX_TAX_LINES jcttl,
1619: JAI_AR_TRX_LINES jctl,
1620: JAI_CMN_TAXES_ALL jtc
1621: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1622: AND jctl.customer_trx_id = pr_new.customer_trx_id
1623: AND jcttl.tax_id = jtc.tax_id

Line 1944: FROM JAI_AR_TRX_LINES

1940: quantity,
1941: line_number,
1942: excise_exempt_type,
1943: assessable_value
1944: FROM JAI_AR_TRX_LINES
1945: WHERE customer_trx_id = v_customer_trx_id
1946: ORDER BY customer_trx_line_id;
1947:
1948: CURSOR matched_qty_cur(p_customer_trx_line_id NUMBER) IS

Line 2068: JAI_AR_TRX_LINES jtl,

2064:
2065: CURSOR c_total_Excise_amt IS
2066: SELECT nvl(sum(jrtl.func_tax_amount), 0)
2067: FROM JAI_AR_TRXS jtrx,
2068: JAI_AR_TRX_LINES jtl,
2069: JAI_AR_TRX_TAX_LINES jrtl,
2070: JAI_CMN_TAXES_ALL jtc,
2071: JAI_INV_ITM_SETUPS jmtl
2072: WHERE jrtl.tax_id = jtc.tax_id

Line 2098: FROM JAI_AR_TRX_LINES

2094: FROM JAI_AR_TRX_TAX_LINES jrctl, JAI_CMN_TAXES_ALL jtc
2095: WHERE jtc.tax_id = jrctl.tax_id
2096: AND link_to_cust_trx_line_id IN
2097: (SELECT customer_trx_line_id
2098: FROM JAI_AR_TRX_LINES
2099: WHERE customer_trx_id = pr_new.customer_trx_id)
2100: AND upper(jtc.tax_type) IN
2101: (upper(jai_constants.tax_type_cvd_edu_cess),
2102: upper(jai_constants.tax_type_exc_edu_cess));

Line 2131: JAI_AR_TRX_LINES jctl,

2127:
2128: CURSOR cur_vat_taxes_exist IS
2129: SELECT regime_id, regime_code
2130: FROM JAI_AR_TRX_TAX_LINES jcttl,
2131: JAI_AR_TRX_LINES jctl,
2132: JAI_CMN_TAXES_ALL jtc,
2133: jai_regime_tax_types_v jrttv
2134: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2135: AND jctl.customer_trx_id = pr_new.customer_trx_id

Line 2144: JAI_AR_TRX_LINES jctl,

2140:
2141: CURSOR c_chk_vat_reversal(cp_tax_type jai_cmn_taxes_all.tax_type%TYPE) IS
2142: SELECT 1
2143: FROM JAI_AR_TRX_TAX_LINES jcttl,
2144: JAI_AR_TRX_LINES jctl,
2145: JAI_CMN_TAXES_ALL jtc
2146: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2147: AND jctl.customer_trx_id = pr_new.customer_trx_id
2148: AND jcttl.tax_id = jtc.tax_id

Line 2173: FROM JAI_AR_TRX_LINES

2169: AND location_id = cp_location_id;
2170:
2171: CURSOR cur_get_exc_inv_no IS
2172: SELECT excise_invoice_no
2173: FROM JAI_AR_TRX_LINES
2174: WHERE customer_trx_id = pr_new.customer_trx_id;
2175:
2176: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type) IS
2177: SELECT gl_date

Line 2611: UPDATE JAI_AR_TRX_LINES

2607: END IF;
2608:
2609: IF NVL(v_item_class, '~') not in ('OTIN') THEN
2610:
2611: UPDATE JAI_AR_TRX_LINES
2612: SET EXCISE_INVOICE_NO = v_invoice_no,
2613: EXCISE_INVOICE_DATE = SYSDATE
2614: WHERE CUSTOMER_TRX_LINE_ID = LINE_REC.customer_trx_line_id
2615: AND INVENTORY_ITEM_ID = LINE_REC.inventory_item_id

Line 2904: UPDATE JAI_AR_TRX_LINES

2900: pv_return_message := SQLERRM;
2901: return;
2902: End;
2903:
2904: UPDATE JAI_AR_TRX_LINES
2905: SET PAYMENT_REGISTER = v_excise_paid_register
2906: WHERE CUSTOMER_TRX_LINE_ID =
2907: LINE_REC.customer_trx_line_id
2908: AND INVENTORY_ITEM_ID = LINE_REC.inventory_item_id

Line 3035: UPDATE JAI_AR_TRX_LINES

3031: pv_return_message := SQLERRM;
3032: return;
3033: END;
3034:
3035: UPDATE JAI_AR_TRX_LINES
3036: SET PAYMENT_REGISTER = v_excise_paid_register
3037: WHERE CUSTOMER_TRX_LINE_ID =
3038: LINE_REC.customer_trx_line_id
3039: AND INVENTORY_ITEM_ID = LINE_REC.inventory_item_id