9635:
9636:
9637: BEGIN
9638:
9639: if hxc_abs_retrieval_pkg.g_tk_ret_messages.count > 0 then
9640:
9641: p_employee_full_name:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9642: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).employee_name;
9643:
9637: BEGIN
9638:
9639: if hxc_abs_retrieval_pkg.g_tk_ret_messages.count > 0 then
9640:
9641: p_employee_full_name:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9642: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).employee_name;
9643:
9644: p_message:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9645: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).message_name;
9638:
9639: if hxc_abs_retrieval_pkg.g_tk_ret_messages.count > 0 then
9640:
9641: p_employee_full_name:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9642: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).employee_name;
9643:
9644: p_message:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9645: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).message_name;
9646:
9640:
9641: p_employee_full_name:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9642: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).employee_name;
9643:
9644: p_message:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9645: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).message_name;
9646:
9647: hxc_abs_retrieval_pkg.g_tk_ret_messages.DELETE(hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST);
9648:
9641: p_employee_full_name:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9642: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).employee_name;
9643:
9644: p_message:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9645: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).message_name;
9646:
9647: hxc_abs_retrieval_pkg.g_tk_ret_messages.DELETE(hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST);
9648:
9649: p_no_data:='N';
9643:
9644: p_message:= hxc_abs_retrieval_pkg.g_tk_ret_messages
9645: (hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST).message_name;
9646:
9647: hxc_abs_retrieval_pkg.g_tk_ret_messages.DELETE(hxc_abs_retrieval_pkg.g_tk_ret_messages.FIRST);
9648:
9649: p_no_data:='N';
9650:
9651: else