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_OM_WSH_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 141: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.EXPORT_ORIENTED_UNIT%TYPE ;

137: v_register_code_up VARCHAR2(25) ;---ashish 10june
138:
139: --New Variables Declared by Nagaraj.s for Enh2415656
140: v_output NUMBER ;-- By Nagaraj.s to get the output of the function ja_in_exc_balance_amt
141: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.EXPORT_ORIENTED_UNIT%TYPE ;
142: v_basic_pla_balance NUMBER ;
143: v_additional_pla_balance NUMBER ;
144: v_other_pla_balance NUMBER ;
145: v_myfilehandle UTL_FILE.FILE_TYPE ; -- This is for File handling

Line 211: FROM JAI_CMN_INVENTORY_ORGS

207: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
208: --This is included in the select by Nagaraj.s for Enh2415656
209: SELECT pref_rg23a, pref_rg23c, pref_pla,
210: NVL(Export_oriented_unit ,'N')
211: FROM JAI_CMN_INVENTORY_ORGS
212: WHERE organization_id = p_organization_id
213: AND location_id = p_location_id ;
214:
215: --This is included in the select by Nagaraj.s for Enh2415656

Line 227: FROM JAI_CMN_INVENTORY_ORGS

223: AND location_id = p_location_id ;
224:
225: CURSOR ssi_unit_flag_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
226: SELECT ssi_unit_flag
227: FROM JAI_CMN_INVENTORY_ORGS
228: WHERE organization_id = p_organization_id AND
229: location_id = p_location_id;
230:
231: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_delivery_detail_id NUMBER, p_order_type_id NUMBER) IS

Line 249: FROM JAI_CMN_INVENTORY_ORGS

245: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /* --'Modvat Recovery'; Ramananda for removal of SQL LITERALs */
246:
247: CURSOR for_modvat_percentage(p_organization_id NUMBER, p_location_id NUMBER) IS
248: SELECT MODVAT_REVERSE_PERCENT
249: FROM JAI_CMN_INVENTORY_ORGS
250: WHERE organization_id = p_organization_id
251: AND (location_id = p_location_id
252: OR
253: (location_id is NULL AND p_location_id is NULL)); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 305: FROM JAI_CMN_INVENTORY_ORGS A

301: AND register_code IS NULL;
302:
303: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
304: SELECT A.Organization_Id, A.Location_Id
305: FROM JAI_CMN_INVENTORY_ORGS A
306: WHERE A.Ec_Code IN (SELECT B.Ec_Code
307: FROM JAI_CMN_INVENTORY_ORGS B
308: WHERE B.Organization_Id = p_organization_id
309: AND B.Location_Id = p_location_id);

Line 307: FROM JAI_CMN_INVENTORY_ORGS B

303: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
304: SELECT A.Organization_Id, A.Location_Id
305: FROM JAI_CMN_INVENTORY_ORGS A
306: WHERE A.Ec_Code IN (SELECT B.Ec_Code
307: FROM JAI_CMN_INVENTORY_ORGS B
308: WHERE B.Organization_Id = p_organization_id
309: AND B.Location_Id = p_location_id);
310:
311: --Anuradha Parthasarathy 2001/05/26

Line 314: FROM JAI_CMN_INVENTORY_ORGS A

310:
311: --Anuradha Parthasarathy 2001/05/26
312: CURSOR Tr_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
313: SELECT A.Organization_Id, A.Location_Id
314: FROM JAI_CMN_INVENTORY_ORGS A
315: WHERE A.Tr_Ec_Code IN (SELECT B.Tr_Ec_Code
316: FROM JAI_CMN_INVENTORY_ORGS B
317: WHERE B.Organization_Id = p_organization_id
318: AND B.Location_Id = p_location_id);

Line 316: FROM JAI_CMN_INVENTORY_ORGS B

312: CURSOR Tr_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
313: SELECT A.Organization_Id, A.Location_Id
314: FROM JAI_CMN_INVENTORY_ORGS A
315: WHERE A.Tr_Ec_Code IN (SELECT B.Tr_Ec_Code
316: FROM JAI_CMN_INVENTORY_ORGS B
317: WHERE B.Organization_Id = p_organization_id
318: AND B.Location_Id = p_location_id);
319:
320: -- Related Cursors added by Arun for Trading on 28 oct 2000 at 3:30

Line 2421: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;

2417: RETURN VARCHAR2
2418: is
2419:
2420: --Variable Declaration starts here................
2421: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;
2422: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;
2423: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;
2424: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;
2425: v_reg_type varchar2(10);

Line 2422: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;

2418: is
2419:
2420: --Variable Declaration starts here................
2421: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;
2422: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;
2423: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;
2424: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;
2425: v_reg_type varchar2(10);
2426: v_exempt_amt number;

Line 2423: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;

2419:
2420: --Variable Declaration starts here................
2421: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;
2422: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;
2423: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;
2424: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;
2425: v_reg_type varchar2(10);
2426: v_exempt_amt number;
2427: v_rg23a_balance number;

Line 2424: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;

2420: --Variable Declaration starts here................
2421: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;
2422: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;
2423: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;
2424: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;
2425: v_reg_type varchar2(10);
2426: v_exempt_amt number;
2427: v_rg23a_balance number;
2428: v_rg23c_balance number;

Line 2437: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%type;

2433: v_other_pla_balance number;
2434: v_basic_excise_duty_amount number;
2435: v_add_excise_duty_amount number;
2436: v_oth_excise_duty_amount number;
2437: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%type;
2438: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
2439: v_debug_flag varchar2(1); -- := 'N'; --Ramananda for File.Sql.35
2440: v_utl_location VARCHAR2(512); --For Log file.
2441: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling