APPS.JAI_CMN_BOND_REGISTER_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 29: from JAI_OM_OE_BOND_REG_HDRS hdr,

25: is
26: cursor c_get_register is
27: select hdr.register_id ,
28: bond_number ,hdr.register_code
29: from JAI_OM_OE_BOND_REG_HDRS hdr,
30: JAI_OM_OE_BOND_REG_DTLS dtl
31: where hdr.register_id = dtl.register_id
32: and hdr.organization_id = p_organization_id
33: and hdr.location_id = p_location_id

Line 39: v_bond_number JAI_OM_OE_BOND_REG_HDRS.bond_number%type;

35: and dtl.order_type_id = p_order_invoice_id;
36:
37: v_register_id Number;
38: v_bond_id Number;
39: v_bond_number JAI_OM_OE_BOND_REG_HDRS.bond_number%type;
40: v_reg_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
41:
42: lv_object_name VARCHAR2(61); -- := '.'; /* Added by Ramananda for bug#4407165 */
43:

Line 40: v_reg_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;

36:
37: v_register_id Number;
38: v_bond_id Number;
39: v_bond_number JAI_OM_OE_BOND_REG_HDRS.bond_number%type;
40: v_reg_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
41:
42: lv_object_name VARCHAR2(61); -- := '.'; /* Added by Ramananda for bug#4407165 */
43:
44: begin

Line 77: from JAI_OM_OE_BOND_REG_HDRS hdr

73: is
74: cursor c_get_register_details is
75: select hdr.register_id ,
76: hdr.bond_expiry_date, hdr.lou_flag , register_code
77: from JAI_OM_OE_BOND_REG_HDRS hdr
78: where hdr.register_id = p_register_id;
79:
80: Cursor c_get_bond_register_balance is
81: Select register_balance

Line 104: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;

100: v_register_id Number;
101: v_register_balance Number;
102: v_expiry_date Date;
103: v_lou_flag Varchar2(1);
104: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
105: lv_object_name VARCHAR2(61); -- := '.'; /* Added by Ramananda for bug#4407165 */
106:
107: begin
108: