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 1199: , p_project_id IN pa_projects_all.project_id%TYPE

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

Line 1232: l_project_name pa_projects_all.name%TYPE;

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

Line 1233: l_project_number pa_projects_all.segment1%TYPE;

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

Line 1295: pa_projects_all proj,

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

Line 1324: FROM pa_projects_all proj,

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

Line 1760: , p_project_id IN pa_projects_all.project_id%TYPE

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