APPS.GHR_WGI_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 113: l_1_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;

109: l_value VARCHAR2 (30);
110: l_multiple_error_flag BOOLEAN;
111: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
112: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
113: l_1_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
114: l_1_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
115: l_2_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
116: l_2_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
117: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

Line 115: l_2_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;

111: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
112: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
113: l_1_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
114: l_1_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
115: l_2_pa_routing_history_id ghr_pa_routing_history.routing_seq_number%TYPE;
116: l_2_prh_object_version_number ghr_pa_requests.object_version_number%TYPE;
117: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
118: l_validate BOOLEAN;
119: l_u_attachment_modified_flag VARCHAR2 (30);

Line 121: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;

117: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
118: l_validate BOOLEAN;
119: l_u_attachment_modified_flag VARCHAR2 (30);
120: l_u_approved_flag VARCHAR2 (30);
121: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
122: l_u_action_taken ghr_pa_routing_history.action_taken%TYPE
123: := 'NOT_ROUTED';
124: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
125: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

Line 122: l_u_action_taken ghr_pa_routing_history.action_taken%TYPE

118: l_validate BOOLEAN;
119: l_u_attachment_modified_flag VARCHAR2 (30);
120: l_u_approved_flag VARCHAR2 (30);
121: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
122: l_u_action_taken ghr_pa_routing_history.action_taken%TYPE
123: := 'NOT_ROUTED';
124: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
125: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
126: l_i_routing_list_id NUMBER;

Line 124: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;

120: l_u_approved_flag VARCHAR2 (30);
121: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
122: l_u_action_taken ghr_pa_routing_history.action_taken%TYPE
123: := 'NOT_ROUTED';
124: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
125: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
126: l_i_routing_list_id NUMBER;
127: l_i_routing_seq_number NUMBER;
128: l_u_prh_object_version_number NUMBER;

Line 125: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

121: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
122: l_u_action_taken ghr_pa_routing_history.action_taken%TYPE
123: := 'NOT_ROUTED';
124: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
125: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
126: l_i_routing_list_id NUMBER;
127: l_i_routing_seq_number NUMBER;
128: l_u_prh_object_version_number NUMBER;
129: l_i_pa_routing_history_id NUMBER;

Line 2339: FROM ghr_pa_requests pr, ghr_pa_routing_history prh

2335: CURSOR csr_action_taken
2336: IS
2337: SELECT pr.pa_request_id,
2338: MAX (pa_routing_history_id) pa_routing_history_id
2339: FROM ghr_pa_requests pr, ghr_pa_routing_history prh
2340: WHERE pr.pa_request_id = prh.pa_request_id
2341: AND person_id = p_person_id
2342: AND (first_noa_code = p_first_noa_code OR first_noa_code = '888'
2343: )

Line 2351: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

2347: -- vtakru Apr 17, 98 vtakru
2348: -- and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
2349: GROUP BY pr.pa_request_id;
2350:
2351: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2352: BEGIN
2353: FOR v_action_taken IN csr_action_taken
2354: LOOP
2355: SELECT NVL (action_taken, ' ')

Line 2357: FROM ghr_pa_routing_history

2353: FOR v_action_taken IN csr_action_taken
2354: LOOP
2355: SELECT NVL (action_taken, ' ')
2356: INTO l_action_taken
2357: FROM ghr_pa_routing_history
2358: WHERE pa_routing_history_id = v_action_taken.pa_routing_history_id;
2359:
2360: IF l_action_taken <> 'CANCELED'
2361: THEN