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

Line 1: PACKAGE BODY JAI_AR_TRX_LINES_PKG AS

1: PACKAGE BODY JAI_AR_TRX_LINES_PKG AS
2: /* $Header: jai_ar_trx_lines.plb 120.0.12020000.2 2013/03/19 00:29:08 vkaranam noship $ */
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: ------------------------------------------------------------------------------------------------------------

Line 2: /* $Header: jai_ar_trx_lines.plb 120.0.12020000.2 2013/03/19 00:29:08 vkaranam noship $ */

1: PACKAGE BODY JAI_AR_TRX_LINES_PKG AS
2: /* $Header: jai_ar_trx_lines.plb 120.0.12020000.2 2013/03/19 00:29:08 vkaranam noship $ */
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: ------------------------------------------------------------------------------------------------------------
6: Sl.No. Date Developer BugNo Version Remarks

Line 19: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TRX_LINES_PKG.';

15: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TRX_LINES_PKG.';
20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_LINES_PKG';
21:
22: PROCEDURE POPULATE_JAI_AR_LINES(pr_new t_rec%TYPE,
23: pv_action VARCHAR2,

Line 20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_LINES_PKG';

16: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
17: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
18: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
19: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_AR_TRX_LINES_PKG.';
20: G_PACKAGE_NAME CONSTANT VARCHAR2(100) := 'JAI_AR_TRX_LINES_PKG';
21:
22: PROCEDURE POPULATE_JAI_AR_LINES(pr_new t_rec%TYPE,
23: pv_action VARCHAR2,
24: pv_return_code OUT NOCOPY VARCHAR2,

Line 28: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

24: pv_return_code OUT NOCOPY VARCHAR2,
25: pv_return_message OUT NOCOPY VARCHAR2) IS
26: lv_api_name CONSTANT VARCHAR2(100) := 'POPULATE_JAI_AR_LINES';
27: lv_debug_info VARCHAR2(4000);
28: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
29: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
30: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
31: SELECT *
32: FROM jai_ar_trx_lines

Line 29: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

25: pv_return_message OUT NOCOPY VARCHAR2) IS
26: lv_api_name CONSTANT VARCHAR2(100) := 'POPULATE_JAI_AR_LINES';
27: lv_debug_info VARCHAR2(4000);
28: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
29: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
30: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
31: SELECT *
32: FROM jai_ar_trx_lines
33: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 30: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

26: lv_api_name CONSTANT VARCHAR2(100) := 'POPULATE_JAI_AR_LINES';
27: lv_debug_info VARCHAR2(4000);
28: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
29: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
30: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
31: SELECT *
32: FROM jai_ar_trx_lines
33: WHERE customer_trx_line_id = pn_customer_trx_line_id;
34: lv_action VARCHAR2(20);

Line 32: FROM jai_ar_trx_lines

28: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
29: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
30: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
31: SELECT *
32: FROM jai_ar_trx_lines
33: WHERE customer_trx_line_id = pn_customer_trx_line_id;
34: lv_action VARCHAR2(20);
35: lv_return_message VARCHAR2(2000);
36: lv_return_code VARCHAR2(100);

Line 86: FROM JAI_AR_TRX_LINES

82: WHERE CUSTOMER_TRX_LINE_ID = v_prev_customer_trx_line_id;
83:
84: CURSOR localization_line_info IS
85: SELECT assessable_value, tax_category_id, service_type_code
86: FROM JAI_AR_TRX_LINES
87: WHERE customer_trx_line_id = v_prev_customer_trx_line_id;
88:
89: CURSOR localization_tax_info IS
90: SELECT a.tax_id,

Line 214: INSERT INTO JAI_AR_TRX_LINES

210: Fetch localization_line_info
211: into v_tax_category_id, v_price_list, lv_service_type_code;
212: Close localization_line_info;
213:
214: INSERT INTO JAI_AR_TRX_LINES
215: (customer_trx_line_id,
216: line_number,
217: customer_trx_id,
218: description,

Line 259: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);

255: v_last_updated_by,
256: v_last_update_login,
257: lv_service_type_code);
258:
259: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
260: FETCH c_jai_ar_trx_lines
261: INTO t_jai_line_rec_new;
262: CLOSE c_jai_ar_trx_lines;
263:

Line 260: FETCH c_jai_ar_trx_lines

256: v_last_update_login,
257: lv_service_type_code);
258:
259: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
260: FETCH c_jai_ar_trx_lines
261: INTO t_jai_line_rec_new;
262: CLOSE c_jai_ar_trx_lines;
263:
264: lv_action := JAI_CONSTANTS.INSERTING;

Line 262: CLOSE c_jai_ar_trx_lines;

258:
259: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
260: FETCH c_jai_ar_trx_lines
261: INTO t_jai_line_rec_new;
262: CLOSE c_jai_ar_trx_lines;
263:
264: lv_action := JAI_CONSTANTS.INSERTING;
265: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER(pr_old => t_jai_line_rec_old,
266: pr_new => t_jai_line_rec_new,

Line 342: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);

338: nvl(pr_new.extended_amount, 0)
339: Where Customer_Trx_Id = v_header_id;
340: END IF;
341:
342: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);
343: FETCH c_jai_ar_trx_lines
344: INTO t_jai_line_rec_old;
345: CLOSE c_jai_ar_trx_lines;
346:

Line 343: FETCH c_jai_ar_trx_lines

339: Where Customer_Trx_Id = v_header_id;
340: END IF;
341:
342: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);
343: FETCH c_jai_ar_trx_lines
344: INTO t_jai_line_rec_old;
345: CLOSE c_jai_ar_trx_lines;
346:
347: Update JAI_AR_TRX_LINES

Line 345: CLOSE c_jai_ar_trx_lines;

341:
342: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);
343: FETCH c_jai_ar_trx_lines
344: INTO t_jai_line_rec_old;
345: CLOSE c_jai_ar_trx_lines;
346:
347: Update JAI_AR_TRX_LINES
348: Set total_amount = nvl(total_amount, 0) +
349: nvl(pr_new.extended_amount, 0),

Line 347: Update JAI_AR_TRX_LINES

343: FETCH c_jai_ar_trx_lines
344: INTO t_jai_line_rec_old;
345: CLOSE c_jai_ar_trx_lines;
346:
347: Update JAI_AR_TRX_LINES
348: Set total_amount = nvl(total_amount, 0) +
349: nvl(pr_new.extended_amount, 0),
350: tax_amount = nvl(tax_amount, 0) +
351: nvl(pr_new.extended_amount, 0)

Line 355: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);

351: nvl(pr_new.extended_amount, 0)
352: Where Customer_Trx_Id = v_header_id
353: and Customer_Trx_Line_Id = v_link_to_cust_id;
354:
355: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);
356: FETCH c_jai_ar_trx_lines
357: INTO t_jai_line_rec_new;
358: CLOSE c_jai_ar_trx_lines;
359: lv_action := JAI_CONSTANTS.UPDATING;

Line 356: FETCH c_jai_ar_trx_lines

352: Where Customer_Trx_Id = v_header_id
353: and Customer_Trx_Line_Id = v_link_to_cust_id;
354:
355: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);
356: FETCH c_jai_ar_trx_lines
357: INTO t_jai_line_rec_new;
358: CLOSE c_jai_ar_trx_lines;
359: lv_action := JAI_CONSTANTS.UPDATING;
360: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 358: CLOSE c_jai_ar_trx_lines;

354:
355: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);
356: FETCH c_jai_ar_trx_lines
357: INTO t_jai_line_rec_new;
358: CLOSE c_jai_ar_trx_lines;
359: lv_action := JAI_CONSTANTS.UPDATING;
360: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
361: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
362: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND

Line 406: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

402: pv_return_code OUT NOCOPY VARCHAR2,
403: pv_return_message OUT NOCOPY VARCHAR2) IS
404: lv_api_name CONSTANT VARCHAR2(100) := 'DEFAULT_TAX';
405: lv_debug_info VARCHAR2(4000);
406: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
407: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
408: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
409: SELECT *
410: FROM jai_ar_trx_lines

Line 407: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

403: pv_return_message OUT NOCOPY VARCHAR2) IS
404: lv_api_name CONSTANT VARCHAR2(100) := 'DEFAULT_TAX';
405: lv_debug_info VARCHAR2(4000);
406: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
407: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
408: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
409: SELECT *
410: FROM jai_ar_trx_lines
411: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 408: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

404: lv_api_name CONSTANT VARCHAR2(100) := 'DEFAULT_TAX';
405: lv_debug_info VARCHAR2(4000);
406: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
407: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
408: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
409: SELECT *
410: FROM jai_ar_trx_lines
411: WHERE customer_trx_line_id = pn_customer_trx_line_id;
412: lv_action VARCHAR2(20);

Line 410: FROM jai_ar_trx_lines

406: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
407: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
408: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
409: SELECT *
410: FROM jai_ar_trx_lines
411: WHERE customer_trx_line_id = pn_customer_trx_line_id;
412: lv_action VARCHAR2(20);
413: lv_return_message VARCHAR2(2000);
414: lv_return_code VARCHAR2(100);

Line 570: FROM JAI_AR_TRX_LINES

566: WHERE customer_trx_id = v_header_id;
567:
568: CURSOR old_line_amount_cur IS
569: SELECT line_amount
570: FROM JAI_AR_TRX_LINES
571: WHERE CUSTOMER_TRX_ID = pr_old.CUSTOMER_TRX_ID
572: AND CUSTOMER_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
573:
574: CURSOR gl_date_cur IS

Line 586: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;

582: Where a.cust_trx_type_id = b.cust_trx_type_id
583: And b.customer_trx_id = v_header_id
584: And NVL(a.org_id, 0) = NVL(pr_new.org_id, 0);
585:
586: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
587: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
588: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type;
589: BEGIN
590: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 696: DELETE JAI_AR_TRX_LINES

692:
693: DELETE JAI_AR_TRX_TAX_LINES
694: WHERE LINK_TO_CUST_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
695:
696: DELETE JAI_AR_TRX_LINES
697: WHERE CUSTOMER_TRX_ID = pr_old.CUSTOMER_TRX_ID
698: AND CUSTOMER_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
699: END IF;
700:

Line 893: INSERT INTO JAI_AR_TRX_LINES

889: Open Gl_Date_Cur;
890: Fetch Gl_Date_Cur
891: Into v_gl_date;
892: Close Gl_Date_Cur;
893: INSERT INTO JAI_AR_TRX_LINES
894: (customer_trx_line_id,
895: line_number,
896: customer_trx_id,
897: description,

Line 940: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);

936: v_last_update_login,
937: ln_vat_assessable_value,
938: v_service_type);
939:
940: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
941: FETCH c_jai_ar_trx_lines
942: INTO t_jai_line_rec_new;
943: CLOSE c_jai_ar_trx_lines;
944:

Line 941: FETCH c_jai_ar_trx_lines

937: ln_vat_assessable_value,
938: v_service_type);
939:
940: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
941: FETCH c_jai_ar_trx_lines
942: INTO t_jai_line_rec_new;
943: CLOSE c_jai_ar_trx_lines;
944:
945: lv_action := JAI_CONSTANTS.INSERTING;

Line 943: CLOSE c_jai_ar_trx_lines;

939:
940: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
941: FETCH c_jai_ar_trx_lines
942: INTO t_jai_line_rec_new;
943: CLOSE c_jai_ar_trx_lines;
944:
945: lv_action := JAI_CONSTANTS.INSERTING;
946: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER(pr_old => t_jai_line_rec_old,
947: pr_new => t_jai_line_rec_new,

Line 1060: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

1056: pv_return_code out NOCOPY varchar2,
1057: pv_return_message out NOCOPY varchar2) IS
1058: lv_api_name CONSTANT VARCHAR2(100) := 'RECALCULATE_TAX_FOR_DM';
1059: lv_debug_info VARCHAR2(4000);
1060: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1061: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1062: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1063: SELECT *
1064: FROM jai_ar_trx_lines

Line 1061: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

1057: pv_return_message out NOCOPY varchar2) IS
1058: lv_api_name CONSTANT VARCHAR2(100) := 'RECALCULATE_TAX_FOR_DM';
1059: lv_debug_info VARCHAR2(4000);
1060: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1061: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1062: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1063: SELECT *
1064: FROM jai_ar_trx_lines
1065: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 1062: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

1058: lv_api_name CONSTANT VARCHAR2(100) := 'RECALCULATE_TAX_FOR_DM';
1059: lv_debug_info VARCHAR2(4000);
1060: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1061: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1062: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1063: SELECT *
1064: FROM jai_ar_trx_lines
1065: WHERE customer_trx_line_id = pn_customer_trx_line_id;
1066: lv_action VARCHAR2(20);

Line 1064: FROM jai_ar_trx_lines

1060: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1061: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1062: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1063: SELECT *
1064: FROM jai_ar_trx_lines
1065: WHERE customer_trx_line_id = pn_customer_trx_line_id;
1066: lv_action VARCHAR2(20);
1067: lv_return_message VARCHAR2(2000);
1068: lv_return_code VARCHAR2(100);

Line 1316: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);

1312: last_updated_by = v_last_updated_by,
1313: last_update_login = v_last_update_login
1314: WHERE customer_trx_id = v_header_id;
1315:
1316: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1317: FETCH c_jai_ar_trx_lines
1318: INTO t_jai_line_rec_old;
1319: CLOSE c_jai_ar_trx_lines;
1320:

Line 1317: FETCH c_jai_ar_trx_lines

1313: last_update_login = v_last_update_login
1314: WHERE customer_trx_id = v_header_id;
1315:
1316: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1317: FETCH c_jai_ar_trx_lines
1318: INTO t_jai_line_rec_old;
1319: CLOSE c_jai_ar_trx_lines;
1320:
1321: UPDATE JAI_AR_TRX_LINES

Line 1319: CLOSE c_jai_ar_trx_lines;

1315:
1316: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1317: FETCH c_jai_ar_trx_lines
1318: INTO t_jai_line_rec_old;
1319: CLOSE c_jai_ar_trx_lines;
1320:
1321: UPDATE JAI_AR_TRX_LINES
1322: SET description = pr_new.description,
1323: inventory_item_id = pr_new.inventory_item_id,

Line 1321: UPDATE JAI_AR_TRX_LINES

1317: FETCH c_jai_ar_trx_lines
1318: INTO t_jai_line_rec_old;
1319: CLOSE c_jai_ar_trx_lines;
1320:
1321: UPDATE JAI_AR_TRX_LINES
1322: SET description = pr_new.description,
1323: inventory_item_id = pr_new.inventory_item_id,
1324: unit_code = pr_new.uom_code,
1325: quantity = pr_new.quantity_credited,

Line 1340: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);

1336: last_update_login = v_last_update_login
1337: WHERE customer_trx_line_id = pr_old.customer_trx_line_id
1338: AND customer_trx_id = v_header_id;
1339:
1340: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1341: FETCH c_jai_ar_trx_lines
1342: INTO t_jai_line_rec_new;
1343: CLOSE c_jai_ar_trx_lines;
1344: lv_action := JAI_CONSTANTS.UPDATING;

Line 1341: FETCH c_jai_ar_trx_lines

1337: WHERE customer_trx_line_id = pr_old.customer_trx_line_id
1338: AND customer_trx_id = v_header_id;
1339:
1340: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1341: FETCH c_jai_ar_trx_lines
1342: INTO t_jai_line_rec_new;
1343: CLOSE c_jai_ar_trx_lines;
1344: lv_action := JAI_CONSTANTS.UPDATING;
1345: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 1343: CLOSE c_jai_ar_trx_lines;

1339:
1340: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1341: FETCH c_jai_ar_trx_lines
1342: INTO t_jai_line_rec_new;
1343: CLOSE c_jai_ar_trx_lines;
1344: lv_action := JAI_CONSTANTS.UPDATING;
1345: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
1346: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
1347: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND

Line 1381: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

1377: pv_return_code out NOCOPY varchar2,
1378: pv_return_message out NOCOPY varchar2) IS
1379: lv_api_name CONSTANT VARCHAR2(100) := 'RECALCULATE_TAX_FOR_INV_CM';
1380: lv_debug_info VARCHAR2(4000);
1381: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1382: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1383: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1384: SELECT *
1385: FROM jai_ar_trx_lines

Line 1382: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;

1378: pv_return_message out NOCOPY varchar2) IS
1379: lv_api_name CONSTANT VARCHAR2(100) := 'RECALCULATE_TAX_FOR_INV_CM';
1380: lv_debug_info VARCHAR2(4000);
1381: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1382: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1383: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1384: SELECT *
1385: FROM jai_ar_trx_lines
1386: WHERE customer_trx_line_id = pn_customer_trx_line_id;

Line 1383: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS

1379: lv_api_name CONSTANT VARCHAR2(100) := 'RECALCULATE_TAX_FOR_INV_CM';
1380: lv_debug_info VARCHAR2(4000);
1381: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1382: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1383: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1384: SELECT *
1385: FROM jai_ar_trx_lines
1386: WHERE customer_trx_line_id = pn_customer_trx_line_id;
1387: lv_action VARCHAR2(20);

Line 1385: FROM jai_ar_trx_lines

1381: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
1382: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;
1383: CURSOR c_jai_ar_trx_lines(pn_customer_trx_line_id NUMBER) IS
1384: SELECT *
1385: FROM jai_ar_trx_lines
1386: WHERE customer_trx_line_id = pn_customer_trx_line_id;
1387: lv_action VARCHAR2(20);
1388: lv_return_message VARCHAR2(2000);
1389: lv_return_code VARCHAR2(100);

Line 1515: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;

1511: And b.customer_trx_id = v_header_id
1512: And (a.org_id = pr_new.org_id OR
1513: (a.org_id is NULL AND pr_new.org_id is NULL));
1514:
1515: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
1516:
1517: ld_trx_date DATE;
1518: BEGIN
1519:

Line 1710: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);

1706: last_updated_by = v_last_updated_by,
1707: last_update_login = v_last_update_login
1708: WHERE customer_trx_id = v_header_id;
1709:
1710: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1711: FETCH c_jai_ar_trx_lines
1712: INTO t_jai_line_rec_old;
1713: CLOSE c_jai_ar_trx_lines;
1714:

Line 1711: FETCH c_jai_ar_trx_lines

1707: last_update_login = v_last_update_login
1708: WHERE customer_trx_id = v_header_id;
1709:
1710: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1711: FETCH c_jai_ar_trx_lines
1712: INTO t_jai_line_rec_old;
1713: CLOSE c_jai_ar_trx_lines;
1714:
1715:

Line 1713: CLOSE c_jai_ar_trx_lines;

1709:
1710: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1711: FETCH c_jai_ar_trx_lines
1712: INTO t_jai_line_rec_old;
1713: CLOSE c_jai_ar_trx_lines;
1714:
1715:
1716: UPDATE JAI_AR_TRX_LINES
1717: SET description = pr_new.description,

Line 1716: UPDATE JAI_AR_TRX_LINES

1712: INTO t_jai_line_rec_old;
1713: CLOSE c_jai_ar_trx_lines;
1714:
1715:
1716: UPDATE JAI_AR_TRX_LINES
1717: SET description = pr_new.description,
1718: inventory_item_id = pr_new.inventory_item_id,
1719: unit_code = pr_new.uom_code,
1720: quantity = v_new_quantity,

Line 1737: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);

1733: vat_assessable_value = ln_vat_assessable_value
1734: WHERE customer_trx_line_id = pr_old.customer_trx_line_id
1735: AND customer_trx_id = v_header_id;
1736:
1737: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1738: FETCH c_jai_ar_trx_lines
1739: INTO t_jai_line_rec_new;
1740: CLOSE c_jai_ar_trx_lines;
1741: lv_action := JAI_CONSTANTS.UPDATING;

Line 1738: FETCH c_jai_ar_trx_lines

1734: WHERE customer_trx_line_id = pr_old.customer_trx_line_id
1735: AND customer_trx_id = v_header_id;
1736:
1737: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1738: FETCH c_jai_ar_trx_lines
1739: INTO t_jai_line_rec_new;
1740: CLOSE c_jai_ar_trx_lines;
1741: lv_action := JAI_CONSTANTS.UPDATING;
1742: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND

Line 1740: CLOSE c_jai_ar_trx_lines;

1736:
1737: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1738: FETCH c_jai_ar_trx_lines
1739: INTO t_jai_line_rec_new;
1740: CLOSE c_jai_ar_trx_lines;
1741: lv_action := JAI_CONSTANTS.UPDATING;
1742: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
1743: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
1744: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND

Line 1797: FROM JAI_AR_TRX_LINES

1793: order by 1;
1794:
1795: CURSOR old_line_amount_cur IS
1796: SELECT line_amount, tax_amount
1797: FROM JAI_AR_TRX_LINES
1798: WHERE CUSTOMER_TRX_ID = v_customer_trx_id
1799: AND CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
1800:
1801: CURSOR ONCE_COMPLETE_FLAG_CUR IS

Line 1861: DELETE JAI_AR_TRX_LINES

1857: DELETE JAI_AR_TRX_INS_LINES_T
1858: WHERE CUSTOMER_TRX_ID = v_customer_trx_id
1859: AND LINK_TO_CUST_TRX_LINE_ID = v_customer_trx_line_id;
1860:
1861: DELETE JAI_AR_TRX_LINES
1862: WHERE CUSTOMER_TRX_ID = v_customer_trx_id
1863: AND CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
1864: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1865: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1876: END JAI_AR_TRX_LINES_PKG;

1872: Pv_return_message := 'Encountered an error in ' || G_MODULE_NAME || '.' ||
1873: lv_api_name || ':' || substr(sqlerrm, 1, 1900);
1874:
1875: END DELETE_AR_TRX_LINES;
1876: END JAI_AR_TRX_LINES_PKG;