80: -- Data Structures
81: ----------------------------------------------------------------------------
82: subtype tapv_rec_type is okl_tap_pvt.tapv_rec_type;
83: subtype tapv_tbl_type is okl_tap_pvt.tapv_tbl_type;
84: subtype tplv_rec_type is okl_tpl_pvt.tplv_rec_type;
85: subtype tplv_tbl_type is okl_tpl_pvt.tplv_tbl_type;
86:
87:
88: --------------------------------------------------------------------------------------------------
81: ----------------------------------------------------------------------------
82: subtype tapv_rec_type is okl_tap_pvt.tapv_rec_type;
83: subtype tapv_tbl_type is okl_tap_pvt.tapv_tbl_type;
84: subtype tplv_rec_type is okl_tpl_pvt.tplv_rec_type;
85: subtype tplv_tbl_type is okl_tpl_pvt.tplv_tbl_type;
86:
87:
88: --------------------------------------------------------------------------------------------------
89: PROCEDURE l_get_agent(p_user_id IN NUMBER,