40: X_ext_remain_duration IN NUMBER := NULL,
41: X_ext_sch_duration IN NUMBER := NULL,
42: x_source_object_id IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug No 3594635 SMukka
43: x_source_object_type IN VARCHAR2:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, --Bug No 3594635 SMukka
44: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
45: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
46: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
47: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
41: X_ext_sch_duration IN NUMBER := NULL,
42: x_source_object_id IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug No 3594635 SMukka
43: x_source_object_type IN VARCHAR2:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, --Bug No 3594635 SMukka
44: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
45: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
46: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
47: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
42: x_source_object_id IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug No 3594635 SMukka
43: x_source_object_type IN VARCHAR2:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, --Bug No 3594635 SMukka
44: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
45: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
46: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
47: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
43: x_source_object_type IN VARCHAR2:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, --Bug No 3594635 SMukka
44: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
45: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
46: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
47: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
44: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
45: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
46: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
47: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
45: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
46: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
47: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
46: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
47: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
47: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
48: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
49: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
57: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
50: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
57: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
58: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
51: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
57: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
58: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
59: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
52: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
57: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
58: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
59: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
60: ) IS
53: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
57: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
58: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
59: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
60: ) IS
61: CURSOR cur_elem_ver_sch
54: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
57: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
58: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
59: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
60: ) IS
61: CURSOR cur_elem_ver_sch
62: IS
55: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
57: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
58: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
59: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
60: ) IS
61: CURSOR cur_elem_ver_sch
62: IS
63: SELECT pa_proj_elem_ver_schedule_s.nextval
59: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
60: ) IS
61: CURSOR cur_elem_ver_sch
62: IS
63: SELECT pa_proj_elem_ver_schedule_s.nextval
64: FROM sys.dual;
65: BEGIN
66: IF X_PEV_SCHEDULE_ID IS NULL
67: THEN
68: OPEN cur_elem_ver_sch;
69: FETCH cur_elem_ver_sch INTO X_PEV_SCHEDULE_ID;
70: CLOSE cur_elem_ver_sch;
71: END IF;
72: INSERT INTO pa_proj_elem_ver_schedule(
73: PEV_SCHEDULE_ID
74: ,ELEMENT_VERSION_ID
75: ,PROJECT_ID
76: ,PROJ_ELEMENT_ID
230: X_RECORD_VERSION_NUMBER NUMBER,
231: X_ext_act_duration IN NUMBER := NULL,
232: X_ext_remain_duration IN NUMBER := NULL,
233: X_ext_sch_duration IN NUMBER := NULL,
234: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
235: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
236: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
237: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
231: X_ext_act_duration IN NUMBER := NULL,
232: X_ext_remain_duration IN NUMBER := NULL,
233: X_ext_sch_duration IN NUMBER := NULL,
234: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
235: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
236: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
237: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
232: X_ext_remain_duration IN NUMBER := NULL,
233: X_ext_sch_duration IN NUMBER := NULL,
234: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
235: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
236: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
237: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
233: X_ext_sch_duration IN NUMBER := NULL,
234: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
235: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
236: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
237: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
234: X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
235: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
236: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
237: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
235: X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
236: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
237: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
236: X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
237: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
237: X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
238: X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
246: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
239: X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
246: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
247: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
240: X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
246: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
247: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
248: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
241: X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
246: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
247: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
248: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
249: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
242: X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
246: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
247: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
248: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
249: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
250: ) IS
243: X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
246: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
247: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
248: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
249: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
250: ) IS
251: BEGIN
244: X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
246: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
247: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
248: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
249: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
250: ) IS
251: BEGIN
252: UPDATE pa_proj_elem_ver_schedule
245: X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
246: X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
247: X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
248: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
249: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
250: ) IS
251: BEGIN
252: UPDATE pa_proj_elem_ver_schedule
253: SET PEV_SCHEDULE_ID = X_PEV_SCHEDULE_ID
248: X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
249: X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
250: ) IS
251: BEGIN
252: UPDATE pa_proj_elem_ver_schedule
253: SET PEV_SCHEDULE_ID = X_PEV_SCHEDULE_ID
254: ,ELEMENT_VERSION_ID = X_ELEMENT_VERSION_ID
255: ,PROJECT_ID = X_PROJECT_ID
256: ,PROJ_ELEMENT_ID = X_PROJ_ELEMENT_ID
310: PROCEDURE Delete_Row(
311: X_ROW_ID IN VARCHAR2
312: ) IS
313: BEGIN
314: DELETE FROM pa_proj_elem_ver_schedule
315: WHERE rowid = X_ROW_ID;
316: END Delete_Row;
317:
318: END PA_PROJ_ELEMENT_SCH_PKG;