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

Line 188: from pa_projects_all

184: l_id_found_flag VARCHAR2(1) := 'N';
185:
186: cursor c IS
187: select project_id
188: from pa_projects_all
189: where UPPER(name) = UPPER(p_project_name);
190:
191: BEGIN
192: IF (p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

Line 219: FROM pa_projects_all

215: -- ID is not empty;
216: IF (p_check_id_flag = 'Y') THEN
217: SELECT project_id
218: INTO x_project_id
219: FROM pa_projects_all
220: WHERE project_id = p_project_id;
221: ELSIF (p_check_id_flag = 'N') THEN
222: x_project_id := p_project_id;
223: ELSIF (p_check_id_flag = 'A') THEN

Line 502: from pa_projects_all

498:
499: --select project start date
500: select start_date, completion_date
501: into l_start_date, l_end_date
502: from pa_projects_all
503: where project_id = p_project_id;
504: IF (p_start_date IS NOT NULL and
505: l_start_date > p_start_date) THEN
506: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

Line 551: from pa_projects_all

547:
548: -- Bug Start 6163119
549: select start_date, completion_date
550: into l_pstart_date, l_pend_date
551: from pa_projects_all
552: where project_id = p_project_id;
553:
554: select max(start_date),
555: min(completion_date)

Line 686: from pa_projects_all

682: IF (p_parent_task_id IS NULL) THEN -- TOP TASK, compare with project
683: --select project completion date
684: select start_date, completion_date
685: into l_start_date, l_end_date
686: from pa_projects_all
687: where project_id = p_project_id;
688: IF (p_end_date IS NOT NULL and
689: l_end_date < p_end_date) THEN
690: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

Line 735: from pa_projects_all

731:
732: -- Bug Start 6163119
733: select start_date, completion_date
734: into l_pstart_date, l_pend_date
735: from pa_projects_all
736: where project_id = p_project_id;
737:
738: select max(start_date),
739: min(completion_date)

Line 833: where org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the where condition for bug#3512486

829: -- MOAC Changes: Bug 4363092: removed nvl with org_id
830: CURSOR c1 IS
831: select nvl(cc_ic_billing_recvr_flag, 'N')
832: from pa_implementations_all -- Modified pa_implementations to pa_implementations_all for bug#3512486
833: where org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the where condition for bug#3512486
834:
835: -- MOAC Changes: Bug 4363092: removed nvl with org_id
836: CURSOR c2 IS
837: select nvl(cc_prvdr_flag, 'N')

Line 840: and org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the and condition for bug#3512486

836: CURSOR c2 IS
837: select nvl(cc_prvdr_flag, 'N')
838: from pa_project_types_all -- Modified pa_project_types to pa_project_types_all for bug#3512486
839: where project_type = p_project_type
840: and org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the and condition for bug#3512486
841:
842: l_c1_flag VARCHAR2(1);
843: l_c2_flag VARCHAR2(2);
844: BEGIN

Line 877: from pa_projects_all

873: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
874: IS
875: CURSOR c1 IS
876: select SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE
877: from pa_projects_all
878: where project_id = p_project_id;
879:
880: l_start_date DATE;
881: l_finish_date DATE;

Line 1052: FROM PA_PROJECTS_ALL

1048: IS
1049: l_org_id NUMBER;
1050: BEGIN
1051: SELECT org_id INTO l_org_id
1052: FROM PA_PROJECTS_ALL
1053: WHERE project_id = p_project_id;
1054:
1055: END SET_ORG_ID;
1056:

Line 1423: FROM PA_PROJECTS_ALL PPA

1419: ,PPA.WORK_TYPE_ID
1420: ,PWT.NAME WORK_TYPE_NAME
1421: ,PPT.SERVICE_TYPE_CODE
1422: ,PL.MEANING SERVICE_TYPE_NAME
1423: FROM PA_PROJECTS_ALL PPA
1424: ,HR_ORGANIZATION_UNITS HOU
1425: ,PA_WORK_TYPES_TL PWT
1426: ,PA_LOOKUPS PL
1427: ,PA_PROJECT_TYPES_ALL PPT

Line 2066: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

2062: IF p_validate_only <> FND_API.G_TRUE
2063: THEN
2064: BEGIN
2065: SELECT 'x' INTO l_dummy_char
2066: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2067: FROM pa_proj_elem_ver_structure
2068: WHERE project_id = p_project_id
2069: AND wbs_record_version_number = p_wbs_record_version_number
2070: FOR UPDATE OF record_version_number NOWAIT;

Line 2102: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

2098: END;
2099: ELSE
2100: BEGIN
2101: SELECT 'x' INTO l_dummy_char
2102: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2103: FROM pa_proj_elem_ver_structure
2104: WHERE project_id = p_project_id
2105: AND wbs_record_version_number = p_wbs_record_version_number;
2106: EXCEPTION

Line 2153: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure

2149: BEGIN
2150: x_return_status := 'S';
2151:
2152: /* increment wbs_record_version_number for project id */
2153: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2154: UPDATE pa_proj_elem_ver_structure
2155: SET wbs_record_version_number = NVL( wbs_record_version_number, 0 ) + 1
2156: WHERE project_id = p_project_id
2157: AND wbs_record_version_number = p_wbs_record_version_number;