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 PER_ALL_PEOPLE_F

Line 211: l_project_manager_name per_all_people_f.full_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

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 ;
214: l_project_role_id NUMBER ;
215: l_project_role_name pa_project_role_types.meaning%TYPE; ---- VARCHAR2(80); Changed for bug 3267790

Line 3905: l_primarycontactname per_all_people_f.full_name%type; ----- VARCHAR2(240);Changed for bug 3267790

3901: , p_approver2_person_id IN NUMBER
3902: , p_approver2_type IN VARCHAR2
3903: , x_PrimaryContactId OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
3904: IS
3905: l_primarycontactname per_all_people_f.full_name%type; ----- VARCHAR2(240);Changed for bug 3267790
3906: l_managerid NUMBER := 0;
3907: l_managername per_all_people_f.full_name%type;----- VARCHAR2(240);Changed for bug 3267790
3908: l_return_status VARCHAR2(1);
3909: l_msg_count NUMBER ;

Line 3907: l_managername per_all_people_f.full_name%type;----- VARCHAR2(240);Changed for bug 3267790

3903: , x_PrimaryContactId OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
3904: IS
3905: l_primarycontactname per_all_people_f.full_name%type; ----- VARCHAR2(240);Changed for bug 3267790
3906: l_managerid NUMBER := 0;
3907: l_managername per_all_people_f.full_name%type;----- VARCHAR2(240);Changed for bug 3267790
3908: l_return_status VARCHAR2(1);
3909: l_msg_count NUMBER ;
3910: l_msg_data VARCHAR2(2000);
3911: BEGIN

Line 5912: l_project_manager_name per_all_people_f.full_name%TYPE; --VARCHAR2(200); Changed for bug 3267790

5908:
5909: l_res_mgr_person_id NUMBER;
5910: l_staff_mgr_person_id NUMBER;
5911: l_project_manager_person_id NUMBER ;
5912: l_project_manager_name per_all_people_f.full_name%TYPE; --VARCHAR2(200); Changed for bug 3267790
5913: l_project_party_id NUMBER ;
5914: l_project_role_id NUMBER ;
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

Line 5951: per_all_people_f per

5947: from dual) temp, */
5948: pa_project_assignments asgn,
5949: pa_wf_ntf_performers ntf,
5950: wf_roles wf,
5951: per_all_people_f per
5952: WHERE ntf.group_id = p_group_id
5953: AND asgn.assignment_id = l_assignment_id
5954: AND asgn.assignment_id = ntf.object_id1
5955: AND res.resource_id = asgn.resource_id

Line 6934: l_project_manager_name per_all_people_f.full_name%TYPE;--VARCHAR2(200); Commented For 3267790

6930:
6931: l_customer_id NUMBER;
6932: l_customer_name VARCHAR2(2000);
6933: l_project_manager_person_id NUMBER ;
6934: l_project_manager_name per_all_people_f.full_name%TYPE;--VARCHAR2(200); Commented For 3267790
6935: l_project_party_id NUMBER ;
6936: l_project_role_id NUMBER ;
6937: l_project_role_name VARCHAR2(80);
6938: