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 5386: FROM pa_proj_elem_ver_schedule

5382:
5383: CURSOR cur_sch_ver( p_task_id NUMBER, p_project_id NUMBER )
5384: IS
5385: SELECT rowid
5386: FROM pa_proj_elem_ver_schedule
5387: WHERE element_version_id = p_task_id
5388: and project_id = p_project_id;
5389:
5390: CURSOR cur_pa_projs( p_project_id NUMBER )

Line 5966: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE

5962: CLOSE cur_sch_ver;
5963: */
5964:
5965: -- Added direct delete statement
5966: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
5967: WHERE ELEMENT_VERSION_ID = cur_child_tasks_rec.object_id_to1
5968: AND PROJECT_ID = x_project_id;
5969:
5970: -- 4201927 end

Line 6684: update pa_proj_elem_ver_schedule

6680:
6681:
6682: IF (l_tsk_ver_cnt = 0) THEN
6683: --set scheduled dates to sysdate
6684: update pa_proj_elem_ver_schedule
6685: set SCHEDULED_START_DATE = trunc(sysdate),
6686: SCHEDULED_FINISH_DATE = trunc(sysdate),
6687: DURATION = 1,
6688: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,

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

6935: p_PLANNED_EQUIP_EFFORT IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --bug 3305199
6936: p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6937: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6938: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6939: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6940: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6941: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6942: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6936: p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6937: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6938: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6939: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6940: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6941: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6942: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6937: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6938: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6939: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6940: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6941: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6942: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6938: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
6939: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6940: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6941: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6942: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6939: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6940: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6941: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6942: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6940: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6941: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6942: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6941: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6942: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6942: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6943: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6951: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6944: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6951: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6952: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6945: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6951: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6952: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6953: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6946: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6951: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6952: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6953: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6954: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6947: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6951: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6952: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6953: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6954: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6955:

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

6948: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6951: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6952: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6953: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6954: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6955:
6956: --bug 3305199 schedule options

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

6949: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6951: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6952: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6953: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6954: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6955:
6956: --bug 3305199 schedule options
6957: p_def_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

6950: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6951: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6952: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6953: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6954: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6955:
6956: --bug 3305199 schedule options
6957: p_def_sch_tool_tsk_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
6958: p_constraint_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 7034: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;

7030: l_planned_effort NUMBER;
7031: l_critical_flag VARCHAR2(1);
7032: l_milestone_flag VARCHAR2(1);
7033: -- xxlu
7034: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7035: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7036: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;

Line 7035: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;

7031: l_critical_flag VARCHAR2(1);
7032: l_milestone_flag VARCHAR2(1);
7033: -- xxlu
7034: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7035: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7036: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;

Line 7036: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;

7032: l_milestone_flag VARCHAR2(1);
7033: -- xxlu
7034: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7035: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7036: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;

Line 7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;

7033: -- xxlu
7034: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7035: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7036: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;

Line 7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;

7034: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7035: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7036: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;

Line 7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;

7035: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7036: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;

Line 7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;

7036: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;

Line 7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;

7037: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;

Line 7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;

7038: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;

Line 7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;

7039: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7047: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;

Line 7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;

7040: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7047: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7048: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;

Line 7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;

7041: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7047: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7048: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7049: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;

Line 7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;

7042: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7047: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7048: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7049: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7050: -- end xxlu changes

Line 7047: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;

7043: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7047: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7048: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7049: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7050: -- end xxlu changes
7051:

Line 7048: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;

7044: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7047: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7048: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7049: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7050: -- end xxlu changes
7051:
7052: --hsiu added for duration calculation

Line 7049: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;

7045: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7046: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7047: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7048: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7049: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7050: -- end xxlu changes
7051:
7052: --hsiu added for duration calculation
7053: l_act_duration_days NUMBER;

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

7793: p_record_version_number IN NUMBER,
7794: p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7795: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7796: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7797: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7798: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7799: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7800: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7794: p_ext_act_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7795: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7796: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7797: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7798: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7799: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7800: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7795: p_ext_remain_duration IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7796: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7797: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7798: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7799: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7800: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7796: p_ext_sch_duration IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug no 3450684
7797: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7798: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7799: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7800: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7797: p_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7798: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7799: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7800: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7798: p_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7799: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7800: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7799: p_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7800: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7800: p_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7801: p_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7809: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7802: p_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7809: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7810: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7803: p_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7809: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7810: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7811: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7804: p_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7809: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7810: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7811: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7812: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

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

7805: p_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7809: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7810: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7811: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7812: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7813: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

7806: p_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7809: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7810: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7811: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7812: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7813: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7814: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

7807: p_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7809: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7810: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7811: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7812: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7813: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7814: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
7815: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

7808: p_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7809: p_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7810: p_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7811: p_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7812: p_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
7813: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7814: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
7815: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7816: ) IS

Line 7821: FROM pa_proj_elem_ver_schedule

7817:
7818: CURSOR cur_proj_elem_ver_sch
7819: IS
7820: SELECT rowid, element_version_id, project_id, proj_element_id, record_version_number
7821: FROM pa_proj_elem_ver_schedule
7822: WHERE pev_schedule_id = p_pev_schedule_id;
7823: cur_proj_elem_ver_sch_rec cur_proj_elem_ver_sch%ROWTYPE;
7824:
7825: CURSOR get_actual_wq(c_project_id NUMBER, c_element_id NUMBER) IS

Line 7837: from pa_proj_elem_ver_schedule

7833: and ppru.object_type = 'PA_TASKS';
7834:
7835: CURSOR get_info IS
7836: select proj_element_id, project_id
7837: from pa_proj_elem_ver_schedule
7838: where pev_schedule_id = p_pev_schedule_id;
7839: l_project_id NUMBER;
7840: l_proj_element_id NUMBER;
7841:

Line 7858: from pa_proj_elem_ver_schedule

7854: l_milestone_flag VARCHAR2(1);
7855:
7856: CURSOR cur_val IS
7857: select *
7858: from pa_proj_elem_ver_schedule
7859: where pev_schedule_id = p_pev_schedule_id;
7860: cur_val_rec cur_val%ROWTYPE;
7861: --end duration changes
7862:

Line 7889: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;

7885: l_late_end_date DATE;
7886: l_wq_planned_quantity NUMBER;
7887: l_planned_effort NUMBER;
7888: -- xxlu
7889: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7890: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7891: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;

Line 7890: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;

7886: l_wq_planned_quantity NUMBER;
7887: l_planned_effort NUMBER;
7888: -- xxlu
7889: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7890: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7891: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;

Line 7891: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;

7887: l_planned_effort NUMBER;
7888: -- xxlu
7889: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7890: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7891: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;

Line 7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;

7888: -- xxlu
7889: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7890: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7891: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;

Line 7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;

7889: l_attribute_category pa_proj_elem_ver_schedule.attribute_category%TYPE ;
7890: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7891: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;

Line 7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;

7890: l_attribute1 pa_proj_elem_ver_schedule.attribute1%TYPE ;
7891: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;

Line 7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;

7891: l_attribute2 pa_proj_elem_ver_schedule.attribute2%TYPE ;
7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;

Line 7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;

7892: l_attribute3 pa_proj_elem_ver_schedule.attribute3%TYPE ;
7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;

Line 7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;

7893: l_attribute4 pa_proj_elem_ver_schedule.attribute4%TYPE ;
7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;

Line 7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;

7894: l_attribute5 pa_proj_elem_ver_schedule.attribute5%TYPE ;
7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7902: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;

Line 7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;

7895: l_attribute6 pa_proj_elem_ver_schedule.attribute6%TYPE ;
7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7902: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7903: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;

Line 7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;

7896: l_attribute7 pa_proj_elem_ver_schedule.attribute7%TYPE ;
7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7902: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7903: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7904: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;

Line 7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;

7897: l_attribute8 pa_proj_elem_ver_schedule.attribute8%TYPE ;
7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7902: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7903: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7904: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7905: -- end xxlu changes

Line 7902: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;

7898: l_attribute9 pa_proj_elem_ver_schedule.attribute9%TYPE ;
7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7902: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7903: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7904: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7905: -- end xxlu changes
7906:

Line 7903: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;

7899: l_attribute10 pa_proj_elem_ver_schedule.attribute10%TYPE ;
7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7902: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7903: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7904: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7905: -- end xxlu changes
7906:
7907: --hsiu added, for dates rollup

Line 7904: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;

7900: l_attribute11 pa_proj_elem_ver_schedule.attribute11%TYPE ;
7901: l_attribute12 pa_proj_elem_ver_schedule.attribute12%TYPE ;
7902: l_attribute13 pa_proj_elem_ver_schedule.attribute13%TYPE ;
7903: l_attribute14 pa_proj_elem_ver_schedule.attribute14%TYPE ;
7904: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7905: -- end xxlu changes
7906:
7907: --hsiu added, for dates rollup
7908: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

Line 9622: FROM pa_proj_elem_ver_schedule

9618:
9619: CURSOR cur_sch_ver( p_task_id NUMBER, p_project_id NUMBER )
9620: IS
9621: SELECT rowid
9622: FROM pa_proj_elem_ver_schedule
9623: WHERE element_version_id = p_task_id
9624: AND project_id = p_project_id;
9625:
9626: CURSOR cur_pa_projs( p_project_id NUMBER )

Line 10753: FROM pa_proj_elem_ver_schedule

10749: CURSOR cur_proj_elem_ver_sch(c_elem_ver_id number, c_project_id NUMBER)
10750: IS
10751: SELECT element_version_id, project_id, proj_element_id, actual_start_date, actual_finish_date,
10752: estimated_start_date, estimated_finish_date, actual_duration, estimated_duration
10753: FROM pa_proj_elem_ver_schedule
10754: WHERE element_version_id = c_elem_ver_id
10755: and project_id = c_project_id;
10756:
10757: cur_proj_elem_ver_sch_rec cur_proj_elem_ver_sch%ROWTYPE;

Line 10786: UPDATE pa_proj_elem_ver_schedule

10782: FETCH cur_proj_elem_ver_sch INTO cur_proj_elem_ver_sch_rec;
10783: CLOSE cur_proj_elem_ver_sch;
10784: -- Update schedule data for all the versions of the above task
10785:
10786: UPDATE pa_proj_elem_ver_schedule
10787: SET actual_start_date = cur_proj_elem_ver_sch_rec.actual_start_date
10788: , actual_finish_date = cur_proj_elem_ver_sch_rec.actual_finish_date
10789: , estimated_start_date = cur_proj_elem_ver_sch_rec.estimated_start_date
10790: , estimated_finish_date = cur_proj_elem_ver_sch_rec.estimated_finish_date

Line 10805: UPDATE pa_proj_elem_ver_schedule

10801: CLOSE cur_proj_elem_ver_sch;
10802:
10803: -- Update schedule data for all the versions of the above task
10804:
10805: UPDATE pa_proj_elem_ver_schedule
10806: SET actual_start_date = cur_proj_elem_ver_sch_rec.actual_start_date
10807: , actual_finish_date = cur_proj_elem_ver_sch_rec.actual_finish_date
10808: , estimated_start_date = cur_proj_elem_ver_sch_rec.estimated_start_date
10809: , estimated_finish_date = cur_proj_elem_ver_sch_rec.estimated_finish_date

Line 11034: pa_proj_elem_ver_schedule ppevs,

11030: ptt.prog_entry_enable_flag prog_flag ,
11031: ppev.object_type
11032: FROM pa_proj_element_versions ppev,
11033: pa_object_relationships por,
11034: pa_proj_elem_ver_schedule ppevs,
11035: pa_proj_elements ppe,
11036: pa_task_types ptt
11037: WHERE ppev.parent_structure_version_id = c_parent_struc_ver_id -- 377522
11038: AND por.object_type_to = 'PA_TASKS'