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_PROJECTS_ALL

Line 166: FROM pa_projects_all pap,

162: pap.carrying_out_organization_id carrying_out_organization_id,
163: pap.location_id,
164: hr.name organization_name,
165: NVL(pt.administrative_flag,'N') admin_flag
166: FROM pa_projects_all pap,
167: hr_all_organization_units hr,
168: pa_project_types_all pt
169: WHERE pap.project_id = l_project_id
170: AND pap.carrying_out_organization_id =

Line 2150: l_project_id pa_projects_all.project_id%TYPE;

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 */
2153: l_approver_person_id NUMBER := 0;
2154: l_approver_type VARCHAR2(30);

Line 2400: l_project_id pa_projects_all.project_id%TYPE;

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;
2403: l_recipient_type VARCHAR2(30);
2404: l_item_attr_name VARCHAR2(30);

Line 2640: l_project_id pa_projects_all.project_id%TYPE;

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;
2643: l_recipient_type VARCHAR2(30);
2644: l_item_attr_name VARCHAR2(30);

Line 2878: l_project_id pa_projects_all.project_id%TYPE;

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 */
2881: l_rect_person_id NUMBER := 0;
2882: l_recipient_type VARCHAR2(30);

Line 6011: FROM pa_projects_all pap,

6007: --Get the project type
6008: --MOAC Changes: Bug 4363092 : removed nvl usage with org_id
6009: SELECT NVL(pt.administrative_flag,'N') admin_flag
6010: INTO l_admin_project
6011: FROM pa_projects_all pap,
6012: pa_project_types_all pt
6013: WHERE pap.project_id = p_project_id
6014: AND pt.project_type = pap.project_type
6015: AND pap.org_id = pt.org_id;

Line 6947: FROM pa_projects_all pap,

6943: pap.carrying_out_organization_id carrying_out_organization_id,
6944: pap.location_id,
6945: hr.name organization_name,
6946: NVL(pt.administrative_flag,'N') admin_flag
6947: FROM pa_projects_all pap,
6948: hr_all_organization_units hr,
6949: pa_project_types_all pt
6950: WHERE pap.project_id = l_project_id
6951: AND pap.carrying_out_organization_id = hr.organization_id