DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROJ_ELEM_VER_SCHEDULE_S

Line 7687: pa_proj_elem_ver_schedule_s.nextval

7683: ,source_object_id
7684: ,source_object_type
7685: )
7686: SELECT
7687: pa_proj_elem_ver_schedule_s.nextval
7688: ,ppev1.ELEMENT_VERSION_ID
7689: ,p_dest_project_id
7690: ,ppev1.PROJ_ELEMENT_ID
7691: ,SYSDATE

Line 9912: pa_proj_elem_ver_schedule_s.nextval

9908: ,EXT_REMAIN_DURATION
9909: ,EXT_SCH_DURATION --Bug 3762437
9910: )
9911: SELECT
9912: pa_proj_elem_ver_schedule_s.nextval
9913: ,ppev.ELEMENT_VERSION_ID
9914: ,p_dest_PROJECT_ID
9915: ,ppev.PROJ_ELEMENT_ID
9916: ,SYSDATE

Line 13016: pa_proj_elem_ver_schedule_s.nextval

13012: ,EXT_REMAIN_DURATION
13013: ,EXT_SCH_DURATION --Bug 3762437
13014: )
13015: SELECT
13016: pa_proj_elem_ver_schedule_s.nextval
13017: ,ppev1.ELEMENT_VERSION_ID
13018: ,p_dest_PROJECT_ID
13019: ,ppev1.PROJ_ELEMENT_ID
13020: ,SYSDATE

Line 16619: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;

16615: -- l_ver_sch_attr_rec (only for update task)
16616:
16617: DECLARE
16618: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16619: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16620: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16621: l_task_type_id pa_proj_elements.type_id%TYPE;
16622: BEGIN
16623:

Line 16620: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;

16616:
16617: DECLARE
16618: l_wq_planned_quantity pa_proj_elem_ver_schedule.wq_planned_quantity%TYPE;
16619: l_scheduled_start_date pa_proj_elem_ver_schedule.scheduled_start_date%TYPE;
16620: l_scheduled_finish_date pa_proj_elem_ver_schedule.scheduled_finish_date%TYPE;
16621: l_task_type_id pa_proj_elements.type_id%TYPE;
16622: BEGIN
16623:
16624: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

Line 21202: pa_proj_elem_ver_schedule sch,

21198: sch.duration,
21199: ptt.prog_entry_enable_flag
21200: from pa_proj_element_versions ver,
21201: pa_object_relationships rel,
21202: pa_proj_elem_ver_schedule sch,
21203: pa_proj_elements ele,
21204: pa_task_types ptt,
21205: pji_xbs_plans_v pxpv
21206: -- pji_fm_xbs_accum_tmp1 pfxat