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_OM_OE_BOND_REG_HDRS

Line 156: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%TYPE ; -- bug # 3021588

152: v_ret_stat BOOLEAN ; -- 2663211 -- for raising error
153: --Ends here for Enh2415656
154:
155: v_asst_register_id NUMBER ; -- bug # 3021588
156: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%TYPE ; -- bug # 3021588
157: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE ; -- bug # 3021588
158:
159: -- Cursor to fetch required values for corresponding Delivery_detail_id in
160: CURSOR Get_delivery_detail_cur(p_delivery_detail_id NUMBER) IS

Line 157: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE ; -- bug # 3021588

153: --Ends here for Enh2415656
154:
155: v_asst_register_id NUMBER ; -- bug # 3021588
156: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%TYPE ; -- bug # 3021588
157: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE ; -- bug # 3021588
158:
159: -- Cursor to fetch required values for corresponding Delivery_detail_id in
160: CURSOR Get_delivery_detail_cur(p_delivery_detail_id NUMBER) IS
161: SELECT A.order_line_id, A.organization_id, A.location_id, A.register,

Line 238: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

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
237: SELECT A.register_code
238: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
239: WHERE A.organization_id = p_organization_id
240: AND A.location_id = p_location_id
241: AND A.register_id = b.register_id
242: AND b.order_flag = 'Y'

Line 265: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

261: CURSOR register_balance_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
262: SELECT register_balance
263: FROM JAI_OM_OE_BOND_TRXS
264: WHERE transaction_id = (SELECT MAX(A.transaction_id)
265: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
266: WHERE A.register_id = B.register_id
267: AND B.organization_id = p_organization_id
268: AND B.location_id = p_location_id);
269:

Line 329: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

325: -- Related Cursors added by Arun for Trading on 28 oct 2000 at 3:30
326: CURSOR Trading_register_code_cur(p_organization_id NUMBER, p_location_id NUMBER,
327: p_delivery_detail_id NUMBER, p_order_type_id NUMBER) IS
328: SELECT A.register_code
329: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
330: WHERE A.organization_id = p_organization_id
331: AND A.location_id = p_location_id
332: AND A.register_id = b.register_id
333: AND b.order_flag = 'Y'

Line 754: introduction of 3 new columns in the JAI_OM_OE_BOND_REG_HDRS table and also call to the new package jai_cmn_bond_register_pkg.

750:
751: For Multiple Bond Register Enhancement,
752: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
753: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
754: introduction of 3 new columns in the JAI_OM_OE_BOND_REG_HDRS table and also call to the new package jai_cmn_bond_register_pkg.
755:
756: New Validations for checking the bond expiry date and to check the balance based on the call to the jai_cmn_bond_register_pkg has been added
757:
758: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register

Line 760: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the

756: New Validations for checking the bond expiry date and to check the balance based on the call to the jai_cmn_bond_register_pkg has been added
757:
758: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
759: but without validation for the balances.
760: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
761: associated register id , if yes , then validation is only based on bond expiry date .
762:
763: Dependency Introduced Due to this Bug : -
764: This fix has introduced huge dependency . All future changes in this object should have this bug as a prereq

Line 2567: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;

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
2571: v_trip_id wsh_delivery_trips_v.trip_id%type;