APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 1367: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;

1363: pv_return_code out NOCOPY varchar2,
1364: pv_return_message out NOCOPY varchar2) IS
1365: lv_api_name CONSTANT VARCHAR2(100) := 'GENERATE_VAT_INVOICE_NUMBER';
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;

Line 1368: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;

1364: pv_return_message out NOCOPY varchar2) IS
1365: lv_api_name CONSTANT VARCHAR2(100) := 'GENERATE_VAT_INVOICE_NUMBER';
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:

Line 1369: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;

1365: lv_api_name CONSTANT VARCHAR2(100) := 'GENERATE_VAT_INVOICE_NUMBER';
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;

Line 1371: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;

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;
1375: v_vat_taxes_exist Number;

Line 1412: from JAI_CMN_INVENTORY_ORGS

1408: p_loc_id Number) is
1409:
1410: Cursor c_get_vat_reg_no is
1411: select vat_reg_no
1412: from JAI_CMN_INVENTORY_ORGS
1413: where organization_id = p_organization_id
1414: and location_id = p_loc_id;
1415:
1416: cursor c_get_vat_invoice_no is

Line 1418: from JAI_CMN_INVENTORY_ORGS

1414: and location_id = p_loc_id;
1415:
1416: cursor c_get_vat_invoice_no is
1417: select current_number, jump_by, prefix
1418: from JAI_CMN_INVENTORY_ORGS
1419: where organization_id = p_organization_id
1420: and location_id = p_loc_id;
1421: --Added by Zhiwei for JAI Trigger elimination begin
1422: ---------------------------------------------------------

Line 1448: update JAI_CMN_INVENTORY_ORGS

1444: if v_vat_reg_no is null then
1445: return;
1446: end if;
1447:
1448: update JAI_CMN_INVENTORY_ORGS
1449: set last_update_date = last_update_date
1450: where vat_reg_no = v_vat_reg_no;
1451:
1452: Open c_get_vat_invoice_no;

Line 1503: update JAI_CMN_INVENTORY_ORGS

1499: end if;
1500: ---------------------------------------------------------
1501: --Added by Qinglei for JAI Trigger elimination end
1502:
1503: update JAI_CMN_INVENTORY_ORGS
1504: set current_number = NVL(v_vat_start_num, 0),
1505: prefix = v_vat_prefix,
1506: jump_by = v_vat_jump_by
1507: where vat_Reg_no = v_vat_reg_no;

Line 1852: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

1848: v_errbuf VARCHAR2(250);
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,

Line 1902: FROM JAI_CMN_INVENTORY_ORGS

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
1902: FROM JAI_CMN_INVENTORY_ORGS
1903: WHERE organization_id = p_org_id
1904: AND location_id = p_loc_id;
1905:
1906: CURSOR item_class_cur(P_ORG_ID IN NUMBER, P_Item_id IN NUMBER) IS

Line 1986: FROM JAI_CMN_INVENTORY_ORGS

1982: ORDER BY 1;
1983:
1984: CURSOR ssi_unit_flag_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1985: SELECT ssi_unit_flag, nvl(trading, 'N')
1986: FROM JAI_CMN_INVENTORY_ORGS
1987: WHERE organization_id = p_org_id
1988: AND location_id = p_loc_id;
1989:
1990: CURSOR transaction_type_cur IS

Line 2037: FROM JAI_CMN_INVENTORY_ORGS

2033: WHERE lookup_code = p_register_code
2034: AND lookup_type = cp_register_type;
2035: CURSOR for_modvat_percentage(v_org_id NUMBER, v_location_id NUMBER) IS
2036: SELECT MODVAT_REVERSE_PERCENT
2037: FROM JAI_CMN_INVENTORY_ORGS
2038: WHERE organization_id = v_org_id
2039: AND (location_id = v_location_id OR
2040: (location_id is NULL and v_location_id is NULL));
2041: CURSOR for_modvat_tax_rate(p_cust_trx_line_id NUMBER) IS

Line 2058: FROM JAI_CMN_INVENTORY_ORGS A

2054: v_set_of_books_id NUMBER;
2055: CURSOR ec_code_cur(p_organization_id IN NUMBER,
2056: p_location_id IN NUMBER) IS
2057: SELECT A.Organization_Id, A.Location_Id
2058: FROM JAI_CMN_INVENTORY_ORGS A
2059: WHERE A.Ec_Code IN
2060: (SELECT B.Ec_Code
2061: FROM JAI_CMN_INVENTORY_ORGS B
2062: WHERE B.Organization_Id = p_organization_id

Line 2061: FROM JAI_CMN_INVENTORY_ORGS B

2057: SELECT A.Organization_Id, A.Location_Id
2058: FROM JAI_CMN_INVENTORY_ORGS A
2059: WHERE A.Ec_Code IN
2060: (SELECT B.Ec_Code
2061: FROM JAI_CMN_INVENTORY_ORGS B
2062: WHERE B.Organization_Id = p_organization_id
2063: AND B.Location_Id = p_location_id);
2064:
2065: CURSOR c_total_Excise_amt IS