DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROJ_ELEM_VER_SCHEDULE_S

Line 7438: pa_proj_elem_ver_schedule_s.nextval

7434: ,source_object_id
7435: ,source_object_type
7436: )
7437: SELECT
7438: pa_proj_elem_ver_schedule_s.nextval
7439: ,ppev1.ELEMENT_VERSION_ID
7440: ,p_dest_project_id
7441: ,ppev1.PROJ_ELEMENT_ID
7442: ,SYSDATE

Line 9619: pa_proj_elem_ver_schedule_s.nextval

9615: ,EXT_REMAIN_DURATION
9616: ,EXT_SCH_DURATION --Bug 3762437
9617: )
9618: SELECT
9619: pa_proj_elem_ver_schedule_s.nextval
9620: ,ppev.ELEMENT_VERSION_ID
9621: ,p_dest_PROJECT_ID
9622: ,ppev.PROJ_ELEMENT_ID
9623: ,SYSDATE

Line 12688: pa_proj_elem_ver_schedule_s.nextval

12684: ,EXT_REMAIN_DURATION
12685: ,EXT_SCH_DURATION --Bug 3762437
12686: )
12687: SELECT
12688: pa_proj_elem_ver_schedule_s.nextval
12689: ,ppev1.ELEMENT_VERSION_ID
12690: ,p_dest_PROJECT_ID
12691: ,ppev1.PROJ_ELEMENT_ID
12692: ,SYSDATE

Line 16041: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;

16037: -- l_ver_sch_attr_rec (only for update task)
16038:
16039: DECLARE
16040: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16041: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16042: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16043: l_task_type_id pa_proj_elements.type_id%TYPE;
16044: BEGIN
16045:

Line 16042: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;

16038:
16039: DECLARE
16040: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16041: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16042: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16043: l_task_type_id pa_proj_elements.type_id%TYPE;
16044: BEGIN
16045:
16046: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

Line 20407: pa_proj_elem_ver_schedule sch,

20403: sch.duration,
20404: ptt.prog_entry_enable_flag
20405: from pa_proj_element_versions ver,
20406: pa_object_relationships rel,
20407: pa_proj_elem_ver_schedule sch,
20408: pa_proj_elements ele,
20409: pa_task_types ptt,
20410: pji_xbs_plans_v pxpv
20411: -- pji_fm_xbs_accum_tmp1 pfxat