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.PA_ASGMT_WFSTD dependencies on WF_USERS

Line 40: ,p_in_performers_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp

36: ,p_item_type IN VARCHAR2
37: ,p_item_key IN VARCHAR2
38: ,p_object_id1 IN VARCHAR2
39: ,p_object_id2 IN VARCHAR2
40: ,p_in_performers_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp
41: ,p_current_approver_flag IN VARCHAR2
42: ,x_number_of_performers OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
43:
44: PROCEDURE get_wf_performer (p_wf_type_code IN VARCHAR2,

Line 209: l_display_name wf_users.display_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

205: l_wf_started_by_id NUMBER;
206: l_wf_started_by_full_name per_people_f.full_name%TYPE;
207: l_wf_started_by_email_address per_people_f.email_address%TYPE;
208: l_wf_started_by_username fnd_user.user_name%TYPE;
209: l_display_name wf_users.display_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
210: l_project_manager_person_id NUMBER ;
211: l_project_manager_name per_all_people_f.full_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
212: l_project_manager_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
213: l_project_party_id NUMBER ;

Line 212: l_project_manager_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

208: l_wf_started_by_username fnd_user.user_name%TYPE;
209: l_display_name wf_users.display_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
210: l_project_manager_person_id NUMBER ;
211: l_project_manager_name per_all_people_f.full_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
212: l_project_manager_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
213: l_project_party_id NUMBER ;
214: l_project_role_id NUMBER ;
215: l_project_role_name pa_project_role_types.meaning%TYPE; ---- VARCHAR2(80); Changed for bug 3267790
216: l_approver1_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

Line 216: l_approver1_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

212: l_project_manager_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
213: l_project_party_id NUMBER ;
214: l_project_role_id NUMBER ;
215: l_project_role_name pa_project_role_types.meaning%TYPE; ---- VARCHAR2(80); Changed for bug 3267790
216: l_approver1_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
217: l_approver2_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
218: l_approver1_type VARCHAR2(200);
219: l_approver2_type VARCHAR2(200);
220: l_apprvl_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

Line 217: l_approver2_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

213: l_project_party_id NUMBER ;
214: l_project_role_id NUMBER ;
215: l_project_role_name pa_project_role_types.meaning%TYPE; ---- VARCHAR2(80); Changed for bug 3267790
216: l_approver1_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
217: l_approver2_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
218: l_approver1_type VARCHAR2(200);
219: l_approver2_type VARCHAR2(200);
220: l_apprvl_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
221: l_apprvl_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

Line 220: l_apprvl_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

216: l_approver1_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
217: l_approver2_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
218: l_approver1_type VARCHAR2(200);
219: l_approver2_type VARCHAR2(200);
220: l_apprvl_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
221: l_apprvl_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
222: l_apprvl_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
223: l_apprvl_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
224: l_apprvl_nf_rec1_utype VARCHAR2(30);

Line 221: l_apprvl_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

217: l_approver2_user_name wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
218: l_approver1_type VARCHAR2(200);
219: l_approver2_type VARCHAR2(200);
220: l_apprvl_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
221: l_apprvl_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
222: l_apprvl_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
223: l_apprvl_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
224: l_apprvl_nf_rec1_utype VARCHAR2(30);
225: l_apprvl_nf_rec2_utype VARCHAR2(30);

Line 222: l_apprvl_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

218: l_approver1_type VARCHAR2(200);
219: l_approver2_type VARCHAR2(200);
220: l_apprvl_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
221: l_apprvl_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
222: l_apprvl_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
223: l_apprvl_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
224: l_apprvl_nf_rec1_utype VARCHAR2(30);
225: l_apprvl_nf_rec2_utype VARCHAR2(30);
226: l_apprvl_nf_rec3_utype VARCHAR2(30);

Line 223: l_apprvl_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

219: l_approver2_type VARCHAR2(200);
220: l_apprvl_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
221: l_apprvl_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
222: l_apprvl_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
223: l_apprvl_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
224: l_apprvl_nf_rec1_utype VARCHAR2(30);
225: l_apprvl_nf_rec2_utype VARCHAR2(30);
226: l_apprvl_nf_rec3_utype VARCHAR2(30);
227: l_apprvl_nf_rec4_utype VARCHAR2(30);

Line 233: l_reject_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

229: l_apprvl_nf_rec2_person_id NUMBER := 0;
230: l_apprvl_nf_rec3_person_id NUMBER := 0;
231: l_apprvl_nf_rec4_person_id NUMBER := 0;
232:
233: l_reject_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
234: l_reject_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
235: l_reject_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
236: l_reject_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
237: l_reject_nf_rec1_utype VARCHAR2(30);

Line 234: l_reject_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

230: l_apprvl_nf_rec3_person_id NUMBER := 0;
231: l_apprvl_nf_rec4_person_id NUMBER := 0;
232:
233: l_reject_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
234: l_reject_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
235: l_reject_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
236: l_reject_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
237: l_reject_nf_rec1_utype VARCHAR2(30);
238: l_reject_nf_rec2_utype VARCHAR2(30);

Line 235: l_reject_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

231: l_apprvl_nf_rec4_person_id NUMBER := 0;
232:
233: l_reject_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
234: l_reject_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
235: l_reject_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
236: l_reject_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
237: l_reject_nf_rec1_utype VARCHAR2(30);
238: l_reject_nf_rec2_utype VARCHAR2(30);
239: l_reject_nf_rec3_utype VARCHAR2(30);

Line 236: l_reject_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

232:
233: l_reject_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
234: l_reject_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
235: l_reject_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
236: l_reject_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
237: l_reject_nf_rec1_utype VARCHAR2(30);
238: l_reject_nf_rec2_utype VARCHAR2(30);
239: l_reject_nf_rec3_utype VARCHAR2(30);
240: l_reject_nf_rec4_utype VARCHAR2(30);

Line 246: l_cancel_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

242: l_reject_nf_rec2_person_id NUMBER := 0;
243: l_reject_nf_rec3_person_id NUMBER := 0;
244: l_reject_nf_rec4_person_id NUMBER := 0;
245:
246: l_cancel_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
247: l_cancel_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
248: l_cancel_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
249: l_cancel_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
250: l_cancel_nf_rec1_utype VARCHAR2(30);

Line 247: l_cancel_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

243: l_reject_nf_rec3_person_id NUMBER := 0;
244: l_reject_nf_rec4_person_id NUMBER := 0;
245:
246: l_cancel_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
247: l_cancel_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
248: l_cancel_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
249: l_cancel_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
250: l_cancel_nf_rec1_utype VARCHAR2(30);
251: l_cancel_nf_rec2_utype VARCHAR2(30);

Line 248: l_cancel_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

244: l_reject_nf_rec4_person_id NUMBER := 0;
245:
246: l_cancel_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
247: l_cancel_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
248: l_cancel_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
249: l_cancel_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
250: l_cancel_nf_rec1_utype VARCHAR2(30);
251: l_cancel_nf_rec2_utype VARCHAR2(30);
252: l_cancel_nf_rec3_utype VARCHAR2(30);

Line 249: l_cancel_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

245:
246: l_cancel_nf_rec1_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
247: l_cancel_nf_rec2_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
248: l_cancel_nf_rec3_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
249: l_cancel_nf_rec4_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
250: l_cancel_nf_rec1_utype VARCHAR2(30);
251: l_cancel_nf_rec2_utype VARCHAR2(30);
252: l_cancel_nf_rec3_utype VARCHAR2(30);
253: l_cancel_nf_rec4_utype VARCHAR2(30);

Line 282: l_primarycontactname wf_users.name%TYPE; ---- VARCHAR2(240); Changed for bug 3267790

278: l_msg_index_out NUMBER ;
279: l_msg_data VARCHAR2(2000);
280: l_data VARCHAR2(2000);
281: l_primarycontactid NUMBER := 0;
282: l_primarycontactname wf_users.name%TYPE; ---- VARCHAR2(240); Changed for bug 3267790
283: l_resource_start_date DATE;
284:
285: -- 4363092 TCA changes, replaced RA views with HZ tables
286: /*

Line 2145: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2141: , actid IN NUMBER
2142: , funcmode IN VARCHAR2
2143: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2144:
2145: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2146: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2147: l_number_of_approvers NUMBER := 0;
2148: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2149: l_assignment_id pa_project_assignments.assignment_id%TYPE;

Line 2146: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2142: , funcmode IN VARCHAR2
2143: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2144:
2145: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2146: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2147: l_number_of_approvers NUMBER := 0;
2148: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2149: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2150: l_project_id pa_projects_all.project_id%TYPE;

Line 2148: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2144:
2145: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2146: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2147: l_number_of_approvers NUMBER := 0;
2148: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2149: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2150: l_project_id pa_projects_all.project_id%TYPE;
2151: l_approver_user_name wf_users.name%type; ----- VARCHAR2(30); Commented for bug 3267790 VARCHAR2(100);
2152: /* Modified length from 30 to 100 for bug 3148857 */

Line 2151: l_approver_user_name wf_users.name%type; ----- VARCHAR2(30); Commented for bug 3267790 VARCHAR2(100);

2147: l_number_of_approvers NUMBER := 0;
2148: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2149: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2150: l_project_id pa_projects_all.project_id%TYPE;
2151: l_approver_user_name wf_users.name%type; ----- VARCHAR2(30); Commented for bug 3267790 VARCHAR2(100);
2152: /* Modified length from 30 to 100 for bug 3148857 */
2153: l_approver_person_id NUMBER := 0;
2154: l_approver_type VARCHAR2(30);
2155: l_item_attr_name VARCHAR2(30);

Line 2256: l_prev_approver_user_name wf_users.name%TYPE; ----VARCHAR2(240); Commented for bug 3267790 as this takes the value from wf_users

2252: l_number_of_approvers NUMBER := 0;
2253: l_approver_loop_counter NUMBER := 0;
2254: l_approver_item_attr_name VARCHAR2(30);
2255: l_approver_user_name pa_wf_ntf_performers.user_name%TYPE; ----VARCHAR2(240); Commented for bug 3267790
2256: l_prev_approver_user_name wf_users.name%TYPE; ----VARCHAR2(240); Commented for bug 3267790 as this takes the value from wf_users
2257: l_approver_type VARCHAR2(30);
2258: l_assignment_id NUMBER;
2259: l_wf_startedby_uname fnd_user.user_name%type;
2260:

Line 2395: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2391: , actid IN NUMBER
2392: , funcmode IN VARCHAR2
2393: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2394:
2395: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2396: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2397: l_number_of_recipients NUMBER := 0;
2398: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2399: l_assignment_id pa_project_assignments.assignment_id%TYPE;

Line 2396: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2392: , funcmode IN VARCHAR2
2393: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2394:
2395: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2396: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2397: l_number_of_recipients NUMBER := 0;
2398: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2399: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2400: l_project_id pa_projects_all.project_id%TYPE;

Line 2398: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2394:
2395: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2396: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2397: l_number_of_recipients NUMBER := 0;
2398: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2399: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2400: l_project_id pa_projects_all.project_id%TYPE;
2401: l_approval_nf_rect_username VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */
2402: l_rect_person_id NUMBER := 0;

Line 2408: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790

2404: l_item_attr_name VARCHAR2(30);
2405: l_number_of_apprvl_nf_rects NUMBER := 0;
2406: l_approval_nf_loop_counter NUMBER := 0;
2407: l_ntfy_rect_item_attr_name VARCHAR2(30);
2408: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790
2409: l_ntfy_apprvl_rect_person_id NUMBER := 0;
2410: l_ntfy_apprvl_rect_type VARCHAR2(30);
2411: l_apprvl_item_type VARCHAR2(30);
2412: l_apprvl_item_key VARCHAR2(30);

Line 2635: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2631: , itemkey IN VARCHAR2
2632: , actid IN NUMBER
2633: , funcmode IN VARCHAR2
2634: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2635: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2636: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2637: l_number_of_recipients NUMBER := 0;
2638: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2639: l_assignment_id pa_project_assignments.assignment_id%TYPE;

Line 2636: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2632: , actid IN NUMBER
2633: , funcmode IN VARCHAR2
2634: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2635: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2636: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2637: l_number_of_recipients NUMBER := 0;
2638: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2639: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2640: l_project_id pa_projects_all.project_id%TYPE;

Line 2638: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2634: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2635: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2636: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2637: l_number_of_recipients NUMBER := 0;
2638: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2639: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2640: l_project_id pa_projects_all.project_id%TYPE;
2641: l_reject_nf_rect_username wf_users.name%type; ---VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */ -- Changed for bug 3267790
2642: l_rect_person_id NUMBER := 0;

Line 2641: l_reject_nf_rect_username wf_users.name%type; ---VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */ -- Changed for bug 3267790

2637: l_number_of_recipients NUMBER := 0;
2638: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2639: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2640: l_project_id pa_projects_all.project_id%TYPE;
2641: l_reject_nf_rect_username wf_users.name%type; ---VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */ -- Changed for bug 3267790
2642: l_rect_person_id NUMBER := 0;
2643: l_recipient_type VARCHAR2(30);
2644: l_item_attr_name VARCHAR2(30);
2645: l_number_of_reject_nf_rects NUMBER := 0;

Line 2648: l_ntfy_reject_recipient_name wf_users.name%type; ----- VARCHAR2(240);Changed for bug 3267790

2644: l_item_attr_name VARCHAR2(30);
2645: l_number_of_reject_nf_rects NUMBER := 0;
2646: l_reject_nf_loop_counter NUMBER := 0;
2647: l_ntfy_rect_item_attr_name VARCHAR2(30);
2648: l_ntfy_reject_recipient_name wf_users.name%type; ----- VARCHAR2(240);Changed for bug 3267790
2649: l_ntfy_reject_rect_person_id NUMBER := 0;
2650: l_ntfy_reject_rect_type VARCHAR2(30);
2651: l_apprvl_item_type VARCHAR2(30);
2652: l_apprvl_item_key VARCHAR2(30);

Line 2873: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2869: , itemkey IN VARCHAR2
2870: , actid IN NUMBER
2871: , funcmode IN VARCHAR2
2872: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2873: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2874: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2875: l_number_of_recipients NUMBER := 0;
2876: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2877: l_assignment_id pa_project_assignments.assignment_id%TYPE;

Line 2874: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2870: , actid IN NUMBER
2871: , funcmode IN VARCHAR2
2872: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2873: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2874: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2875: l_number_of_recipients NUMBER := 0;
2876: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2877: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2878: l_project_id pa_projects_all.project_id%TYPE;

Line 2876: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2872: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2873: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2874: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2875: l_number_of_recipients NUMBER := 0;
2876: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2877: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2878: l_project_id pa_projects_all.project_id%TYPE;
2879: l_cancel_nf_rect_username wf_users.name%type; ----- VARCHAR2(30);Changed for bug 3267790
2880: --VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */

Line 2879: l_cancel_nf_rect_username wf_users.name%type; ----- VARCHAR2(30);Changed for bug 3267790

2875: l_number_of_recipients NUMBER := 0;
2876: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2877: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2878: l_project_id pa_projects_all.project_id%TYPE;
2879: l_cancel_nf_rect_username wf_users.name%type; ----- VARCHAR2(30);Changed for bug 3267790
2880: --VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */
2881: l_rect_person_id NUMBER := 0;
2882: l_recipient_type VARCHAR2(30);
2883: l_item_attr_name VARCHAR2(30);

Line 2887: l_ntfy_cancel_recipient_name wf_users.name%type; --- VARCHAR2(240);Changed for bug 3267790

2883: l_item_attr_name VARCHAR2(30);
2884: l_number_of_cancel_nf_rects NUMBER := 0;
2885: l_cancel_nf_loop_counter NUMBER := 0;
2886: l_ntfy_rect_item_attr_name VARCHAR2(30);
2887: l_ntfy_cancel_recipient_name wf_users.name%type; --- VARCHAR2(240);Changed for bug 3267790
2888: l_ntfy_cancel_rect_person_id NUMBER := 0;
2889: l_ntfy_cancel_rect_type VARCHAR2(30);
2890: l_apprvl_item_type VARCHAR2(30);
2891: l_apprvl_item_key VARCHAR2(30);

Line 3122: l_forwarded_from wf_users.name%type; ----- VARCHAR2(240); Changed for bug 3267790

3118: , itemkey IN VARCHAR2
3119: , actid IN NUMBER
3120: , funcmode IN VARCHAR2
3121: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
3122: l_forwarded_from wf_users.name%type; ----- VARCHAR2(240); Changed for bug 3267790
3123: BEGIN
3124:
3125: -- Return if WF Not Running
3126: IF (funcmode <> wf_engine.eng_run) THEN

Line 3441: l_submitter_uname wf_users.name%type; --- VARCHAR2(100); Changed for bug 3267790

3437: l_msg_data VARCHAR2(500);
3438: l_record_version_number NUMBER := 0;
3439: l_out_record_version_number NUMBER := 0;
3440: l_conflict_group_id NUMBER;
3441: l_submitter_uname wf_users.name%type; --- VARCHAR2(100); Changed for bug 3267790
3442: /* Modified length from 30 to 100 for bug 3148857 */
3443: NO_ASSIGNMENT_ID EXCEPTION;
3444:
3445: CURSOR l_get_record_version_csr IS

Line 3556: l_approver_user_name wf_users.name%type; ----- VARCHAR2(240);Changed for bug 3267790

3552: , funcmode IN VARCHAR2
3553: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3554: IS
3555: l_comment VARCHAR2(4000); --VARCHAR2(2000); Bug 7459451 : Changed the length to accomodate max length returned by wf_engine.getItemAttrText
3556: l_approver_user_name wf_users.name%type; ----- VARCHAR2(240);Changed for bug 3267790
3557: /* Modified length from 30 to 100 for bug 3148857 */
3558: l_assignment_id NUMBER;
3559: l_wf_context_user pa_wf_ntf_performers.user_name%TYPE;
3560: l_reassignee_user_name pa_wf_ntf_performers.user_name%TYPE;

Line 3945: ,p_in_performers_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp

3941: ,p_item_type IN VARCHAR2
3942: ,p_item_key IN VARCHAR2
3943: ,p_object_id1 IN VARCHAR2
3944: ,p_object_id2 IN VARCHAR2
3945: ,p_in_performers_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp
3946: ,p_current_approver_flag IN VARCHAR2
3947: ,x_number_of_performers OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
3948: IS
3949: l_number_of_performers NUMBER := 0;

Line 4794: l_display_name wf_users.display_name%TYPE; ---VARCHAR2(200); Changed for bug 3267790

4790: l_wf_process VARCHAR2(2000):= 'PA_MASS_APRVL_RES_FP';
4791: l_err_code NUMBER := 0;
4792: l_err_stage VARCHAR2(2000);
4793: l_err_stack VARCHAR2(2000);
4794: l_display_name wf_users.display_name%TYPE; ---VARCHAR2(200); Changed for bug 3267790
4795: l_approver_name VARCHAR2(200);
4796: l_resource_id NUMBER;
4797: --l_res_user_name VARCHAR2(200);
4798: l_msg_subj_code VARCHAR2(30);

Line 4805: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

4801: l_msg_desc_text VARCHAR2(2000);
4802: l_resolve_conflicts_by_rmvl VARCHAR2(1);
4803: l_view_conflict_url VARCHAR2(2000);
4804:
4805: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4806: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4807: l_number_of_recipients NUMBER := 0;
4808: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
4809: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790

Line 4806: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

4802: l_resolve_conflicts_by_rmvl VARCHAR2(1);
4803: l_view_conflict_url VARCHAR2(2000);
4804:
4805: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4806: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4807: l_number_of_recipients NUMBER := 0;
4808: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
4809: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790
4810: l_ntfy_apprvl_rect_person_id NUMBER := 0;

Line 4808: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

4804:
4805: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4806: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4807: l_number_of_recipients NUMBER := 0;
4808: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
4809: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790
4810: l_ntfy_apprvl_rect_person_id NUMBER := 0;
4811: l_ntfy_apprvl_rect_type VARCHAR2(30);
4812: l_notification_type VARCHAR2(30);

Line 4809: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790

4805: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4806: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4807: l_number_of_recipients NUMBER := 0;
4808: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
4809: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790
4810: l_ntfy_apprvl_rect_person_id NUMBER := 0;
4811: l_ntfy_apprvl_rect_type VARCHAR2(30);
4812: l_notification_type VARCHAR2(30);
4813:

Line 5900: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

5896: l_assignment_id NUMBER;
5897: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /*Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991*/
5898: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
5899:
5900: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5901: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5902: l_number_of_recipients NUMBER := 0;
5903: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
5904: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790

Line 5901: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

5897: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /*Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991*/
5898: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
5899:
5900: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5901: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5902: l_number_of_recipients NUMBER := 0;
5903: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
5904: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790
5905: l_ntfy_apprvl_rect_person_id NUMBER := 0;

Line 5903: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

5899:
5900: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5901: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5902: l_number_of_recipients NUMBER := 0;
5903: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
5904: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790
5905: l_ntfy_apprvl_rect_person_id NUMBER := 0;
5906: l_ntfy_apprvl_rect_type VARCHAR2(30);
5907: l_notification_type VARCHAR2(30);

Line 5904: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790

5900: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5901: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5902: l_number_of_recipients NUMBER := 0;
5903: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
5904: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790
5905: l_ntfy_apprvl_rect_person_id NUMBER := 0;
5906: l_ntfy_apprvl_rect_type VARCHAR2(30);
5907: l_notification_type VARCHAR2(30);
5908:

Line 5919: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991

5915: l_project_role_name VARCHAR2(80);
5916: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not
5917: l_num_apr_asgns NUMBER ;
5918: l_num_rej_asgns NUMBER ;
5919: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5920: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5921: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5922: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5923:

Line 5920: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991

5916: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not
5917: l_num_apr_asgns NUMBER ;
5918: l_num_rej_asgns NUMBER ;
5919: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5920: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5921: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5922: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5923:
5924: CURSOR Resource_Manager IS