eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PDI_API dependencies on GHR_PD_ROUTING_HISTORY

Line 73: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;

69: l_proc varchar2(72) := g_package||'create_pdi';
70: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
71: l_pdi_object_version_number number := 1;
72: /* Added by Dinkar. Karumuri to support workflow and routing of Position description*/
73: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
74: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
75: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;

Line 74: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;

70: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
71: l_pdi_object_version_number number := 1;
72: /* Added by Dinkar. Karumuri to support workflow and routing of Position description*/
73: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
74: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
75: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;

Line 75: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;

71: l_pdi_object_version_number number := 1;
72: /* Added by Dinkar. Karumuri to support workflow and routing of Position description*/
73: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
74: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
75: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;

Line 76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;

72: /* Added by Dinkar. Karumuri to support workflow and routing of Position description*/
73: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
74: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
75: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
80: l_user_name_employee_id per_people_f.person_id%TYPE;

Line 77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;

73: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
74: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
75: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
80: l_user_name_employee_id per_people_f.person_id%TYPE;
81: l_user_name_emp_first_name per_people_f.first_name%TYPE;

Line 78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;

74: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
75: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
80: l_user_name_employee_id per_people_f.person_id%TYPE;
81: l_user_name_emp_first_name per_people_f.first_name%TYPE;
82: l_user_name_emp_last_name per_people_f.last_name%TYPE;

Line 79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;

75: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
80: l_user_name_employee_id per_people_f.person_id%TYPE;
81: l_user_name_emp_first_name per_people_f.first_name%TYPE;
82: l_user_name_emp_last_name per_people_f.last_name%TYPE;
83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

Line 84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;

80: l_user_name_employee_id per_people_f.person_id%TYPE;
81: l_user_name_emp_first_name per_people_f.first_name%TYPE;
82: l_user_name_emp_last_name per_people_f.last_name%TYPE;
83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
85: l_forward_to_name ghr_groupboxes.name%TYPE;
86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;
88: l_action_taken ghr_pd_routing_history.action_taken%TYPE;

Line 86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;

82: l_user_name_emp_last_name per_people_f.last_name%TYPE;
83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
85: l_forward_to_name ghr_groupboxes.name%TYPE;
86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;
88: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
89: l_item_key ghr_pd_routing_history.item_key%TYPE;
90: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;

Line 87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;

83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
85: l_forward_to_name ghr_groupboxes.name%TYPE;
86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;
88: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
89: l_item_key ghr_pd_routing_history.item_key%TYPE;
90: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
91: -- Need to Make sure that we need this Cursor.

Line 88: l_action_taken ghr_pd_routing_history.action_taken%TYPE;

84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
85: l_forward_to_name ghr_groupboxes.name%TYPE;
86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;
88: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
89: l_item_key ghr_pd_routing_history.item_key%TYPE;
90: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
91: -- Need to Make sure that we need this Cursor.
92: -- Open Issue is what do we use instead of effective_date.

Line 89: l_item_key ghr_pd_routing_history.item_key%TYPE;

85: l_forward_to_name ghr_groupboxes.name%TYPE;
86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;
88: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
89: l_item_key ghr_pd_routing_history.item_key%TYPE;
90: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
91: -- Need to Make sure that we need this Cursor.
92: -- Open Issue is what do we use instead of effective_date.
93: /* Cursor C_user_emp_names is

Line 90: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;

86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;
88: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
89: l_item_key ghr_pd_routing_history.item_key%TYPE;
90: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
91: -- Need to Make sure that we need this Cursor.
92: -- Open Issue is what do we use instead of effective_date.
93: /* Cursor C_user_emp_names is
94: select usr.employee_id,

Line 129: from ghr_pd_routing_history pdh

125: where rlm.routing_list_id = p_2_routing_list_id
126: order by rlm.seq_number asc;
127: Cursor c_history_exists is
128: select 1
129: from ghr_pd_routing_history pdh
130: where pdh.position_description_id = l_position_description_id;
131: Cursor c_groupbox_name is
132: select gbx.name
133: from ghr_groupboxes gbx

Line 613: l_u_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;

609: IS
610: l_pdi_object_version_number number;
611: l_proc varchar2(72) := g_package||'Update_pdi';
612: l_routing_grp_id ghr_position_descriptions.routing_group_id%TYPE;
613: l_u_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
614: l_i_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;
617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;

Line 614: l_i_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;

610: l_pdi_object_version_number number;
611: l_proc varchar2(72) := g_package||'Update_pdi';
612: l_routing_grp_id ghr_position_descriptions.routing_group_id%TYPE;
613: l_u_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
614: l_i_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;
617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;

Line 615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;

611: l_proc varchar2(72) := g_package||'Update_pdi';
612: l_routing_grp_id ghr_position_descriptions.routing_group_id%TYPE;
613: l_u_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
614: l_i_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;
617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;
619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;

Line 616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;

612: l_routing_grp_id ghr_position_descriptions.routing_group_id%TYPE;
613: l_u_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
614: l_i_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;
617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;
619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;

Line 617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;

613: l_u_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
614: l_i_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;
617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;
619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;

Line 618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;

614: l_i_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;
617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;
619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;

Line 619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;

615: l_u_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;
617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;
619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;

Line 620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;

616: l_initial_u_pdh_ovn ghr_pd_routing_history.object_version_number%TYPE;
617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;
619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;

Line 621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;

617: l_i_pdh_object_version_number ghr_pd_routing_history.object_version_number%TYPE;
618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;
619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
625: l_user_name_employee_id per_people_f.person_id%TYPE;

Line 622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;

618: l_initial_pdi_ovn ghr_pd_routing_history.object_version_number%TYPE;
619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
625: l_user_name_employee_id per_people_f.person_id%TYPE;
626: l_user_name_emp_first_name per_people_f.first_name%TYPE;

Line 623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;

619: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
625: l_user_name_employee_id per_people_f.person_id%TYPE;
626: l_user_name_emp_first_name per_people_f.first_name%TYPE;
627: l_user_name_emp_last_name per_people_f.last_name%TYPE;

Line 624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;

620: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
625: l_user_name_employee_id per_people_f.person_id%TYPE;
626: l_user_name_emp_first_name per_people_f.first_name%TYPE;
627: l_user_name_emp_last_name per_people_f.last_name%TYPE;
628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

Line 629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;

625: l_user_name_employee_id per_people_f.person_id%TYPE;
626: l_user_name_emp_first_name per_people_f.first_name%TYPE;
627: l_user_name_emp_last_name per_people_f.last_name%TYPE;
628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
632: l_next_groupbox_name ghr_groupboxes.name%TYPE;
633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;

Line 630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;

626: l_user_name_emp_first_name per_people_f.first_name%TYPE;
627: l_user_name_emp_last_name per_people_f.last_name%TYPE;
628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
632: l_next_groupbox_name ghr_groupboxes.name%TYPE;
633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;

Line 631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;

627: l_user_name_emp_last_name per_people_f.last_name%TYPE;
628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
632: l_next_groupbox_name ghr_groupboxes.name%TYPE;
633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;
635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;

Line 633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;

629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
632: l_next_groupbox_name ghr_groupboxes.name%TYPE;
633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;
635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
636: l_old_action_taken ghr_pd_routing_history.action_taken%TYPE;
637: l_forward_to_name ghr_pd_routing_history.user_name%type;

Line 634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;

630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
632: l_next_groupbox_name ghr_groupboxes.name%TYPE;
633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;
635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
636: l_old_action_taken ghr_pd_routing_history.action_taken%TYPE;
637: l_forward_to_name ghr_pd_routing_history.user_name%type;
638: l_cnt_history number;

Line 635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;

631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
632: l_next_groupbox_name ghr_groupboxes.name%TYPE;
633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;
635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
636: l_old_action_taken ghr_pd_routing_history.action_taken%TYPE;
637: l_forward_to_name ghr_pd_routing_history.user_name%type;
638: l_cnt_history number;
639: l_dummy ghr_pd_routing_history.action_taken%TYPE;

Line 636: l_old_action_taken ghr_pd_routing_history.action_taken%TYPE;

632: l_next_groupbox_name ghr_groupboxes.name%TYPE;
633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;
635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
636: l_old_action_taken ghr_pd_routing_history.action_taken%TYPE;
637: l_forward_to_name ghr_pd_routing_history.user_name%type;
638: l_cnt_history number;
639: l_dummy ghr_pd_routing_history.action_taken%TYPE;
640: l_pd_initiated boolean;

Line 637: l_forward_to_name ghr_pd_routing_history.user_name%type;

633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;
635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
636: l_old_action_taken ghr_pd_routing_history.action_taken%TYPE;
637: l_forward_to_name ghr_pd_routing_history.user_name%type;
638: l_cnt_history number;
639: l_dummy ghr_pd_routing_history.action_taken%TYPE;
640: l_pd_initiated boolean;
641: l_exists boolean;

Line 639: l_dummy ghr_pd_routing_history.action_taken%TYPE;

635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
636: l_old_action_taken ghr_pd_routing_history.action_taken%TYPE;
637: l_forward_to_name ghr_pd_routing_history.user_name%type;
638: l_cnt_history number;
639: l_dummy ghr_pd_routing_history.action_taken%TYPE;
640: l_pd_initiated boolean;
641: l_exists boolean;
642: l_item_key ghr_pd_routing_history.item_key%TYPE;
643: l_reclass_direct_flag varchar2(1) := 'N';

Line 642: l_item_key ghr_pd_routing_history.item_key%TYPE;

638: l_cnt_history number;
639: l_dummy ghr_pd_routing_history.action_taken%TYPE;
640: l_pd_initiated boolean;
641: l_exists boolean;
642: l_item_key ghr_pd_routing_history.item_key%TYPE;
643: l_reclass_direct_flag varchar2(1) := 'N';
644: l_reclass_action_taken ghr_pd_routing_history.action_taken%TYPE;
645: l_last_item_key ghr_pd_routing_history.item_key%TYPE;
646:

Line 644: l_reclass_action_taken ghr_pd_routing_history.action_taken%TYPE;

640: l_pd_initiated boolean;
641: l_exists boolean;
642: l_item_key ghr_pd_routing_history.item_key%TYPE;
643: l_reclass_direct_flag varchar2(1) := 'N';
644: l_reclass_action_taken ghr_pd_routing_history.action_taken%TYPE;
645: l_last_item_key ghr_pd_routing_history.item_key%TYPE;
646:
647: CURSOR c_cnt_history is
648: SELECT count(*) cnt

Line 645: l_last_item_key ghr_pd_routing_history.item_key%TYPE;

641: l_exists boolean;
642: l_item_key ghr_pd_routing_history.item_key%TYPE;
643: l_reclass_direct_flag varchar2(1) := 'N';
644: l_reclass_action_taken ghr_pd_routing_history.action_taken%TYPE;
645: l_last_item_key ghr_pd_routing_history.item_key%TYPE;
646:
647: CURSOR c_cnt_history is
648: SELECT count(*) cnt
649: FROM ghr_pd_routing_history pdh

Line 649: FROM ghr_pd_routing_history pdh

645: l_last_item_key ghr_pd_routing_history.item_key%TYPE;
646:
647: CURSOR c_cnt_history is
648: SELECT count(*) cnt
649: FROM ghr_pd_routing_history pdh
650: WHERE pdh.position_description_id = p_position_description_id;
651:
652: CURSOR c_routing_history_id is
653: SELECT pdh.pd_routing_history_id,

Line 657: FROM ghr_pd_routing_history pdh

653: SELECT pdh.pd_routing_history_id,
654: pdh.object_version_number,
655: pdh.action_taken,
656: pdh.item_key
657: FROM ghr_pd_routing_history pdh
658: WHERE pdh.position_description_id = p_position_description_id
659: ORDER BY pdh.pd_routing_history_id desc;
660:
661: CURSOR c_routing_grp_id is

Line 695: from ghr_pd_routing_history pdh

691: AND per.effective_end_date;
692:
693: cursor cur_rout_list_used is
694: select pdh.routing_seq_number
695: from ghr_pd_routing_history pdh
696: where pdh.position_description_id = p_position_description_id
697: and pdh.routing_list_id = p_i_routing_list_id
698: order by pdh.pd_routing_history_id desc;
699: cursor cur_next_rout_seq is

Line 709: from ghr_pd_routing_history pdh

705: and rlm.seq_number > l_cur_seq_numb
706: order by rlm.seq_number asc;
707: cursor c_history_exists is
708: select action_taken
709: from ghr_pd_routing_history pdh
710: where pdh.position_description_id = p_position_description_id
711: order by pd_routing_history_id;
712:
713: cursor c_pd_initiated is

Line 716: from ghr_pd_routing_history pdh

712:
713: cursor c_pd_initiated is
714:
715: select action_taken
716: from ghr_pd_routing_history pdh
717: where pdh.position_description_id = p_position_description_id
718: and action_taken = 'INITIATED';
719:
720: cursor c_groupbox_name is

Line 1315: p_action_taken IN ghr_pd_routing_history.action_taken%TYPE

1311:
1312: procedure call_workflow
1313: (
1314: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
1315: p_action_taken IN ghr_pd_routing_history.action_taken%TYPE
1316: )
1317: is
1318: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
1319: l_pdi_object_version_number number := 1;

Line 1320: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;

1316: )
1317: is
1318: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
1319: l_pdi_object_version_number number := 1;
1320: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
1321: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;

Line 1321: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;

1317: is
1318: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
1319: l_pdi_object_version_number number := 1;
1320: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
1321: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;

Line 1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;

1318: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
1319: l_pdi_object_version_number number := 1;
1320: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
1321: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;

Line 1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;

1319: l_pdi_object_version_number number := 1;
1320: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
1321: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
1327: l_user_name_employee_id per_people_f.person_id%TYPE;

Line 1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;

1320: l_initiator_flag ghr_pd_routing_history.initiator_flag%TYPE;
1321: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
1327: l_user_name_employee_id per_people_f.person_id%TYPE;
1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;

Line 1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;

1321: l_reviewer_flag ghr_pd_routing_history.reviewer_flag%TYPE;
1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
1327: l_user_name_employee_id per_people_f.person_id%TYPE;
1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;

Line 1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;

1322: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
1327: l_user_name_employee_id per_people_f.person_id%TYPE;
1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

Line 1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;

1327: l_user_name_employee_id per_people_f.person_id%TYPE;
1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
1332: l_forward_to_name ghr_groupboxes.name%TYPE;
1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;
1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;

Line 1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;

1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
1332: l_forward_to_name ghr_groupboxes.name%TYPE;
1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;
1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;
1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;
1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;

Line 1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;

1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
1332: l_forward_to_name ghr_groupboxes.name%TYPE;
1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;
1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;
1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;
1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;
1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;

Line 1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;

1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
1332: l_forward_to_name ghr_groupboxes.name%TYPE;
1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;
1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;
1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;
1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;
1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;
1339: l_item_key_2 ghr_pd_routing_history.item_key%TYPE;

Line 1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;

1332: l_forward_to_name ghr_groupboxes.name%TYPE;
1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;
1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;
1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;
1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;
1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;
1339: l_item_key_2 ghr_pd_routing_history.item_key%TYPE;
1340: l_pd_routing_history_id_1 ghr_pd_routing_history.pd_routing_history_id%TYPE;

Line 1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;

1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;
1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;
1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;
1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;
1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;
1339: l_item_key_2 ghr_pd_routing_history.item_key%TYPE;
1340: l_pd_routing_history_id_1 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1341: l_pd_routing_history_id_2 ghr_pd_routing_history.pd_routing_history_id%TYPE;

Line 1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;

1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;
1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;
1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;
1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;
1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;
1339: l_item_key_2 ghr_pd_routing_history.item_key%TYPE;
1340: l_pd_routing_history_id_1 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1341: l_pd_routing_history_id_2 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1342: l_cnt_history number;

Line 1339: l_item_key_2 ghr_pd_routing_history.item_key%TYPE;

1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;
1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;
1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;
1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;
1339: l_item_key_2 ghr_pd_routing_history.item_key%TYPE;
1340: l_pd_routing_history_id_1 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1341: l_pd_routing_history_id_2 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1342: l_cnt_history number;
1343: l_reclass_direct_flag varchar2(1) := 'N';

Line 1340: l_pd_routing_history_id_1 ghr_pd_routing_history.pd_routing_history_id%TYPE;

1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;
1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;
1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;
1339: l_item_key_2 ghr_pd_routing_history.item_key%TYPE;
1340: l_pd_routing_history_id_1 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1341: l_pd_routing_history_id_2 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1342: l_cnt_history number;
1343: l_reclass_direct_flag varchar2(1) := 'N';
1344: l_groupbox_id_1 ghr_pd_routing_history.groupbox_id%TYPE;

Line 1341: l_pd_routing_history_id_2 ghr_pd_routing_history.pd_routing_history_id%TYPE;

1337: l_last_action_taken_2 ghr_pd_routing_history.action_taken%TYPE;
1338: l_item_key_1 ghr_pd_routing_history.item_key%TYPE;
1339: l_item_key_2 ghr_pd_routing_history.item_key%TYPE;
1340: l_pd_routing_history_id_1 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1341: l_pd_routing_history_id_2 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1342: l_cnt_history number;
1343: l_reclass_direct_flag varchar2(1) := 'N';
1344: l_groupbox_id_1 ghr_pd_routing_history.groupbox_id%TYPE;
1345: l_groupbox_id_2 ghr_pd_routing_history.groupbox_id%TYPE;

Line 1344: l_groupbox_id_1 ghr_pd_routing_history.groupbox_id%TYPE;

1340: l_pd_routing_history_id_1 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1341: l_pd_routing_history_id_2 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1342: l_cnt_history number;
1343: l_reclass_direct_flag varchar2(1) := 'N';
1344: l_groupbox_id_1 ghr_pd_routing_history.groupbox_id%TYPE;
1345: l_groupbox_id_2 ghr_pd_routing_history.groupbox_id%TYPE;
1346: l_proc varchar2(72) := g_package||'call_work_flow';
1347: l_pd_initiated BOOLEAN;
1348: l_dummy varchar2(1);

Line 1345: l_groupbox_id_2 ghr_pd_routing_history.groupbox_id%TYPE;

1341: l_pd_routing_history_id_2 ghr_pd_routing_history.pd_routing_history_id%TYPE;
1342: l_cnt_history number;
1343: l_reclass_direct_flag varchar2(1) := 'N';
1344: l_groupbox_id_1 ghr_pd_routing_history.groupbox_id%TYPE;
1345: l_groupbox_id_2 ghr_pd_routing_history.groupbox_id%TYPE;
1346: l_proc varchar2(72) := g_package||'call_work_flow';
1347: l_pd_initiated BOOLEAN;
1348: l_dummy varchar2(1);
1349: Cursor c_history_exists is

Line 1351: from ghr_pd_routing_history pdh

1347: l_pd_initiated BOOLEAN;
1348: l_dummy varchar2(1);
1349: Cursor c_history_exists is
1350: select 1
1351: from ghr_pd_routing_history pdh
1352: where pdh.position_description_id = p_position_description_id;
1353: Cursor c_groupbox_name is
1354: select gbx.name
1355: from ghr_groupboxes gbx

Line 1362: from ghr_pd_routing_history pdh

1358: select ghr_pd_wf_item_key_s.nextval
1359: from dual;
1360: cursor c_cnt_history is
1361: select count(*) cnt
1362: from ghr_pd_routing_history pdh
1363: where pdh.position_description_id = p_position_description_id;
1364: Cursor C_routing_history_id is
1365: select pdh.pd_routing_history_id,
1366: pdh.action_taken,

Line 1370: from ghr_pd_routing_history pdh

1366: pdh.action_taken,
1367: pdh.item_key,
1368: pdh.groupbox_id,
1369: pdh.user_name
1370: from ghr_pd_routing_history pdh
1371: where pdh.position_description_id = p_position_description_id
1372: order by pdh.pd_routing_history_id desc;
1373: cursor c_routing_grp_id is
1374: select pdi.routing_group_id

Line 1379: from ghr_pd_routing_history pdh

1375: from ghr_position_descriptions pdi
1376: where pdi.position_description_id = p_position_description_id;
1377: cursor c_pd_initiated is
1378: select 'X'
1379: from ghr_pd_routing_history pdh
1380: where pdh.position_description_id = p_position_description_id
1381: and action_taken in ( 'INITIATED','AUTHORIZED','REQUESTED','CLASSIFIED');
1382:
1383: begin