DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_CLIENT_EXTN_ASGMT_WF

Line 2822: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2818: WHERE ps.project_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
2819:
2820: l_stus_rec l_stus_csr%ROWTYPE;
2821:
2822: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2823: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2824: l_number_of_approvers NUMBER := 0;
2825: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2826: l_approver_person_id NUMBER := 0;

Line 2823: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;

2819:
2820: l_stus_rec l_stus_csr%ROWTYPE;
2821:
2822: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2823: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2824: l_number_of_approvers NUMBER := 0;
2825: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2826: l_approver_person_id NUMBER := 0;
2827:

Line 2825: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;

2821:
2822: l_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2823: l_out_approvers_list_tbl PA_CLIENT_EXTN_ASGMT_WF.Users_List_Tbltyp ;
2824: l_number_of_approvers NUMBER := 0;
2825: l_approvers_list_rec PA_CLIENT_EXTN_ASGMT_WF.Users_List_Rectyp ;
2826: l_approver_person_id NUMBER := 0;
2827:
2828: l_group_id NUMBER;
2829: l_approver_group_id NUMBER;

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

3324: END IF;
3325:
3326: ---------------------------------------------------------------------------
3327: --If no errors for this assignment then :
3328: -- i. call PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers(..) to get
3329: -- any client defined Approvers.
3330: -- ii. insert into PA_WF_NTF_PERFORMERS (insert Approvers and assignment)
3331: --Note: All the inserted records have a unique identifier Group_id
3332: -- We can recognize all the records in PA_WF_NTF_PERFORMERS

Line 3378: PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers

3374: END LOOP;--end j loop
3375:
3376: log_message('In Count:' || l_approvers_list_tbl.COUNT);
3377:
3378: PA_CLIENT_EXTN_ASGMT_WF.Generate_Assignment_Approvers
3379: (p_assignment_id => l_assignment_id_tbl(i)
3380: ,p_project_id => p_project_id
3381: ,p_in_list_of_approvers => l_approvers_list_tbl
3382: ,x_out_list_of_approvers => l_out_approvers_list_tbl