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_ADVERTISEMENTS_PVT dependencies on PA_PROJECTS_ALL

Line 863: , p_project_id IN pa_projects_all.project_id%TYPE

859: , p_object_id IN pa_action_sets.object_id%TYPE
860: , p_action_code IN pa_action_set_lines.action_code%TYPE
861: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
862: , p_email_address IN VARCHAR2
863: , p_project_id IN pa_projects_all.project_id%TYPE
864: , p_insert_audit_flag IN VARCHAR2 := 'T'
865: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
866: ) IS
867:

Line 1200: , p_project_id IN pa_projects_all.project_id%TYPE

1196: , p_wf_user_name IN VARCHAR2 := NULL
1197: , p_wf_process IN VARCHAR2
1198: , p_wf_item_type IN VARCHAR2 := 'PARADVWF'
1199: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1200: , p_project_id IN pa_projects_all.project_id%TYPE
1201: , p_insert_audit_flag IN VARCHAR2 := 'T'
1202: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1203: ) IS
1204:

Line 1233: l_project_name pa_projects_all.name%TYPE;

1229: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1230: l_staffing_priority_name VARCHAR2(80);
1231: l_description pa_project_assignments.description%TYPE;
1232: l_additional_information pa_project_assignments.additional_information%TYPE;
1233: l_project_name pa_projects_all.name%TYPE;
1234: l_project_number pa_projects_all.segment1%TYPE;
1235: l_project_organization HR_ALL_ORGANIZATION_UNITS.name%TYPE;
1236: -- 4363092 TCA changes, replaced RA views with HZ tables
1237: --l_project_customer RA_CUSTOMERS.customer_name%TYPE;

Line 1234: l_project_number pa_projects_all.segment1%TYPE;

1230: l_staffing_priority_name VARCHAR2(80);
1231: l_description pa_project_assignments.description%TYPE;
1232: l_additional_information pa_project_assignments.additional_information%TYPE;
1233: l_project_name pa_projects_all.name%TYPE;
1234: l_project_number pa_projects_all.segment1%TYPE;
1235: l_project_organization HR_ALL_ORGANIZATION_UNITS.name%TYPE;
1236: -- 4363092 TCA changes, replaced RA views with HZ tables
1237: --l_project_customer RA_CUSTOMERS.customer_name%TYPE;
1238: l_project_customer hz_parties.party_name%TYPE;

Line 1296: pa_projects_all proj,

1292: wt.name,
1293: asgn.transfer_price_rate, -- Added for bug 3051110
1294: asgn.transfer_pr_rate_curr
1295: FROM pa_project_assignments asgn,
1296: pa_projects_all proj,
1297: pa_project_role_types prt,
1298: pa_lookups sp,
1299: pa_lookups fcst,
1300: pa_work_types_v wt

Line 1325: FROM pa_projects_all proj,

1321: hou.name,
1322: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(proj.project_id),
1323: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME,
1324: PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(proj.project_id)
1325: FROM pa_projects_all proj,
1326: HR_ALL_ORGANIZATION_UNITS HOU
1327: WHERE proj.project_id = p_project_id
1328: AND proj.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID;
1329:

Line 1761: , p_project_id IN pa_projects_all.project_id%TYPE

1757: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
1758: , p_object_id IN pa_action_sets.object_id%TYPE
1759: , p_action_code IN pa_action_set_lines.action_code%TYPE
1760: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
1761: , p_project_id IN pa_projects_all.project_id%TYPE
1762: , p_insert_audit_flag IN VARCHAR2 := 'T'
1763: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1764: ) IS
1765: