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_TASK_PVT1 dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 4886: FROM pa_proj_elem_ver_schedule

4882:
4883: CURSOR cur_sch_ver( p_task_id NUMBER, p_project_id NUMBER )
4884: IS
4885: SELECT rowid
4886: FROM pa_proj_elem_ver_schedule
4887: WHERE element_version_id = p_task_id
4888: and project_id = p_project_id;
4889:
4890: CURSOR cur_pa_projs( p_project_id NUMBER )

Line 5458: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE

5454: CLOSE cur_sch_ver;
5455: */
5456:
5457: -- Added direct delete statement
5458: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
5459: WHERE ELEMENT_VERSION_ID = cur_child_tasks_rec.object_id_to1
5460: AND PROJECT_ID = x_project_id;
5461:
5462: -- 4201927 end

Line 6088: update pa_proj_elem_ver_schedule

6084: CLOSE get_tsk_cnt;
6085:
6086: IF (l_tsk_ver_cnt = 0) THEN
6087: --set scheduled dates to sysdate
6088: update pa_proj_elem_ver_schedule
6089: set SCHEDULED_START_DATE = trunc(sysdate),
6090: SCHEDULED_FINISH_DATE = trunc(sysdate),
6091: DURATION = 1,
6092: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,

Line 6336: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6332: p_PLANNED_EQUIP_EFFORT IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --bug 3305199
6333: p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6334: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6335: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6336: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6337: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6338: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6337: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6333: p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6334: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6335: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6336: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6337: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6338: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6338: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6334: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6335: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6336: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6337: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6338: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6335: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6336: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6337: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6338: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6336: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6337: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6338: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6337: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6338: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6338: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6339: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6340: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6341: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6349: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6342: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6349: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6350: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6343: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6349: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6350: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6351: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6344: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6349: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6350: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6351: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6352:

Line 6349: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6345: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6349: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6350: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6351: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6352:
6353: --bug 3305199 schedule options

Line 6350: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6346: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6349: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6350: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6351: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6352:
6353: --bug 3305199 schedule options
6354: p_def_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6351: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

6347: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6348: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6349: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6350: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6351: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6352:
6353: --bug 3305199 schedule options
6354: p_def_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6355: p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 6431: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;

6427: l_planned_effort NUMBER;
6428: l_critical_flag VARCHAR2(1);
6429: l_milestone_flag VARCHAR2(1);
6430: -- xxlu
6431: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
6432: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
6433: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;

Line 6432: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;

6428: l_critical_flag VARCHAR2(1);
6429: l_milestone_flag VARCHAR2(1);
6430: -- xxlu
6431: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
6432: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
6433: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;

Line 6433: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;

6429: l_milestone_flag VARCHAR2(1);
6430: -- xxlu
6431: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
6432: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
6433: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;

Line 6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;

6430: -- xxlu
6431: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
6432: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
6433: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;

Line 6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;

6431: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
6432: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
6433: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;

Line 6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;

6432: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
6433: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;

Line 6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;

6433: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;

Line 6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;

6434: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;

Line 6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;

6435: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;

Line 6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;

6436: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
6444: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;

Line 6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;

6437: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
6444: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
6445: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;

Line 6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;

6438: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
6444: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
6445: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
6446: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;

Line 6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;

6439: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
6444: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
6445: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
6446: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
6447: -- end xxlu changes

Line 6444: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;

6440: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
6444: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
6445: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
6446: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
6447: -- end xxlu changes
6448:

Line 6445: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;

6441: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
6444: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
6445: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
6446: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
6447: -- end xxlu changes
6448:
6449: --hsiu added for duration calculation

Line 6446: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;

6442: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
6443: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
6444: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
6445: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
6446: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
6447: -- end xxlu changes
6448:
6449: --hsiu added for duration calculation
6450: l_act_duration_days NUMBER;

Line 7194: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7190: p_record_version_number IN NUMBER,
7191: p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7192: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7193: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7194: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7195: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7196: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7195: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7191: p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7192: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7193: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7194: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7195: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7196: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7196: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7192: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7193: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7194: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7195: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7196: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7193: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7194: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7195: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7196: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7194: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7195: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7196: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7195: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7196: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7196: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7197: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7198: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7199: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7207: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7200: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7207: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7208: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7201: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7207: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7208: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7209: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7202: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7207: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7208: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7209: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7210: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 7207: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7203: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7207: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7208: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7209: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7210: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7211: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 7208: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7204: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7207: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7208: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7209: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7210: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7211: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
7212: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7209: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

7205: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7206: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7207: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7208: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7209: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7210: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7211: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
7212: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7213: ) IS

Line 7218: FROM pa_proj_elem_ver_schedule

7214:
7215: CURSOR cur_proj_elem_ver_sch
7216: IS
7217: SELECT rowid, element_version_id, project_id, proj_element_id, record_version_number
7218: FROM pa_proj_elem_ver_schedule
7219: WHERE pev_schedule_id = p_pev_schedule_id;
7220: cur_proj_elem_ver_sch_rec cur_proj_elem_ver_sch%ROWTYPE;
7221:
7222: CURSOR get_actual_wq(c_project_id NUMBER, c_element_id NUMBER) IS

Line 7234: from pa_proj_elem_ver_schedule

7230: and ppru.object_type = 'PA_TASKS';
7231:
7232: CURSOR get_info IS
7233: select proj_element_id, project_id
7234: from pa_proj_elem_ver_schedule
7235: where pev_schedule_id = p_pev_schedule_id;
7236: l_project_id NUMBER;
7237: l_proj_element_id NUMBER;
7238:

Line 7255: from pa_proj_elem_ver_schedule

7251: l_milestone_flag VARCHAR2(1);
7252:
7253: CURSOR cur_val IS
7254: select *
7255: from pa_proj_elem_ver_schedule
7256: where pev_schedule_id = p_pev_schedule_id;
7257: cur_val_rec cur_val%ROWTYPE;
7258: --end duration changes
7259:

Line 7286: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;

7282: l_late_end_date DATE;
7283: l_wq_planned_quantity NUMBER;
7284: l_planned_effort NUMBER;
7285: -- xxlu
7286: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7287: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7288: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;

Line 7287: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;

7283: l_wq_planned_quantity NUMBER;
7284: l_planned_effort NUMBER;
7285: -- xxlu
7286: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7287: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7288: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;

Line 7288: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;

7284: l_planned_effort NUMBER;
7285: -- xxlu
7286: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7287: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7288: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;

Line 7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;

7285: -- xxlu
7286: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7287: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7288: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;

Line 7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;

7286: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7287: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7288: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;

Line 7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;

7287: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7288: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;

Line 7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;

7288: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;

Line 7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;

7289: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;

Line 7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;

7290: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;

Line 7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;

7291: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7299: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;

Line 7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;

7292: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7299: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7300: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;

Line 7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;

7293: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7299: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7300: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7301: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;

Line 7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;

7294: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7299: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7300: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7301: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7302: -- end xxlu changes

Line 7299: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;

7295: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7299: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7300: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7301: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7302: -- end xxlu changes
7303:

Line 7300: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;

7296: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7299: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7300: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7301: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7302: -- end xxlu changes
7303:
7304: --hsiu added, for dates rollup

Line 7301: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;

7297: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7298: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7299: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7300: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7301: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7302: -- end xxlu changes
7303:
7304: --hsiu added, for dates rollup
7305: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

Line 8876: FROM pa_proj_elem_ver_schedule

8872:
8873: CURSOR cur_sch_ver( p_task_id NUMBER, p_project_id NUMBER )
8874: IS
8875: SELECT rowid
8876: FROM pa_proj_elem_ver_schedule
8877: WHERE element_version_id = p_task_id
8878: AND project_id = p_project_id;
8879:
8880: CURSOR cur_pa_projs( p_project_id NUMBER )

Line 9996: FROM pa_proj_elem_ver_schedule

9992: CURSOR cur_proj_elem_ver_sch(c_elem_ver_id number, c_project_id NUMBER)
9993: IS
9994: SELECT element_version_id, project_id, proj_element_id, actual_start_date, actual_finish_date,
9995: estimated_start_date, estimated_finish_date, actual_duration, estimated_duration
9996: FROM pa_proj_elem_ver_schedule
9997: WHERE element_version_id = c_elem_ver_id
9998: and project_id = c_project_id;
9999:
10000: cur_proj_elem_ver_sch_rec cur_proj_elem_ver_sch%ROWTYPE;

Line 10029: UPDATE pa_proj_elem_ver_schedule

10025: FETCH cur_proj_elem_ver_sch INTO cur_proj_elem_ver_sch_rec;
10026: CLOSE cur_proj_elem_ver_sch;
10027: -- Update schedule data for all the versions of the above task
10028:
10029: UPDATE pa_proj_elem_ver_schedule
10030: SET actual_start_date = cur_proj_elem_ver_sch_rec.actual_start_date
10031: , actual_finish_date = cur_proj_elem_ver_sch_rec.actual_finish_date
10032: , estimated_start_date = cur_proj_elem_ver_sch_rec.estimated_start_date
10033: , estimated_finish_date = cur_proj_elem_ver_sch_rec.estimated_finish_date

Line 10048: UPDATE pa_proj_elem_ver_schedule

10044: CLOSE cur_proj_elem_ver_sch;
10045:
10046: -- Update schedule data for all the versions of the above task
10047:
10048: UPDATE pa_proj_elem_ver_schedule
10049: SET actual_start_date = cur_proj_elem_ver_sch_rec.actual_start_date
10050: , actual_finish_date = cur_proj_elem_ver_sch_rec.actual_finish_date
10051: , estimated_start_date = cur_proj_elem_ver_sch_rec.estimated_start_date
10052: , estimated_finish_date = cur_proj_elem_ver_sch_rec.estimated_finish_date