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 488: from pa_projects_all

484:
485: --select project start date
486: select start_date, completion_date
487: into l_start_date, l_end_date
488: from pa_projects_all
489: where project_id = p_project_id;
490: IF (p_start_date IS NOT NULL and
491: l_start_date > p_start_date) THEN
492: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

Line 526: from pa_projects_all

522:
523: -- Bug Start 6163119
524: select start_date, completion_date
525: into l_pstart_date, l_pend_date
526: from pa_projects_all
527: where project_id = p_project_id;
528:
529: select max(start_date),
530: min(completion_date)

Line 647: from pa_projects_all

643: IF (p_parent_task_id IS NULL) THEN -- TOP TASK, compare with project
644: --select project completion date
645: select start_date, completion_date
646: into l_start_date, l_end_date
647: from pa_projects_all
648: where project_id = p_project_id;
649: IF (p_end_date IS NOT NULL and
650: l_end_date < p_end_date) THEN
651: -- PA_UTILS.ADD_MESSAGE('PA', 'PA_TK_OUTSIDE_PROJECT_RANGE');

Line 684: from pa_projects_all

680:
681: -- Bug Start 6163119
682: select start_date, completion_date
683: into l_pstart_date, l_pend_date
684: from pa_projects_all
685: where project_id = p_project_id;
686:
687: select max(start_date),
688: min(completion_date)

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

778: -- MOAC Changes: Bug 4363092: removed nvl with org_id
779: CURSOR c1 IS
780: select nvl(cc_ic_billing_recvr_flag, 'N')
781: from pa_implementations_all -- Modified pa_implementations to pa_implementations_all for bug#3512486
782: where org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the where condition for bug#3512486
783:
784: -- MOAC Changes: Bug 4363092: removed nvl with org_id
785: CURSOR c2 IS
786: select nvl(cc_prvdr_flag, 'N')

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

785: CURSOR c2 IS
786: select nvl(cc_prvdr_flag, 'N')
787: from pa_project_types_all -- Modified pa_project_types to pa_project_types_all for bug#3512486
788: where project_type = p_project_type
789: and org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the and condition for bug#3512486
790:
791: l_c1_flag VARCHAR2(1);
792: l_c2_flag VARCHAR2(2);
793: BEGIN

Line 826: from pa_projects_all

822: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
823: IS
824: CURSOR c1 IS
825: select SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE
826: from pa_projects_all
827: where project_id = p_project_id;
828:
829: l_start_date DATE;
830: l_finish_date DATE;

Line 1001: FROM PA_PROJECTS_ALL

997: IS
998: l_org_id NUMBER;
999: BEGIN
1000: SELECT org_id INTO l_org_id
1001: FROM PA_PROJECTS_ALL
1002: WHERE project_id = p_project_id;
1003:
1004: END SET_ORG_ID;
1005:

Line 1372: FROM PA_PROJECTS_ALL PPA

1368: ,PPA.WORK_TYPE_ID
1369: ,PWT.NAME WORK_TYPE_NAME
1370: ,PPT.SERVICE_TYPE_CODE
1371: ,PL.MEANING SERVICE_TYPE_NAME
1372: FROM PA_PROJECTS_ALL PPA
1373: ,HR_ORGANIZATION_UNITS HOU
1374: ,PA_WORK_TYPES_TL PWT
1375: ,PA_LOOKUPS PL
1376: ,PA_PROJECT_TYPES_ALL PPT

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

2011: IF p_validate_only <> FND_API.G_TRUE
2012: THEN
2013: BEGIN
2014: SELECT 'x' INTO l_dummy_char
2015: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2016: FROM pa_proj_elem_ver_structure
2017: WHERE project_id = p_project_id
2018: AND wbs_record_version_number = p_wbs_record_version_number
2019: FOR UPDATE OF record_version_number NOWAIT;

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

2047: END;
2048: ELSE
2049: BEGIN
2050: SELECT 'x' INTO l_dummy_char
2051: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2052: FROM pa_proj_elem_ver_structure
2053: WHERE project_id = p_project_id
2054: AND wbs_record_version_number = p_wbs_record_version_number;
2055: EXCEPTION

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

2098: BEGIN
2099: x_return_status := 'S';
2100:
2101: /* increment wbs_record_version_number for project id */
2102: -- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
2103: UPDATE pa_proj_elem_ver_structure
2104: SET wbs_record_version_number = NVL( wbs_record_version_number, 0 ) + 1
2105: WHERE project_id = p_project_id
2106: AND wbs_record_version_number = p_wbs_record_version_number;