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 PA_CLIENT_EXTN_ASGMT_WF

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 1396: PA_CLIENT_EXTN_ASGMT_WF.Set_Timeout_And_Reminders

1392: );
1393:
1394: -- Call the client extensions to set the waiting period
1395: -- for reminders as well as the number of times to remind
1396: PA_CLIENT_EXTN_ASGMT_WF.Set_Timeout_And_Reminders
1397: ( p_assignment_id => l_assignments_rec.assignment_id
1398: ,p_project_id => l_projects_rec.project_id
1399: ,x_waiting_time => l_waiting_time
1400: ,x_number_of_reminders => l_number_of_reminders );

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 2208: PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers

2204: END IF;
2205: END LOOP;
2206: -- Pass the pl/sql table to the client extension so
2207: -- users can customize the approvers
2208: PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers
2209: (p_assignment_id => l_assignment_id
2210: ,p_project_id => l_project_id
2211: ,p_in_list_of_approvers => l_approvers_list_tbl
2212: ,x_out_list_of_approvers => l_out_approvers_list_tbl

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 2485: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients

2481: END LOOP;
2482: -- Pass the pl/sql table to the client extension so
2483: -- users can customize the approvers
2484:
2485: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients
2486: (p_assignment_id => l_assignment_id
2487: ,p_project_id => l_project_id
2488: ,p_notification_type => 'APPROVAL_FYI'
2489: ,p_in_list_of_recipients => l_approval_nf_rects_tbl

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 2722: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients

2718: END LOOP;
2719: -- Pass the pl/sql table to the client extension so
2720: -- users can customize the approvers
2721:
2722: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients
2723: (p_assignment_id => l_assignment_id
2724: ,p_project_id => l_project_id
2725: ,p_notification_type => 'REJECTION_FYI'
2726: ,p_in_list_of_recipients => l_reject_nf_rects_tbl

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 2971: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients

2967: END LOOP;
2968: -- Pass the pl/sql table to the client extension so
2969: -- users can customize the approvers
2970:
2971: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients
2972: (p_assignment_id => l_assignment_id
2973: ,p_project_id => l_project_id
2974: ,p_notification_type => 'CANCELLATION_FYI'
2975: ,p_in_list_of_recipients => l_cancel_nf_rects_tbl

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 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 4992: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients

4988: log_message('Before Calling client extension to get all recipients');
4989: log_message('Recipient count:' || l_approval_nf_rects_tbl.COUNT);
4990:
4991: --Calling client extension to get all recipients
4992: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients
4993: (p_assignment_id => p_assignment_id
4994: ,p_project_id => p_project_id
4995: ,p_notification_type => l_notification_type
4996: ,p_in_list_of_recipients => l_approval_nf_rects_tbl

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 6179: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients

6175:
6176: -------------------------------------------------
6177: --Calling client extension to get all recipients
6178: -------------------------------------------------
6179: PA_CLIENT_EXTN_ASGMT_WF.Generate_NF_Recipients
6180: (p_assignment_id => l_assignment_id
6181: ,p_project_id => p_project_id
6182: ,p_notification_type => l_notification_type
6183: ,p_in_list_of_recipients => l_approval_nf_rects_tbl