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 2266: l_prev_approver_user_name wf_users.name%TYPE; ----VARCHAR2(240); Commented for bug 3267790 as this takes the value from wf_users

2262: l_number_of_approvers NUMBER := 0;
2263: l_approver_loop_counter NUMBER := 0;
2264: l_approver_item_attr_name VARCHAR2(30);
2265: l_approver_user_name pa_wf_ntf_performers.user_name%TYPE; ----VARCHAR2(240); Commented for bug 3267790
2266: l_prev_approver_user_name wf_users.name%TYPE; ----VARCHAR2(240); Commented for bug 3267790 as this takes the value from wf_users
2267: l_approver_type VARCHAR2(30);
2268: l_assignment_id NUMBER;
2269: l_wf_startedby_uname fnd_user.user_name%type;
2270:

Line 2405: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2401: , actid IN NUMBER
2402: , funcmode IN VARCHAR2
2403: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2404:
2405: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2406: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2407: l_number_of_recipients NUMBER := 0;
2408: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2409: l_assignment_id pa_project_assignments.assignment_id%TYPE;

Line 2406: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2402: , funcmode IN VARCHAR2
2403: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2404:
2405: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2406: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2407: l_number_of_recipients NUMBER := 0;
2408: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2409: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2410: l_project_id pa_projects_all.project_id%TYPE;

Line 2408: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2404:
2405: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2406: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2407: l_number_of_recipients NUMBER := 0;
2408: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2409: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2410: l_project_id pa_projects_all.project_id%TYPE;
2411: l_approval_nf_rect_username VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */
2412: l_rect_person_id NUMBER := 0;

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

2414: l_item_attr_name VARCHAR2(30);
2415: l_number_of_apprvl_nf_rects NUMBER := 0;
2416: l_approval_nf_loop_counter NUMBER := 0;
2417: l_ntfy_rect_item_attr_name VARCHAR2(30);
2418: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790
2419: l_ntfy_apprvl_rect_person_id NUMBER := 0;
2420: l_ntfy_apprvl_rect_type VARCHAR2(30);
2421: l_apprvl_item_type VARCHAR2(30);
2422: l_apprvl_item_key VARCHAR2(30);

Line 2646: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2642: , itemkey IN VARCHAR2
2643: , actid IN NUMBER
2644: , funcmode IN VARCHAR2
2645: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2646: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2647: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2648: l_number_of_recipients NUMBER := 0;
2649: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2650: l_assignment_id pa_project_assignments.assignment_id%TYPE;

Line 2647: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2643: , actid IN NUMBER
2644: , funcmode IN VARCHAR2
2645: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2646: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2647: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2648: l_number_of_recipients NUMBER := 0;
2649: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2650: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2651: l_project_id pa_projects_all.project_id%TYPE;

Line 2649: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2645: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2646: l_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2647: l_out_reject_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2648: l_number_of_recipients NUMBER := 0;
2649: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2650: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2651: l_project_id pa_projects_all.project_id%TYPE;
2652: l_reject_nf_rect_username wf_users.name%type; ---VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */ -- Changed for bug 3267790
2653: l_rect_person_id NUMBER := 0;

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

2648: l_number_of_recipients NUMBER := 0;
2649: l_reject_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2650: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2651: l_project_id pa_projects_all.project_id%TYPE;
2652: l_reject_nf_rect_username wf_users.name%type; ---VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */ -- Changed for bug 3267790
2653: l_rect_person_id NUMBER := 0;
2654: l_recipient_type VARCHAR2(30);
2655: l_item_attr_name VARCHAR2(30);
2656: l_number_of_reject_nf_rects NUMBER := 0;

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

2655: l_item_attr_name VARCHAR2(30);
2656: l_number_of_reject_nf_rects NUMBER := 0;
2657: l_reject_nf_loop_counter NUMBER := 0;
2658: l_ntfy_rect_item_attr_name VARCHAR2(30);
2659: l_ntfy_reject_recipient_name wf_users.name%type; ----- VARCHAR2(240);Changed for bug 3267790
2660: l_ntfy_reject_rect_person_id NUMBER := 0;
2661: l_ntfy_reject_rect_type VARCHAR2(30);
2662: l_apprvl_item_type VARCHAR2(30);
2663: l_apprvl_item_key VARCHAR2(30);

Line 2888: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2884: , itemkey IN VARCHAR2
2885: , actid IN NUMBER
2886: , funcmode IN VARCHAR2
2887: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2888: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2889: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2890: l_number_of_recipients NUMBER := 0;
2891: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2892: l_assignment_id pa_project_assignments.assignment_id%TYPE;

Line 2889: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2885: , actid IN NUMBER
2886: , funcmode IN VARCHAR2
2887: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2888: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2889: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2890: l_number_of_recipients NUMBER := 0;
2891: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2892: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2893: l_project_id pa_projects_all.project_id%TYPE;

Line 2891: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2887: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2888: l_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2889: l_out_cancel_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2890: l_number_of_recipients NUMBER := 0;
2891: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2892: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2893: l_project_id pa_projects_all.project_id%TYPE;
2894: l_cancel_nf_rect_username wf_users.name%type; ----- VARCHAR2(30);Changed for bug 3267790
2895: --VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */

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

2890: l_number_of_recipients NUMBER := 0;
2891: l_cancel_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2892: l_assignment_id pa_project_assignments.assignment_id%TYPE;
2893: l_project_id pa_projects_all.project_id%TYPE;
2894: l_cancel_nf_rect_username wf_users.name%type; ----- VARCHAR2(30);Changed for bug 3267790
2895: --VARCHAR2(100); /* Modified length from 30 to 100 for bug 3148857 */
2896: l_rect_person_id NUMBER := 0;
2897: l_recipient_type VARCHAR2(30);
2898: l_item_attr_name VARCHAR2(30);

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

2898: l_item_attr_name VARCHAR2(30);
2899: l_number_of_cancel_nf_rects NUMBER := 0;
2900: l_cancel_nf_loop_counter NUMBER := 0;
2901: l_ntfy_rect_item_attr_name VARCHAR2(30);
2902: l_ntfy_cancel_recipient_name wf_users.name%type; --- VARCHAR2(240);Changed for bug 3267790
2903: l_ntfy_cancel_rect_person_id NUMBER := 0;
2904: l_ntfy_cancel_rect_type VARCHAR2(30);
2905: l_apprvl_item_type VARCHAR2(30);
2906: l_apprvl_item_key VARCHAR2(30);

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

3133: , itemkey IN VARCHAR2
3134: , actid IN NUMBER
3135: , funcmode IN VARCHAR2
3136: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
3137: l_forwarded_from wf_users.name%type; ----- VARCHAR2(240); Changed for bug 3267790
3138: BEGIN
3139:
3140: -- Return if WF Not Running
3141: IF (funcmode <> wf_engine.eng_run) THEN

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

3452: l_msg_data VARCHAR2(500);
3453: l_record_version_number NUMBER := 0;
3454: l_out_record_version_number NUMBER := 0;
3455: l_conflict_group_id NUMBER;
3456: l_submitter_uname wf_users.name%type; --- VARCHAR2(100); Changed for bug 3267790
3457: /* Modified length from 30 to 100 for bug 3148857 */
3458: NO_ASSIGNMENT_ID EXCEPTION;
3459:
3460: CURSOR l_get_record_version_csr IS

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

3567: , funcmode IN VARCHAR2
3568: , resultout OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3569: IS
3570: l_comment VARCHAR2(4000); --VARCHAR2(2000); Bug 7459451 : Changed the length to accomodate max length returned by wf_engine.getItemAttrText
3571: l_approver_user_name wf_users.name%type; ----- VARCHAR2(240);Changed for bug 3267790
3572: /* Modified length from 30 to 100 for bug 3148857 */
3573: l_assignment_id NUMBER;
3574: l_wf_context_user pa_wf_ntf_performers.user_name%TYPE;
3575: l_reassignee_user_name pa_wf_ntf_performers.user_name%TYPE;

Line 3960: ,p_in_performers_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp

3956: ,p_item_type IN VARCHAR2
3957: ,p_item_key IN VARCHAR2
3958: ,p_object_id1 IN VARCHAR2
3959: ,p_object_id2 IN VARCHAR2
3960: ,p_in_performers_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp
3961: ,p_current_approver_flag IN VARCHAR2
3962: ,x_number_of_performers OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
3963: IS
3964: l_number_of_performers NUMBER := 0;

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

4806: l_wf_process VARCHAR2(2000):= 'PA_MASS_APRVL_RES_FP';
4807: l_err_code NUMBER := 0;
4808: l_err_stage VARCHAR2(2000);
4809: l_err_stack VARCHAR2(2000);
4810: l_display_name wf_users.display_name%TYPE; ---VARCHAR2(200); Changed for bug 3267790
4811: l_approver_name VARCHAR2(200);
4812: l_resource_id NUMBER;
4813: --l_res_user_name VARCHAR2(200);
4814: l_msg_subj_code VARCHAR2(30);

Line 4821: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

4817: l_msg_desc_text VARCHAR2(2000);
4818: l_resolve_conflicts_by_rmvl VARCHAR2(1);
4819: l_view_conflict_url VARCHAR2(2000);
4820:
4821: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4822: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4823: l_number_of_recipients NUMBER := 0;
4824: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
4825: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790

Line 4822: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

4818: l_resolve_conflicts_by_rmvl VARCHAR2(1);
4819: l_view_conflict_url VARCHAR2(2000);
4820:
4821: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4822: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4823: l_number_of_recipients NUMBER := 0;
4824: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
4825: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790
4826: l_ntfy_apprvl_rect_person_id NUMBER := 0;

Line 4824: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

4820:
4821: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4822: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4823: l_number_of_recipients NUMBER := 0;
4824: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
4825: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790
4826: l_ntfy_apprvl_rect_person_id NUMBER := 0;
4827: l_ntfy_apprvl_rect_type VARCHAR2(30);
4828: l_notification_type VARCHAR2(30);

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

4821: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4822: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
4823: l_number_of_recipients NUMBER := 0;
4824: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
4825: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changed for bug 3267790
4826: l_ntfy_apprvl_rect_person_id NUMBER := 0;
4827: l_ntfy_apprvl_rect_type VARCHAR2(30);
4828: l_notification_type VARCHAR2(30);
4829:

Line 5916: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

5912: l_assignment_id NUMBER;
5913: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /*Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991*/
5914: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
5915:
5916: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5917: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5918: l_number_of_recipients NUMBER := 0;
5919: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
5920: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790

Line 5917: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

5913: l_recipients_tbl SYSTEM.pa_varchar2_240_tbl_type; /*Commented SYSTEM.pa_varchar2_30_tbl_type for the bug 3311991*/
5914: l_recipients_type_tbl SYSTEM.pa_varchar2_30_tbl_type;
5915:
5916: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5917: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5918: l_number_of_recipients NUMBER := 0;
5919: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
5920: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790
5921: l_ntfy_apprvl_rect_person_id NUMBER := 0;

Line 5919: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

5915:
5916: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5917: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5918: l_number_of_recipients NUMBER := 0;
5919: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
5920: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790
5921: l_ntfy_apprvl_rect_person_id NUMBER := 0;
5922: l_ntfy_apprvl_rect_type VARCHAR2(30);
5923: l_notification_type VARCHAR2(30);

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

5916: l_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5917: l_out_approval_nf_rects_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
5918: l_number_of_recipients NUMBER := 0;
5919: l_approval_nf_rects_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
5920: l_ntfy_apprvl_recipient_name wf_users.name%TYPE; ---VARCHAR2(240); Changer for 3267790
5921: l_ntfy_apprvl_rect_person_id NUMBER := 0;
5922: l_ntfy_apprvl_rect_type VARCHAR2(30);
5923: l_notification_type VARCHAR2(30);
5924:

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

5931: l_project_role_name VARCHAR2(80);
5932: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not
5933: l_num_apr_asgns NUMBER ;
5934: l_num_rej_asgns NUMBER ;
5935: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5936: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5937: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5938: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5939:

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

5932: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not
5933: l_num_apr_asgns NUMBER ;
5934: l_num_rej_asgns NUMBER ;
5935: l_display_name wf_users.display_name%TYPE; --VARCHAR2(360); Commented VARCHAR2(360) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5936: l_approver_name wf_users.display_name%TYPE; --VARCHAR2(320); Commented VARCHAR2(320) for bug 3267790 --Commented VARCHAR2(200) for bug 3311991
5937: l_aprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
5938: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
5939:
5940: CURSOR Resource_Manager IS