DBA Data[Home] [Help]

APPS.PA_LIFECYCLES_PVT dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 357: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_PROJ_ELEM_VER_SCHEDULE..');

353: );
354: END IF;
355:
356: IF(p_debug_mode = 'Y') THEN
357: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_PROJ_ELEM_VER_SCHEDULE..');
358: END IF;
359:
360: SELECT PA_PROJ_ELEM_VER_SCHEDULE_S.NEXTVAL
361: INTO l_pev_sched_id

Line 360: SELECT PA_PROJ_ELEM_VER_SCHEDULE_S.NEXTVAL

356: IF(p_debug_mode = 'Y') THEN
357: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_PROJ_ELEM_VER_SCHEDULE..');
358: END IF;
359:
360: SELECT PA_PROJ_ELEM_VER_SCHEDULE_S.NEXTVAL
361: INTO l_pev_sched_id
362: FROM dual;
363:
364:

Line 713: SELECT PA_PROJ_ELEM_VER_SCHEDULE_S.NEXTVAL

709: IF(p_debug_mode = 'Y') THEN
710: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining pev_schedule_id...');
711: END IF;
712:
713: SELECT PA_PROJ_ELEM_VER_SCHEDULE_S.NEXTVAL
714: INTO l_pev_sched_id
715: FROM dual;
716:
717: IF(p_debug_mode = 'Y') THEN

Line 899: FROM pa_proj_elem_ver_schedule

895:
896: CURSOR l_row_proj_elem_ver_schedule
897: IS
898: SELECT rowid
899: FROM pa_proj_elem_ver_schedule
900: WHERE proj_element_id = P_lifecycle_id
901: AND element_version_id = l_element_version_id
902: AND project_id = c_project_id;
903:

Line 1232: From pa_proj_elem_ver_schedule

1228:
1229: CURSOR l_row_proj_elem_ver_schedule
1230: IS
1231: Select rowid
1232: From pa_proj_elem_ver_schedule
1233: Where proj_element_id = P_phase_id
1234: AND element_version_id = l_element_version_id
1235: AND project_id = c_project_id;
1236: