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_TRXS

Line 63: PROCEDURE POPULATE_JAI_AR_TRXS(pr_new T_REC%TYPE,

59: return(true);
60: END IF;
61:
62: END check_reg_dealer;
63: PROCEDURE POPULATE_JAI_AR_TRXS(pr_new T_REC%TYPE,
64: pv_action VARCHAR2,
65: pv_return_code OUT NOCOPY VARCHAR2,
66: pv_return_message OUT NOCOPY VARCHAR2) IS
67: v_org_id NUMBER;

Line 96: FROM JAI_AR_TRXS

92: AND order_flag = 'N');
93:
94: CURSOR organization_cur IS
95: SELECT organization_id, location_id
96: FROM JAI_AR_TRXS
97: WHERE trx_number = v_parent_trx_number;
98:
99: CURSOR transaction_type_cur IS
100: SELECT type

Line 107: FROM JAI_AR_TRXS

103: AND NVL(org_id, 0) = NVL(pr_new.org_id, 0);
104:
105: CURSOR localization_header_info IS
106: SELECT organization_id, location_id, update_rg_flag
107: FROM JAI_AR_TRXS
108: WHERE customer_trx_id = pr_new.previous_customer_trx_id;
109:
110: v_currency_code gl_sets_of_books.currency_code%TYPE;
111: CURSOR curr(c_sob NUMBER) IS

Line 246: lv_debug_info := 'Insert table JAI_AR_TRXS. pr_new.CUSTOMER_TRX_ID = ' ||

242: END IF;
243: END IF;
244:
245: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
246: lv_debug_info := 'Insert table JAI_AR_TRXS. pr_new.CUSTOMER_TRX_ID = ' ||
247: pr_new.CUSTOMER_TRX_ID || ', V_ORG_ID = ' ||
248: V_ORG_ID || ', V_LOC_ID = ' || V_LOC_ID ||
249: ', pr_new.TRX_NUMBER = ' || pr_new.TRX_NUMBER ||
250: ', V_UPDATE_RG = ' || V_UPDATE_RG ||

Line 284: INSERT INTO JAI_AR_TRXS

280: G_MODULE_NAME || lv_api_name,
281: lv_debug_info);
282: END IF;
283:
284: INSERT INTO JAI_AR_TRXS
285: (CUSTOMER_TRX_ID,
286: ORGANIZATION_ID,
287: LOCATION_ID,
288: TRX_NUMBER,

Line 354: END POPULATE_JAI_AR_TRXS;

350: SQLERRM,
351: 1,
352: 4000));
353: END IF;
354: END POPULATE_JAI_AR_TRXS;
355:
356: PROCEDURE POPULATE_COPIED_TRANSACTIONS(PR_NEW T_REC%TYPE,
357: PV_ACTION VARCHAR2,
358: PV_RETURN_CODE OUT NOCOPY VARCHAR2,

Line 421: FROM JAI_AR_TRXS

417:
418: CURSOR ONCE_COMPLETE_FLAG_CUR(p_header_id IN NUMBER,
419: p_batch_source_id IN Number) IS
420: SELECT once_completed_flag, 1
421: FROM JAI_AR_TRXS
422: WHERE customer_trx_id = p_header_id
423: AND NVL(batch_source_id, 0) = p_batch_source_id;
424:
425: CURSOR parent_header_id(p_recurred_from_trx_number IN Varchar2,

Line 428: FROM JAI_AR_TRXS a

424:
425: CURSOR parent_header_id(p_recurred_from_trx_number IN Varchar2,
426: p_batch_source_id IN Number) IS
427: SELECT a.customer_trx_id
428: FROM JAI_AR_TRXS a
429: WHERE a.trx_number = p_recurred_from_trx_number
430: AND NVL(batch_source_id, 0) = p_batch_source_id;
431:
432: CURSOR LINES_INFO_CUR(p_parent_header_id IN Number) IS

Line 492: FROM JAI_AR_TRXS

488: legal_entity_id,
489: complete_flag,
490: ship_to_customer_id,
491: ship_to_site_use_id
492: FROM JAI_AR_TRXS
493: WHERE trx_number = p_recurred_from_trx_number
494: AND NVL(batch_source_id, 0) = p_batch_source_id;
495: BEGIN
496: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 544: INSERT INTO JAI_AR_TRXS

540: IF NVL(x, 0) <> 1 THEN
541:
542: FOR hdr in HEADER_INFO_CUR(v_recurred_from_trx_number,
543: v_batch_source_id) LOOP
544: INSERT INTO JAI_AR_TRXS
545: (customer_trx_id,
546: organization_id,
547: location_id,
548: update_rg23d_flag,

Line 758: UPDATE JAI_AR_TRXS

754:
755: v_line_tax_amount := 0;
756: END LOOP;
757:
758: UPDATE JAI_AR_TRXS
759: SET tax_amount = v_header_tax_amount,
760: total_amount = nvl(line_amount, 0) + v_header_tax_amount
761: WHERE customer_trx_id = v_header_id;
762: v_header_tax_amount := 0;

Line 824: Update JAI_AR_TRXS

820: v_ref_line_id := pr_new.interface_header_attribute7;
821:
822: IF pr_new.created_from = 'RAXTRX' THEN
823: IF pr_new.CUSTOMER_TRX_ID <> pr_old.CUSTOMER_TRX_ID THEN
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

Line 869: Update JAI_AR_TRXS

865: END IF;
866: END LOOP;
867: END IF;
868:
869: Update JAI_AR_TRXS
870: Set Trx_Number = pr_new.Trx_Number
871: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
872: END IF;
873:

Line 881: Update JAI_AR_TRXS

877: CLOSE transaction_type_cur;
878: IF NVL(v_trans_type, 'N') in ('CM', 'DM') THEN
879:
880: IF pr_new.created_from = 'RAXTRX' THEN
881: Update JAI_AR_TRXS
882: Set Trx_Number = pr_new.Trx_Number
883: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
884: ELSE
885:

Line 886: Update JAI_AR_TRXS

882: Set Trx_Number = pr_new.Trx_Number
883: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
884: ELSE
885:
886: Update JAI_AR_TRXS
887: Set Trx_Number = pr_new.Trx_Number,
888: Once_Completed_Flag = NVL(pr_new.Complete_Flag, 'N')
889: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
890: END IF;

Line 893: Update JAI_AR_TRXS

889: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
890: END IF;
891:
892: ELSIF NVL(v_trans_type, 'N') = 'INV' THEN
893: Update JAI_AR_TRXS
894: Set Trx_Number = pr_new.Trx_Number
895: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
896: END IF;
897: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 982: FROM JAI_AR_TRXS

978: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
979:
980: CURSOR organization_cur IS
981: SELECT organization_id, location_id
982: FROM JAI_AR_TRXS
983: WHERE trx_number = pr_new.recurred_from_trx_number;
984:
985: CURSOR ONCE_COMPLETE_FLAG_CUR IS
986: SELECT once_completed_flag

Line 987: FROM JAI_AR_TRXS

983: WHERE trx_number = pr_new.recurred_from_trx_number;
984:
985: CURSOR ONCE_COMPLETE_FLAG_CUR IS
986: SELECT once_completed_flag
987: FROM JAI_AR_TRXS
988: WHERE customer_trx_id = v_header_id;
989:
990: v_trans_type Varchar2(30);
991:

Line 1078: UPDATE JAI_AR_TRXS

1074: RETURN;
1075: END IF;
1076: IF pr_new.invoice_currency_code <> pr_old.invoice_currency_code THEN
1077:
1078: UPDATE JAI_AR_TRXS
1079: SET invoice_currency_code = pr_new.invoice_currency_code,
1080: exchange_rate_type = pr_new.exchange_rate_type,
1081: exchange_date = pr_new.exchange_date,
1082: exchange_rate = pr_new.exchange_rate

Line 1090: UPDATE JAI_AR_TRXS

1086:
1087: IF (pr_new.ship_to_customer_id <> pr_old.ship_to_customer_id)
1088: OR (pr_new.ship_to_site_use_id <> pr_old.ship_to_site_use_id) THEN
1089:
1090: UPDATE JAI_AR_TRXS
1091: SET ship_to_customer_id = pr_new.ship_to_customer_id,
1092: ship_to_site_use_id = pr_new.ship_to_site_use_id
1093: WHERE customer_trx_id = pr_new.customer_trx_id;
1094: END IF;

Line 1343: DELETE JAI_AR_TRXS WHERE customer_trx_id = pr_old.customer_trx_id;

1339: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1340: G_MODULE_NAME || lv_api_name,
1341: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1342: END IF;
1343: DELETE JAI_AR_TRXS WHERE customer_trx_id = pr_old.customer_trx_id;
1344:
1345: pv_return_message := '';
1346: pv_return_code := jai_constants.successful;
1347: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1370: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;

1366: lv_debug_info VARCHAR2(4000);
1367: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
1368: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
1369: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
1370: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
1371: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
1372:
1373: v_organization_id Number;
1374: v_loc_id Number;

Line 1377: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;

1373: v_organization_id Number;
1374: v_loc_id Number;
1375: v_vat_taxes_exist Number;
1376: v_trans_type VARCHAR2(30);
1377: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;
1378:
1379: CURSOR organization_cur IS
1380: SELECT organization_id, location_id
1381: FROM JAI_AR_TRXS

Line 1381: FROM JAI_AR_TRXS

1377: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;
1378:
1379: CURSOR organization_cur IS
1380: SELECT organization_id, location_id
1381: FROM JAI_AR_TRXS
1382: where customer_trx_id = pr_new.customer_trx_id;
1383:
1384: CURSOR C_VAT_INVOICE_CUR IS
1385: SELECT TAX_INVOICE_NO

Line 1386: FROM JAI_AR_TRXS

1382: where customer_trx_id = pr_new.customer_trx_id;
1383:
1384: CURSOR C_VAT_INVOICE_CUR IS
1385: SELECT TAX_INVOICE_NO
1386: FROM JAI_AR_TRXS
1387: WHERE Customer_Trx_Id = pr_new.customer_trx_id;
1388:
1389: cursor c_vat_taxes_exist is
1390: select 1

Line 1425: from jai_ar_trxs

1421: --Added by Zhiwei for JAI Trigger elimination begin
1422: ---------------------------------------------------------
1423: cursor c_get_rec(cn_customer_trx_id number) is
1424: select *
1425: from jai_ar_trxs
1426: where customer_trx_id = cn_customer_trx_id;
1427:
1428: t_rec_new jai_ar_trxs%rowtype;
1429: t_rec_old jai_ar_trxs%rowtype;

Line 1428: t_rec_new jai_ar_trxs%rowtype;

1424: select *
1425: from jai_ar_trxs
1426: where customer_trx_id = cn_customer_trx_id;
1427:
1428: t_rec_new jai_ar_trxs%rowtype;
1429: t_rec_old jai_ar_trxs%rowtype;
1430: lv_action VARCHAR2(20);
1431: lv_return_message VARCHAR2(2000);
1432: lv_return_code VARCHAR2(100);

Line 1429: t_rec_old jai_ar_trxs%rowtype;

1425: from jai_ar_trxs
1426: where customer_trx_id = cn_customer_trx_id;
1427:
1428: t_rec_new jai_ar_trxs%rowtype;
1429: t_rec_old jai_ar_trxs%rowtype;
1430: lv_action VARCHAR2(20);
1431: lv_return_message VARCHAR2(2000);
1432: lv_return_code VARCHAR2(100);
1433: le_error EXCEPTION;

Line 1474: update JAI_AR_TRXS

1470: close c_get_rec;
1471: ---------------------------------------------------------
1472: --Added by Qinglei for JAI Trigger elimination end
1473:
1474: update JAI_AR_TRXS
1475: set tax_invoice_no = v_vat_invoice_no
1476: where customer_trx_id = pr_new.customer_trx_id;
1477:
1478: --Added by Qinglei for JAI Trigger elimination begin

Line 1489: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,

1485: if (t_rec_new.once_completed_flag = 'Y') then
1486:
1487: lv_action := jai_constants.updating;
1488:
1489: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
1490: pr_new => t_rec_new,
1491: pv_action => lv_action,
1492: pv_return_code => lv_return_code,
1493: pv_return_message => lv_return_message);

Line 1572: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;

1568: lv_debug_info VARCHAR2(4000);
1569: v_organization_id NUMBER;
1570: v_loc_id NUMBER;
1571: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;
1572: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1573: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1574: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1575: lv_process_flag VARCHAR2(10);
1576: lv_process_message VARCHAR2(4000);

Line 1578: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE;

1574: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1575: lv_process_flag VARCHAR2(10);
1576: lv_process_message VARCHAR2(4000);
1577: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1578: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE;
1579:
1580: CURSOR organization_cur IS
1581: SELECT organization_id, location_id, vat_invoice_no, vat_invoice_date
1582: FROM JAI_AR_TRXS

Line 1582: FROM JAI_AR_TRXS

1578: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE;
1579:
1580: CURSOR organization_cur IS
1581: SELECT organization_id, location_id, vat_invoice_no, vat_invoice_date
1582: FROM JAI_AR_TRXS
1583: WHERE customer_trx_id = pr_new.customer_trx_id;
1584:
1585: CURSOR transaction_type_cur IS
1586: SELECT type

Line 1613: FROM JAI_AR_TRXS

1609: AND latest_rec_flag = 'Y';
1610:
1611: CURSOR cur_get_in_vat_no IS
1612: SELECT vat_invoice_no
1613: FROM JAI_AR_TRXS
1614: WHERE customer_trx_id = pr_new.previous_customer_trx_id;
1615:
1616: CURSOR c_chk_vat_reversal(cp_tax_type jai_cmn_taxes_all.tax_type%TYPE) IS
1617: SELECT 1

Line 1636: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;

1632: FROM jai_regime_tax_types_v
1633: WHERE regime_code = jai_constants.vat_regime
1634: AND rownum = 1;
1635: cursor c_get_rec(cn_customer_trx_id number) is
1636: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
1637:
1638: t_rec_new jai_ar_trxs%rowtype;
1639: t_rec_old jai_ar_trxs%rowtype;
1640: lv_action VARCHAR2(20);

Line 1638: t_rec_new jai_ar_trxs%rowtype;

1634: AND rownum = 1;
1635: cursor c_get_rec(cn_customer_trx_id number) is
1636: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
1637:
1638: t_rec_new jai_ar_trxs%rowtype;
1639: t_rec_old jai_ar_trxs%rowtype;
1640: lv_action VARCHAR2(20);
1641: lv_return_message VARCHAR2(2000);
1642: lv_return_code VARCHAR2(100);

Line 1639: t_rec_old jai_ar_trxs%rowtype;

1635: cursor c_get_rec(cn_customer_trx_id number) is
1636: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
1637:
1638: t_rec_new jai_ar_trxs%rowtype;
1639: t_rec_old jai_ar_trxs%rowtype;
1640: lv_action VARCHAR2(20);
1641: lv_return_message VARCHAR2(2000);
1642: lv_return_code VARCHAR2(100);
1643: le_error EXCEPTION;

Line 1746: UPDATE JAI_AR_TRXS

1742: close c_get_rec;
1743: ---------------------------------------------------------
1744: --Added by Zhiwei for JAI Trigger elimination end
1745:
1746: UPDATE JAI_AR_TRXS
1747: SET vat_invoice_no = lv_vat_invoice_no,
1748: vat_invoice_date = nvl(ld_gl_date, pr_new.trx_date)
1749: WHERE customer_trx_id = pr_new.customer_trx_id;
1750:

Line 1762: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,

1758: if (t_rec_new.once_completed_flag = 'Y') then
1759:
1760: lv_action := jai_constants.updating;
1761:
1762: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
1763: pr_new => t_rec_new,
1764: pv_action => lv_action,
1765: pv_return_code => lv_return_code,
1766: pv_return_message => lv_return_message);

Line 1853: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;

1849: v_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
1850: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1851: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1852: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1853: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;
1854:
1855: CURSOR complete_cur IS
1856: SELECT organization_id,
1857: location_id,

Line 1868: FROM JAI_AR_TRXS

1864: 'P',
1865: 'PLA') register_type,
1866: update_rg_flag,
1867: nvl(update_rg23d_flag, 'N')
1868: FROM JAI_AR_TRXS
1869: WHERE customer_trx_id = v_customer_trx_id;
1870:
1871: CURSOR REG_BALANCE_CUR(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1872: SELECT NVL(rg23a_balance, 0) rg23a_balance,

Line 1897: FROM JAI_AR_TRXS

1893: AND fin_active_flag = 'Y';
1894:
1895: CURSOR tax_amount_cur IS
1896: SELECT NVL(tax_amount, 0) tax_amount
1897: FROM JAI_AR_TRXS
1898: WHERE customer_trx_id = v_customer_trx_id;
1899:
1900: CURSOR preference_reg_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1901: SELECT pref_rg23a, pref_rg23c, pref_pla

Line 1914: FROM JAI_AR_TRXS

1910: AND ORGANIZATION_ID = P_ORG_ID;
1911:
1912: CURSOR organization_cur IS
1913: SELECT organization_id, location_id
1914: FROM JAI_AR_TRXS
1915: WHERE trx_number = v_parent_trx_number;
1916:
1917: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1918: SELECT NVL(register_balance, 0) register_balance

Line 2067: FROM JAI_AR_TRXS jtrx,

2063: AND B.Location_Id = p_location_id);
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

Line 2104: CURSOR cur_chk_temp_lines_exist(cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE) IS

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));
2103:
2104: CURSOR cur_chk_temp_lines_exist(cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE) IS
2105:
2106: SELECT '1'
2107: FROM Fnd_Concurrent_Requests FCR
2108: WHERE FCR.argument1 = to_char(cp_customer_trx_id)

Line 2125: FROM JAI_AR_TRXS

2121: AND FCR.argument1 = To_Char(cp_customer_trx_id));
2122:
2123: CURSOR c_vat_invoice_cur IS
2124: SELECT vat_invoice_no
2125: FROM JAI_AR_TRXS
2126: WHERE customer_trx_id = pr_new.customer_trx_id;
2127:
2128: CURSOR cur_vat_taxes_exist IS
2129: SELECT regime_id, regime_code

Line 2161: CURSOR cur_get_same_inv_no(cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE,

2157:
2158: ln_vat_reversal_exists NUMBER;
2159: lv_vat_reversal VARCHAR2(100);
2160:
2161: CURSOR cur_get_same_inv_no(cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE,
2162: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE) IS
2163: SELECT nvl(attribute_value, 'N') attribute_value
2164: FROM JAI_RGM_ORG_REGNS_V
2165: WHERE regime_code = jai_constants.vat_regime

Line 2162: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE) IS

2158: ln_vat_reversal_exists NUMBER;
2159: lv_vat_reversal VARCHAR2(100);
2160:
2161: CURSOR cur_get_same_inv_no(cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE,
2162: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE) IS
2163: SELECT nvl(attribute_value, 'N') attribute_value
2164: FROM JAI_RGM_ORG_REGNS_V
2165: WHERE regime_code = jai_constants.vat_regime
2166: AND attribute_type_code = jai_constants.regn_type_others

Line 2191: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;

2187: lv_register_type VARCHAR2(5);
2188: lv_rg23a_cess_avlbl VARCHAR2(10);
2189: lv_rg23c_cess_avlbl VARCHAR2(10);
2190: lv_pla_cess_avlbl VARCHAR2(10);
2191: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
2192: lv_vat_taxes_exist VARCHAR2(1);
2193: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
2194: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
2195: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

Line 2205: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;

2201: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
2202: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
2203:
2204: cursor c_get_rec(cn_customer_trx_id number) is
2205: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
2206:
2207: t_rec_new jai_ar_trxs%rowtype;
2208: t_rec_old jai_ar_trxs%rowtype;
2209: lv_action VARCHAR2(20);

Line 2207: t_rec_new jai_ar_trxs%rowtype;

2203:
2204: cursor c_get_rec(cn_customer_trx_id number) is
2205: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
2206:
2207: t_rec_new jai_ar_trxs%rowtype;
2208: t_rec_old jai_ar_trxs%rowtype;
2209: lv_action VARCHAR2(20);
2210: lv_return_message VARCHAR2(2000);
2211: lv_return_code VARCHAR2(100);

Line 2208: t_rec_old jai_ar_trxs%rowtype;

2204: cursor c_get_rec(cn_customer_trx_id number) is
2205: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
2206:
2207: t_rec_new jai_ar_trxs%rowtype;
2208: t_rec_old jai_ar_trxs%rowtype;
2209: lv_action VARCHAR2(20);
2210: lv_return_message VARCHAR2(2000);
2211: lv_return_code VARCHAR2(100);
2212: le_error EXCEPTION;

Line 2281: UPDATE JAI_AR_TRXS

2277: close c_get_rec;
2278: ---------------------------------------------------------
2279: --Added by Zhiwei for JAI Trigger elimination end
2280:
2281: UPDATE JAI_AR_TRXS
2282: SET ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
2283: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;
2284:
2285: --Added by Zhiwei for JAI Trigger elimination begin

Line 2296: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,

2292: if (t_rec_new.once_completed_flag = 'Y') then
2293:
2294: lv_action := jai_constants.updating;
2295:
2296: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
2297: pr_new => t_rec_new,
2298: pv_action => lv_action,
2299: pv_return_code => lv_return_code,
2300: pv_return_message => lv_return_message);

Line 2321: UPDATE JAI_AR_TRXS

2317: close c_get_rec;
2318: ---------------------------------------------------------
2319: --Added by Zhiwei for JAI Trigger elimination end
2320:
2321: UPDATE JAI_AR_TRXS
2322: SET ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
2323: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;
2324:
2325: --Added by Zhiwei for JAI Trigger elimination begin

Line 2336: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,

2332: if (t_rec_new.once_completed_flag = 'Y') then
2333:
2334: lv_action := jai_constants.updating;
2335:
2336: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
2337: pr_new => t_rec_new,
2338: pv_action => lv_action,
2339: pv_return_code => lv_return_code,
2340: pv_return_message => lv_return_message);

Line 2881: FROM JAI_AR_TRXS

2877: v_reg_type VARCHAR2(10);
2878: Begin
2879: SELECT once_completed_flag
2880: INTO v_reg_type
2881: FROM JAI_AR_TRXS
2882: WHERE CUSTOMER_TRX_ID = pr_new.Customer_trx_id;
2883:
2884: IF v_reg_type = 'P' THEN
2885: v_reg_type := 'PLA';

Line 3012: FROM JAI_AR_TRXS

3008: v_reg_type1 VARCHAR2(10);
3009: Begin
3010: SELECT once_completed_flag
3011: INTO v_reg_type1
3012: FROM JAI_AR_TRXS
3013: WHERE CUSTOMER_TRX_ID = pr_new.Customer_trx_id;
3014:
3015: If v_reg_type1 = 'P' THEN
3016: v_reg_type1 := 'PLA';

Line 3091: UPDATE JAI_AR_TRXS

3087: close c_get_rec;
3088: ---------------------------------------------------------
3089: --Added by Zhiwei for JAI Trigger elimination end
3090:
3091: UPDATE JAI_AR_TRXS
3092: SET ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
3093: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;
3094:
3095: --Added by Zhiwei for JAI Trigger elimination begin

Line 3106: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,

3102: if (t_rec_new.once_completed_flag = 'Y') then
3103:
3104: lv_action := jai_constants.updating;
3105:
3106: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
3107: pr_new => t_rec_new,
3108: pv_action => lv_action,
3109: pv_return_code => lv_return_code,
3110: pv_return_message => lv_return_message);

Line 3248: UPDATE JAI_AR_TRXS

3244: close c_get_rec;
3245: ---------------------------------------------------------
3246: --Added by Zhiwei for JAI Trigger elimination end
3247:
3248: UPDATE JAI_AR_TRXS
3249: SET vat_invoice_no = lv_vat_invoice_number,
3250: vat_invoice_date = nvl(ld_gl_date, pr_new.trx_date)
3251: WHERE customer_trx_id = pr_new.customer_trx_id;
3252:

Line 3264: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,

3260: if (t_rec_new.once_completed_flag = 'Y') then
3261:
3262: lv_action := jai_constants.updating;
3263:
3264: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
3265: pr_new => t_rec_new,
3266: pv_action => lv_action,
3267: pv_return_code => lv_return_code,
3268: pv_return_message => lv_return_message);

Line 3305: LV_ONCE_COMPLETED_FLAG JAI_AR_TRXS.ONCE_COMPLETED_FLAG%TYPE;

3301: lv_api_name CONSTANT VARCHAR2(100) := 'PROCESS_TCS_TAXES';
3302: lv_debug_info VARCHAR2(4000);
3303: LV_DOCUMENT_TYPE VARCHAR2(40);
3304: LN_REG_ID NUMBER;
3305: LV_ONCE_COMPLETED_FLAG JAI_AR_TRXS.ONCE_COMPLETED_FLAG%TYPE;
3306: V_HEADER_ID NUMBER;
3307:
3308: CURSOR ONCE_COMPLETE_FLAG_CUR IS
3309: SELECT ONCE_COMPLETED_FLAG

Line 3310: FROM JAI_AR_TRXS

3306: V_HEADER_ID NUMBER;
3307:
3308: CURSOR ONCE_COMPLETE_FLAG_CUR IS
3309: SELECT ONCE_COMPLETED_FLAG
3310: FROM JAI_AR_TRXS
3311: WHERE CUSTOMER_TRX_ID = V_HEADER_ID;
3312:
3313: BEGIN
3314: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN