1: PACKAGE BODY jai_cmn_bond_register_pkg
2: /* $Header: jai_cmn_bond_reg.plb 120.1 2005/07/20 12:57:03 avallabh ship $ */
3: as
4:
5: /* --------------------------------------------------------------------------------------
42: lv_object_name VARCHAR2(61); -- := '
43:
44: begin
45:
46: lv_object_name := 'jai_cmn_bond_register_pkg.get_register_id'; /* Added by Ramananda for bug#4407165 */
47:
48: open c_get_register;
49: fetch c_get_register into v_register_id , v_bond_number,v_reg_code;
50: close c_get_register;
105: lv_object_name VARCHAR2(61); -- := '
106:
107: begin
108:
109: lv_object_name := 'jai_cmn_bond_register_pkg.get_register_details'; /* Added by Ramananda for bug#4407165 */
110:
111: open c_get_register_details ;
112: fetch c_get_register_details into v_register_id,v_expiry_date,v_lou_flag , v_register_code ;
113: close c_get_register_details ;
135:
136:
137: End get_register_details;
138:
139: end jai_cmn_bond_register_pkg;