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_PROJECT_CHECK_PVT dependencies on PA_PROJECTS

Line 66: (p_pa_project_id pa_projects.project_id%type)

62:
63: --needed to get the field values associated to a AMG message
64:
65: CURSOR l_amg_project_csr
66: (p_pa_project_id pa_projects.project_id%type)
67: IS
68: SELECT segment1
69: FROM pa_projects p
70: WHERE p.project_id = p_pa_project_id;

Line 69: FROM pa_projects p

65: CURSOR l_amg_project_csr
66: (p_pa_project_id pa_projects.project_id%type)
67: IS
68: SELECT segment1
69: FROM pa_projects p
70: WHERE p.project_id = p_pa_project_id;
71:
72: CURSOR l_amg_task_csr
73: (p_pa_task_id pa_tasks.task_id%type)

Line 524: (p_pa_project_id pa_projects.project_id%type)

520:
521: --needed to get the field values associated to a AMG message
522:
523: CURSOR l_amg_project_csr
524: (p_pa_project_id pa_projects.project_id%type)
525: IS
526: SELECT segment1
527: FROM pa_projects p
528: WHERE p.project_id = p_pa_project_id;

Line 527: FROM pa_projects p

523: CURSOR l_amg_project_csr
524: (p_pa_project_id pa_projects.project_id%type)
525: IS
526: SELECT segment1
527: FROM pa_projects p
528: WHERE p.project_id = p_pa_project_id;
529:
530: CURSOR l_amg_task_csr
531: (p_pa_task_id pa_tasks.task_id%type)

Line 899: FROM pa_projects

895:
896: CURSOR l_unique_project_ref_csr (p_pm_project_reference IN VARCHAR2 )
897: IS
898: SELECT 1
899: FROM pa_projects
900: WHERE pm_project_reference = p_pm_project_reference;
901:
902:
903: l_api_name CONSTANT VARCHAR2(30) := 'Check_Unique_Project_Ref_Pvt';

Line 1031: (p_pa_project_id pa_projects.project_id%type)

1027:
1028: --needed to get the field values associated to a AMG message
1029:
1030: CURSOR l_amg_project_csr
1031: (p_pa_project_id pa_projects.project_id%type)
1032: IS
1033: SELECT segment1
1034: FROM pa_projects p
1035: WHERE p.project_id = p_pa_project_id;

Line 1034: FROM pa_projects p

1030: CURSOR l_amg_project_csr
1031: (p_pa_project_id pa_projects.project_id%type)
1032: IS
1033: SELECT segment1
1034: FROM pa_projects p
1035: WHERE p.project_id = p_pa_project_id;
1036:
1037: BEGIN
1038:

Line 1436: (p_pa_project_id pa_projects.project_id%type)

1432:
1433: --needed to get the field values associated to a AMG message
1434:
1435: CURSOR l_amg_project_csr
1436: (p_pa_project_id pa_projects.project_id%type)
1437: IS
1438: SELECT segment1
1439: FROM pa_projects p
1440: WHERE p.project_id = p_pa_project_id;

Line 1439: FROM pa_projects p

1435: CURSOR l_amg_project_csr
1436: (p_pa_project_id pa_projects.project_id%type)
1437: IS
1438: SELECT segment1
1439: FROM pa_projects p
1440: WHERE p.project_id = p_pa_project_id;
1441:
1442: BEGIN
1443:

Line 1782: (p_pa_project_id pa_projects.project_id%type)

1778:
1779: --needed to get the field values associated to a AMG message
1780:
1781: CURSOR l_amg_project_csr
1782: (p_pa_project_id pa_projects.project_id%type)
1783: IS
1784: SELECT segment1
1785: FROM pa_projects p
1786: WHERE p.project_id = p_pa_project_id;

Line 1785: FROM pa_projects p

1781: CURSOR l_amg_project_csr
1782: (p_pa_project_id pa_projects.project_id%type)
1783: IS
1784: SELECT segment1
1785: FROM pa_projects p
1786: WHERE p.project_id = p_pa_project_id;
1787:
1788: CURSOR l_amg_task_csr
1789: (p_pa_task_id pa_tasks.task_id%type)

Line 1998: l_project_id pa_projects_all.project_id%type;

1994: p_in_task_rec IN pa_project_pub.task_in_rec_type,
1995: p_return_status OUT NOCOPY VARCHAR2 /*Added the nocopy check for 4537865 */
1996: ) IS
1997: --Added for Bug 5643876
1998: l_project_id pa_projects_all.project_id%type;
1999:
2000: /* Commented for Bug No 4721987
2001: CURSOR l_labor_bill_rate_org_csr (l_org_id IN NUMBER ) IS
2002: SELECT 'x' FROM

Line 2029: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa

2025:
2026: CURSOR l_job_brs_csr( l_job_rate_schdid NUMBER)
2027: IS
2028: SELECT 'x'
2029: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa
2030: WHERE bill_rate_sch_id = l_job_rate_schdid
2031: AND pa.project_id = l_project_id
2032: AND brs.job_group_id = pt.bill_job_group_id
2033: and brs.schedule_type = 'JOB'

Line 2050: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa

2046:
2047: CURSOR l_emp_brs_csr( l_emp_rate_schdid NUMBER)
2048: IS
2049: SELECT 'x'
2050: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
2051: WHERE brs.bill_rate_sch_id = l_emp_rate_schdid
2052: AND pa.project_id = l_project_id
2053: and brs.schedule_type = 'EMPLOYEE'
2054: AND ( pa.multi_currency_BILLING_flag = 'Y'

Line 2121: (p_pa_project_id pa_projects.project_id%type)

2117:
2118: --needed to get the field values associated to a AMG message
2119:
2120: CURSOR l_amg_project_csr
2121: (p_pa_project_id pa_projects.project_id%type)
2122: IS
2123: SELECT segment1
2124: FROM pa_projects p
2125: WHERE p.project_id = p_pa_project_id;

Line 2124: FROM pa_projects p

2120: CURSOR l_amg_project_csr
2121: (p_pa_project_id pa_projects.project_id%type)
2122: IS
2123: SELECT segment1
2124: FROM pa_projects p
2125: WHERE p.project_id = p_pa_project_id;
2126:
2127: CURSOR l_amg_task_csr
2128: (p_pa_task_id pa_tasks.task_id%type)

Line 2954: (p_pa_project_id pa_projects.project_id%type)

2950: --needed to get the field values associated to a AMG message
2951: -- added COMPLETION_DATE to the cursor l_amg_project_csr for ROLE BASED SECURITY
2952:
2953: CURSOR l_amg_project_csr
2954: (p_pa_project_id pa_projects.project_id%type)
2955: IS
2956: SELECT segment1, COMPLETION_DATE
2957: FROM pa_projects p
2958: WHERE p.project_id = p_pa_project_id;

Line 2957: FROM pa_projects p

2953: CURSOR l_amg_project_csr
2954: (p_pa_project_id pa_projects.project_id%type)
2955: IS
2956: SELECT segment1, COMPLETION_DATE
2957: FROM pa_projects p
2958: WHERE p.project_id = p_pa_project_id;
2959:
2960: l_amg_segment1 VARCHAR2(25);
2961: v_completion_date DATE;

Line 3091: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

3087: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3088: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3089: , p_debug_mode => 'N' -- p_debug_mode
3090: , p_object_id => p_project_id -- p_object_id
3091: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
3092: , p_project_role_id => l_project_role_id -- p_project_role_id
3093: , p_project_role_type => 'PROJECT MANAGER' -- p_project_role_type
3094: , p_resource_type_id => l_current_project_man_rec.resource_type_id -- p_resource_type_id
3095: , p_resource_source_id => l_current_project_man_rec.person_id -- p_resource_source_id

Line 3177: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE

3173: , p_validate_only => FND_API.G_FALSE -- p_validate_only
3174: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
3175: , p_debug_mode => 'N' -- p_debug_mode
3176: , p_object_id => p_project_id -- p_object_id
3177: , p_OBJECT_TYPE => 'PA_PROJECTS' -- p_OBJECT_TYPE
3178: , p_project_role_id => l_project_role_id -- p_project_role_id
3179: , p_project_role_type => 'PROJECT MANAGER' -- p_project_role_type
3180: , p_resource_type_id => l_current_project_man_rec.resource_type_id -- p_resource_type_id
3181: , p_resource_source_id => l_current_project_man_rec.person_id -- p_resource_source_id

Line 3263: (p_pa_project_id pa_projects.project_id%type)

3259:
3260: --needed to get the field values associated to a AMG message
3261:
3262: CURSOR l_amg_project_csr
3263: (p_pa_project_id pa_projects.project_id%type)
3264: IS
3265: SELECT segment1
3266: FROM pa_projects p
3267: WHERE p.project_id = p_pa_project_id;

Line 3266: FROM pa_projects p

3262: CURSOR l_amg_project_csr
3263: (p_pa_project_id pa_projects.project_id%type)
3264: IS
3265: SELECT segment1
3266: FROM pa_projects p
3267: WHERE p.project_id = p_pa_project_id;
3268:
3269: l_amg_segment1 VARCHAR2(25);
3270: l_amg_task_number VARCHAR2(50);

Line 3478: (p_pa_project_id pa_projects.project_id%type)

3474:
3475: --needed to get the field values associated to a AMG message
3476:
3477: CURSOR l_amg_project_csr
3478: (p_pa_project_id pa_projects.project_id%type)
3479: IS
3480: SELECT segment1
3481: FROM pa_projects p
3482: WHERE p.project_id = p_pa_project_id;

Line 3481: FROM pa_projects p

3477: CURSOR l_amg_project_csr
3478: (p_pa_project_id pa_projects.project_id%type)
3479: IS
3480: SELECT segment1
3481: FROM pa_projects p
3482: WHERE p.project_id = p_pa_project_id;
3483:
3484: CURSOR l_amg_task_csr
3485: (p_pa_task_id pa_tasks.task_id%type)