667: ) is
668:
669:
670: l_trans_rec_count integer default 0;
671: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
672: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
673: ln_index number default 0;
674: l_trans_step_rows NUMBER ;
675: l_adv_search_data varchar2(4000);
668:
669:
670: l_trans_rec_count integer default 0;
671: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
672: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
673: ln_index number default 0;
674: l_trans_step_rows NUMBER ;
675: l_adv_search_data varchar2(4000);
676:
835: ) is
836:
837:
838: l_trans_rec_count integer default 0;
839: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
840: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
841: ln_index number default 0;
842: l_trans_step_rows NUMBER ;
843: l_add_enroll_detail_data varchar2(4000);
836:
837:
838: l_trans_rec_count integer default 0;
839: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
840: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
841: ln_index number default 0;
842: l_trans_step_rows NUMBER ;
843: l_add_enroll_detail_data varchar2(4000);
844: l_trans_step_id number;
1099: ,p_review_data out nocopy varchar2
1100: ) is
1101:
1102:
1103: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
1104: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
1105: ln_index number default 0;
1106: l_trans_step_rows NUMBER ;
1107: l_review_data varchar2(4000);
1100: ) is
1101:
1102:
1103: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
1104: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
1105: ln_index number default 0;
1106: l_trans_step_rows NUMBER ;
1107: l_review_data varchar2(4000);
1108: l_trans_step_id number;
2217: actid in number,
2218: funmode in varchar2,
2219: result out nocopy varchar2 ) is
2220:
2221: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
2222: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
2223: l_trans_step_rows NUMBER ;
2224: l_trans_step_id number;
2225:
2218: funmode in varchar2,
2219: result out nocopy varchar2 ) is
2220:
2221: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
2222: l_trans_obj_vers_nums hr_util_web.g_varchar2_tab_type;
2223: l_trans_step_rows NUMBER ;
2224: l_trans_step_id number;
2225:
2226: begin