DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_CLIENT_EXTN_ASGMT_WF

Line 2883: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2879: WHERE ps.project_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
2880:
2881: l_stus_rec l_stus_csr%ROWTYPE;
2882:
2883: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2884: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2885: l_number_of_approvers NUMBER := 0;
2886: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2887: l_approver_person_id NUMBER := 0;

Line 2884: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2880:
2881: l_stus_rec l_stus_csr%ROWTYPE;
2882:
2883: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2884: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2885: l_number_of_approvers NUMBER := 0;
2886: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2887: l_approver_person_id NUMBER := 0;
2888:

Line 2886: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2882:
2883: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2884: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2885: l_number_of_approvers NUMBER := 0;
2886: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2887: l_approver_person_id NUMBER := 0;
2888:
2889: l_group_id NUMBER;
2890: l_approver_group_id NUMBER;

Line 3389: -- i. call PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers(..) to get

3385: END IF;
3386:
3387: ---------------------------------------------------------------------------
3388: --If no errors for this assignment then :
3389: -- i. call PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers(..) to get
3390: -- any client defined Approvers.
3391: -- ii. insert into PA_WF_NTF_PERFORMERS (insert Approvers and assignment)
3392: --Note: All the inserted records have a unique identifier Group_id
3393: -- We can recognize all the records in PA_WF_NTF_PERFORMERS

Line 3443: PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers

3439: END LOOP;--end j loop
3440:
3441: log_message('In Count:' || l_approvers_list_tbl.COUNT);
3442:
3443: PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers
3444: (p_assignment_id => l_assignment_id_tbl(i)
3445: ,p_project_id => p_project_id
3446: ,p_in_list_of_approvers => l_approvers_list_tbl
3447: ,x_out_list_of_approvers => l_out_approvers_list_tbl