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 151: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%TYPE ; -- bug # 3021588

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

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

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

Line 233: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

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
232: SELECT A.register_code
233: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
234: WHERE A.organization_id = p_organization_id
235: AND A.location_id = p_location_id
236: AND A.register_id = b.register_id
237: AND b.order_flag = 'Y'

Line 260: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

256: CURSOR register_balance_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
257: SELECT register_balance
258: FROM JAI_OM_OE_BOND_TRXS
259: WHERE transaction_id = (SELECT MAX(A.transaction_id)
260: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
261: WHERE A.register_id = B.register_id
262: AND B.organization_id = p_organization_id
263: AND B.location_id = p_location_id);
264:

Line 324: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

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

Line 726: 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.

722:
723: For Multiple Bond Register Enhancement,
724: Instead of using the cursors for fetching the register associated with the order type , a call has been made to the procedures
725: of the jai_cmn_bond_register_pkg package. There enhancement has created dependency because of the
726: 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.
727:
728: 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
729:
730: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register

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

728: 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
729:
730: Provision for letter of undertaking has been incorporated. In the case of the letter of undetaking , its also a type of bond register
731: but without validation for the balances.
732: This has been done by checking if the LOU_FLAG is 'Y' in the JAI_OM_OE_BOND_REG_HDRS table for the
733: associated register id , if yes , then validation is only based on bond expiry date .
734:
735: Dependency Introduced Due to this Bug : -
736: This fix has introduced huge dependency . All future changes in this object should have this bug as a prereq

Line 2438: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;

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