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 146: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.EXPORT_ORIENTED_UNIT%TYPE ;

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

Line 216: FROM JAI_CMN_INVENTORY_ORGS

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

Line 232: FROM JAI_CMN_INVENTORY_ORGS

228: AND location_id = p_location_id ;
229:
230: CURSOR ssi_unit_flag_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
231: SELECT ssi_unit_flag
232: FROM JAI_CMN_INVENTORY_ORGS
233: WHERE organization_id = p_organization_id AND
234: location_id = p_location_id;
235:
236: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_delivery_detail_id NUMBER, p_order_type_id NUMBER) IS

Line 254: FROM JAI_CMN_INVENTORY_ORGS

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

Line 310: FROM JAI_CMN_INVENTORY_ORGS A

306: AND register_code IS NULL;
307:
308: CURSOR ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
309: SELECT A.Organization_Id, A.Location_Id
310: FROM JAI_CMN_INVENTORY_ORGS A
311: WHERE A.Ec_Code IN (SELECT B.Ec_Code
312: FROM JAI_CMN_INVENTORY_ORGS B
313: WHERE B.Organization_Id = p_organization_id
314: AND B.Location_Id = p_location_id);

Line 312: FROM JAI_CMN_INVENTORY_ORGS B

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

Line 319: FROM JAI_CMN_INVENTORY_ORGS A

315:
316: --Anuradha Parthasarathy 2001/05/26
317: CURSOR Tr_ec_code_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
318: SELECT A.Organization_Id, A.Location_Id
319: FROM JAI_CMN_INVENTORY_ORGS A
320: WHERE A.Tr_Ec_Code IN (SELECT B.Tr_Ec_Code
321: FROM JAI_CMN_INVENTORY_ORGS B
322: WHERE B.Organization_Id = p_organization_id
323: AND B.Location_Id = p_location_id);

Line 321: FROM JAI_CMN_INVENTORY_ORGS B

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

Line 2550: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;

2546: RETURN VARCHAR2
2547: is
2548:
2549: --Variable Declaration starts here................
2550: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;
2551: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;
2552: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;
2553: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;
2554: v_reg_type varchar2(10);

Line 2551: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;

2547: is
2548:
2549: --Variable Declaration starts here................
2550: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;
2551: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;
2552: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;
2553: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;
2554: v_reg_type varchar2(10);
2555: v_exempt_amt number;

Line 2552: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;

2548:
2549: --Variable Declaration starts here................
2550: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;
2551: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;
2552: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;
2553: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;
2554: v_reg_type varchar2(10);
2555: v_exempt_amt number;
2556: v_rg23a_balance number;

Line 2553: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;

2549: --Variable Declaration starts here................
2550: v_pref_rg23a JAI_CMN_INVENTORY_ORGS.pref_rg23a%type;
2551: v_pref_rg23c JAI_CMN_INVENTORY_ORGS.pref_rg23c%type;
2552: v_pref_pla JAI_CMN_INVENTORY_ORGS.pref_pla%type;
2553: v_ssi_unit_flag JAI_CMN_INVENTORY_ORGS.ssi_unit_flag%type;
2554: v_reg_type varchar2(10);
2555: v_exempt_amt number;
2556: v_rg23a_balance number;
2557: v_rg23c_balance number;

Line 2566: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%type;

2562: v_other_pla_balance number;
2563: v_basic_excise_duty_amount number;
2564: v_add_excise_duty_amount number;
2565: v_oth_excise_duty_amount number;
2566: v_export_oriented_unit JAI_CMN_INVENTORY_ORGS.export_oriented_unit%type;
2567: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
2568: v_debug_flag varchar2(1); -- := 'N'; --Ramananda for File.Sql.35
2569: v_utl_location VARCHAR2(512); --For Log file.
2570: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling