1: PACKAGE BODY CSC_PLAN_LINES_PVT as
2: /* $Header: cscvplnb.pls 115.16 2002/11/25 12:35:17 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_LINES_PVT
5: -- Purpose : Private package to perform inserts, updates and delete operations
1: PACKAGE BODY CSC_PLAN_LINES_PVT as
2: /* $Header: cscvplnb.pls 115.16 2002/11/25 12:35:17 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_LINES_PVT
5: -- Purpose : Private package to perform inserts, updates and delete operations
6: -- on CSC_PLAN_LINES table. It contains procedures to perform item
7: -- level validations if validation level is set to 100 (FULL).
8: -- History :
2: /* $Header: cscvplnb.pls 115.16 2002/11/25 12:35:17 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_LINES_PVT
5: -- Purpose : Private package to perform inserts, updates and delete operations
6: -- on CSC_PLAN_LINES table. It contains procedures to perform item
7: -- level validations if validation level is set to 100 (FULL).
8: -- History :
9: -- MM-DD-YYYY NAME MODIFICATIONS
10: -- 10-21-1999 dejoseph Created.
19:
20: -- NOTE :
21: -- End of Comments
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_PLAN_LINES_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvplnb.pls';
25:
26: PROCEDURE convert_columns_to_rec_type(
27: P_LINE_ID IN NUMBER,
48: P_ATTRIBUTE14 IN VARCHAR2,
49: P_ATTRIBUTE15 IN VARCHAR2,
50: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
51: P_OBJECT_VERSION_NUMBER IN NUMBER ,
52: x_csc_plan_lines_rec OUT NOCOPY CSC_PLAN_LINES_REC_TYPE)
53: IS
54: BEGIN
55: x_csc_plan_lines_rec.LINE_ID := P_LINE_ID;
56: x_csc_plan_lines_rec.PLAN_ID := P_PLAN_ID ;
51: P_OBJECT_VERSION_NUMBER IN NUMBER ,
52: x_csc_plan_lines_rec OUT NOCOPY CSC_PLAN_LINES_REC_TYPE)
53: IS
54: BEGIN
55: x_csc_plan_lines_rec.LINE_ID := P_LINE_ID;
56: x_csc_plan_lines_rec.PLAN_ID := P_PLAN_ID ;
57: x_csc_plan_lines_rec.CONDITION_ID := P_CONDITION_ID ;
58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
52: x_csc_plan_lines_rec OUT NOCOPY CSC_PLAN_LINES_REC_TYPE)
53: IS
54: BEGIN
55: x_csc_plan_lines_rec.LINE_ID := P_LINE_ID;
56: x_csc_plan_lines_rec.PLAN_ID := P_PLAN_ID ;
57: x_csc_plan_lines_rec.CONDITION_ID := P_CONDITION_ID ;
58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
53: IS
54: BEGIN
55: x_csc_plan_lines_rec.LINE_ID := P_LINE_ID;
56: x_csc_plan_lines_rec.PLAN_ID := P_PLAN_ID ;
57: x_csc_plan_lines_rec.CONDITION_ID := P_CONDITION_ID ;
58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
54: BEGIN
55: x_csc_plan_lines_rec.LINE_ID := P_LINE_ID;
56: x_csc_plan_lines_rec.PLAN_ID := P_PLAN_ID ;
57: x_csc_plan_lines_rec.CONDITION_ID := P_CONDITION_ID ;
58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
55: x_csc_plan_lines_rec.LINE_ID := P_LINE_ID;
56: x_csc_plan_lines_rec.PLAN_ID := P_PLAN_ID ;
57: x_csc_plan_lines_rec.CONDITION_ID := P_CONDITION_ID ;
58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
56: x_csc_plan_lines_rec.PLAN_ID := P_PLAN_ID ;
57: x_csc_plan_lines_rec.CONDITION_ID := P_CONDITION_ID ;
58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
57: x_csc_plan_lines_rec.CONDITION_ID := P_CONDITION_ID ;
58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;
69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;
77: x_csc_plan_lines_rec.ATTRIBUTE15 := P_ATTRIBUTE15 ;
70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;
77: x_csc_plan_lines_rec.ATTRIBUTE15 := P_ATTRIBUTE15 ;
78: x_csc_plan_lines_rec.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;
77: x_csc_plan_lines_rec.ATTRIBUTE15 := P_ATTRIBUTE15 ;
78: x_csc_plan_lines_rec.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
79: x_csc_plan_lines_rec.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;
77: x_csc_plan_lines_rec.ATTRIBUTE15 := P_ATTRIBUTE15 ;
78: x_csc_plan_lines_rec.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
79: x_csc_plan_lines_rec.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
80:
73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;
77: x_csc_plan_lines_rec.ATTRIBUTE15 := P_ATTRIBUTE15 ;
78: x_csc_plan_lines_rec.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
79: x_csc_plan_lines_rec.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
80:
81: END convert_columns_to_rec_type;
74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;
77: x_csc_plan_lines_rec.ATTRIBUTE15 := P_ATTRIBUTE15 ;
78: x_csc_plan_lines_rec.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
79: x_csc_plan_lines_rec.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
80:
81: END convert_columns_to_rec_type;
82:
75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;
76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;
77: x_csc_plan_lines_rec.ATTRIBUTE15 := P_ATTRIBUTE15 ;
78: x_csc_plan_lines_rec.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;
79: x_csc_plan_lines_rec.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;
80:
81: END convert_columns_to_rec_type;
82:
83:
120: X_Msg_Count OUT NOCOPY NUMBER,
121: X_Msg_Data OUT NOCOPY VARCHAR2
122: )
123: IS
124: l_csc_plan_lines_rec CSC_PLAN_LINES_REC_TYPE;
125:
126: BEGIN
127: CONVERT_COLUMNS_TO_REC_TYPE(
128: P_LINE_ID => p_line_id,
149: P_ATTRIBUTE14 => p_attribute14,
150: P_ATTRIBUTE15 => p_attribute15,
151: P_ATTRIBUTE_CATEGORY => p_attribute_category,
152: P_OBJECT_VERSION_NUMBER => p_object_version_number,
153: x_csc_plan_lines_rec => l_csc_plan_lines_rec);
154:
155: -- issue a call to the create_plan_lines proc. that accepts record_type parameters.
156:
157: Create_plan_lines(
158: P_Api_Version_Number => p_api_version_number,
159: P_Init_Msg_List => p_init_msg_list,
160: P_Commit => p_commit,
161: P_Validation_level => p_validation_level,
162: P_CSC_PLAN_LINES_Rec => l_csc_plan_lines_rec,
163: X_LINE_ID => x_line_id,
164: X_OBJECT_VERSION_NUMBER => x_object_version_number,
165: X_Return_Status => x_return_status,
166: X_Msg_Count => x_msg_count,
174: P_Api_Version_Number IN NUMBER,
175: P_Init_Msg_List IN VARCHAR2,
176: P_Commit IN VARCHAR2,
177: p_validation_level IN NUMBER,
178: P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
179: X_LINE_ID OUT NOCOPY NUMBER,
180: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
181: X_Return_Status OUT NOCOPY VARCHAR2,
182: X_Msg_Count OUT NOCOPY NUMBER,
225:
226: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
227: THEN
228: -- Invoke validation procedures
229: Validate_csc_plan_lines(
230: p_init_msg_list => FND_API.G_FALSE,
231: p_validation_level => p_validation_level,
232: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
233: P_CSC_PLAN_LINES_Rec => P_CSC_PLAN_LINES_Rec,
229: Validate_csc_plan_lines(
230: p_init_msg_list => FND_API.G_FALSE,
231: p_validation_level => p_validation_level,
232: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
233: P_CSC_PLAN_LINES_Rec => P_CSC_PLAN_LINES_Rec,
234: x_return_status => x_return_status,
235: x_msg_count => x_msg_count,
236: x_msg_data => x_msg_data);
237: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: END IF;
241:
242: -- Invoke table handler(CSC_PLAN_LINES_PKG.Insert_Row)
243: CSC_PLAN_LINES_PKG.Insert_Row(
244: px_LINE_ID => x_LINE_ID,
245: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
246: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
239: END IF;
240: END IF;
241:
242: -- Invoke table handler(CSC_PLAN_LINES_PKG.Insert_Row)
243: CSC_PLAN_LINES_PKG.Insert_Row(
244: px_LINE_ID => x_LINE_ID,
245: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
246: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
247: p_CREATION_DATE => SYSDATE,
241:
242: -- Invoke table handler(CSC_PLAN_LINES_PKG.Insert_Row)
243: CSC_PLAN_LINES_PKG.Insert_Row(
244: px_LINE_ID => x_LINE_ID,
245: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
246: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
247: p_CREATION_DATE => SYSDATE,
248: p_LAST_UPDATE_DATE => SYSDATE,
249: p_CREATED_BY => FND_GLOBAL.USER_ID,
242: -- Invoke table handler(CSC_PLAN_LINES_PKG.Insert_Row)
243: CSC_PLAN_LINES_PKG.Insert_Row(
244: px_LINE_ID => x_LINE_ID,
245: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
246: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
247: p_CREATION_DATE => SYSDATE,
248: p_LAST_UPDATE_DATE => SYSDATE,
249: p_CREATED_BY => FND_GLOBAL.USER_ID,
250: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
248: p_LAST_UPDATE_DATE => SYSDATE,
249: p_CREATED_BY => FND_GLOBAL.USER_ID,
250: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
251: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
252: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
253: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
254: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
249: p_CREATED_BY => FND_GLOBAL.USER_ID,
250: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
251: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
252: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
253: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
254: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
250: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
251: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
252: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
253: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
254: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
251: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
252: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
253: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
254: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
252: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
253: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
254: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
253: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
254: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
254: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
265: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
265: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
266: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
265: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
266: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
267: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
265: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
266: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
267: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
268: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
265: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
266: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
267: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
268: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
269:
262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
265: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
266: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
267: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
268: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
269:
270: -- Standard check for p_commit
263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
265: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
266: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
267: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
268: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
269:
270: -- Standard check for p_commit
271: IF FND_API.to_Boolean( p_commit )
352: X_Msg_Count OUT NOCOPY NUMBER,
353: X_Msg_Data OUT NOCOPY VARCHAR2)
354: IS
355:
356: l_csc_plan_lines_rec CSC_PLAN_LINES_REC_TYPE;
357:
358: BEGIN
359: convert_columns_to_rec_type(
360: P_LINE_ID => p_line_id,
381: P_ATTRIBUTE14 => p_attribute14,
382: P_ATTRIBUTE15 => p_attribute15,
383: P_ATTRIBUTE_CATEGORY => p_attribute_category,
384: P_OBJECT_VERSION_NUMBER => p_object_version_number,
385: x_csc_plan_lines_rec => l_csc_plan_lines_rec);
386:
387: -- issue a call to the create_plan_lines proc. that accepts record_type parameters.
388:
389: Update_plan_lines(
390: P_Api_Version_Number => p_api_version_number,
391: P_Init_Msg_List => p_init_msg_list,
392: P_Commit => p_commit,
393: P_Validation_level => p_validation_level,
394: P_CSC_PLAN_LINES_Rec => l_csc_plan_lines_rec,
395: X_OBJECT_VERSION_NUMBER => x_object_version_number,
396: X_Return_Status => x_return_status,
397: X_Msg_Count => x_msg_count,
398: X_Msg_Data => x_msg_data );
403: P_Api_Version_Number IN NUMBER,
404: P_Init_Msg_List IN VARCHAR2,
405: P_Commit IN VARCHAR2,
406: p_validation_level IN NUMBER,
407: P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
408: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
409: X_Return_Status OUT NOCOPY VARCHAR2,
410: X_Msg_Count OUT NOCOPY NUMBER,
411: X_Msg_Data OUT NOCOPY VARCHAR2
420: ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9,
421: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
422: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
423: ATTRIBUTE_CATEGORY,OBJECT_VERSION_NUMBER
424: From CSC_PLAN_LINES
425: where line_id = c_line_id
426: For Update NOWAIT;
427:
428: l_api_name CONSTANT VARCHAR2(30) := 'Update_plan_lines';
427:
428: l_api_name CONSTANT VARCHAR2(30) := 'Update_plan_lines';
429: l_api_version_number CONSTANT NUMBER := 1.0;
430:
431: l_ref_CSC_PLAN_LINES_rec CSC_plan_lines_PVT.CSC_PLAN_LINES_Rec_Type;
432: l_tar_CSC_PLAN_LINES_rec CSC_plan_lines_PVT.CSC_PLAN_LINES_Rec_Type := P_CSC_PLAN_LINES_Rec;
433: l_rowid ROWID;
434: BEGIN
435: -- Standard Start of API savepoint
428: l_api_name CONSTANT VARCHAR2(30) := 'Update_plan_lines';
429: l_api_version_number CONSTANT NUMBER := 1.0;
430:
431: l_ref_CSC_PLAN_LINES_rec CSC_plan_lines_PVT.CSC_PLAN_LINES_Rec_Type;
432: l_tar_CSC_PLAN_LINES_rec CSC_plan_lines_PVT.CSC_PLAN_LINES_Rec_Type := P_CSC_PLAN_LINES_Rec;
433: l_rowid ROWID;
434: BEGIN
435: -- Standard Start of API savepoint
436: SAVEPOINT UPDATE_PLAN_LINES_PVT;
452:
453: -- Initialize API return status to SUCCESS
454: x_return_status := FND_API.G_RET_STS_SUCCESS;
455:
456: Open C_Get_plan_lines( l_tar_CSC_PLAN_LINES_rec.LINE_ID);
457:
458: Fetch C_Get_plan_lines into
459: l_rowid,
460: l_ref_CSC_PLAN_LINES_rec.LINE_ID,
456: Open C_Get_plan_lines( l_tar_CSC_PLAN_LINES_rec.LINE_ID);
457:
458: Fetch C_Get_plan_lines into
459: l_rowid,
460: l_ref_CSC_PLAN_LINES_rec.LINE_ID,
461: l_ref_CSC_PLAN_LINES_rec.PLAN_ID,
462: l_ref_CSC_PLAN_LINES_rec.CONDITION_ID,
463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
457:
458: Fetch C_Get_plan_lines into
459: l_rowid,
460: l_ref_CSC_PLAN_LINES_rec.LINE_ID,
461: l_ref_CSC_PLAN_LINES_rec.PLAN_ID,
462: l_ref_CSC_PLAN_LINES_rec.CONDITION_ID,
463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
458: Fetch C_Get_plan_lines into
459: l_rowid,
460: l_ref_CSC_PLAN_LINES_rec.LINE_ID,
461: l_ref_CSC_PLAN_LINES_rec.PLAN_ID,
462: l_ref_CSC_PLAN_LINES_rec.CONDITION_ID,
463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
459: l_rowid,
460: l_ref_CSC_PLAN_LINES_rec.LINE_ID,
461: l_ref_CSC_PLAN_LINES_rec.PLAN_ID,
462: l_ref_CSC_PLAN_LINES_rec.CONDITION_ID,
463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
460: l_ref_CSC_PLAN_LINES_rec.LINE_ID,
461: l_ref_CSC_PLAN_LINES_rec.PLAN_ID,
462: l_ref_CSC_PLAN_LINES_rec.CONDITION_ID,
463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
461: l_ref_CSC_PLAN_LINES_rec.PLAN_ID,
462: l_ref_CSC_PLAN_LINES_rec.CONDITION_ID,
463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
462: l_ref_CSC_PLAN_LINES_rec.CONDITION_ID,
463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
482: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
482: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
483: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
482: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
483: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
484: l_ref_CSC_PLAN_LINES_rec.OBJECT_VERSION_NUMBER;
477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
482: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
483: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
484: l_ref_CSC_PLAN_LINES_rec.OBJECT_VERSION_NUMBER;
485:
478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
482: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
483: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
484: l_ref_CSC_PLAN_LINES_rec.OBJECT_VERSION_NUMBER;
485:
486: If ( C_Get_plan_lines%NOTFOUND) Then
479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
482: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
483: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
484: l_ref_CSC_PLAN_LINES_rec.OBJECT_VERSION_NUMBER;
485:
486: If ( C_Get_plan_lines%NOTFOUND) Then
487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
482: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
483: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
484: l_ref_CSC_PLAN_LINES_rec.OBJECT_VERSION_NUMBER;
485:
486: If ( C_Get_plan_lines%NOTFOUND) Then
487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
488: THEN
498:
499: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
500: THEN
501: -- Invoke validation procedures
502: Validate_csc_plan_lines(
503: p_init_msg_list => FND_API.G_FALSE,
504: p_validation_level => p_validation_level,
505: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
506: P_CSC_PLAN_LINES_Rec => P_CSC_PLAN_LINES_Rec,
502: Validate_csc_plan_lines(
503: p_init_msg_list => FND_API.G_FALSE,
504: p_validation_level => p_validation_level,
505: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
506: P_CSC_PLAN_LINES_Rec => P_CSC_PLAN_LINES_Rec,
507: x_return_status => x_return_status,
508: x_msg_count => x_msg_count,
509: x_msg_data => x_msg_data);
510: END IF;
512: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)
517: CSC_PLAN_LINES_PKG.Update_Row(
518: p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,
519: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
520: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)
517: CSC_PLAN_LINES_PKG.Update_Row(
518: p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,
519: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
520: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
521: p_CREATION_DATE => SYSDATE,
514: END IF;
515:
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)
517: CSC_PLAN_LINES_PKG.Update_Row(
518: p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,
519: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
520: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
521: p_CREATION_DATE => SYSDATE,
522: p_LAST_UPDATE_DATE => SYSDATE,
515:
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)
517: CSC_PLAN_LINES_PKG.Update_Row(
518: p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,
519: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
520: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
521: p_CREATION_DATE => SYSDATE,
522: p_LAST_UPDATE_DATE => SYSDATE,
523: p_CREATED_BY => FND_GLOBAL.USER_ID,
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)
517: CSC_PLAN_LINES_PKG.Update_Row(
518: p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,
519: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
520: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
521: p_CREATION_DATE => SYSDATE,
522: p_LAST_UPDATE_DATE => SYSDATE,
523: p_CREATED_BY => FND_GLOBAL.USER_ID,
524: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
522: p_LAST_UPDATE_DATE => SYSDATE,
523: p_CREATED_BY => FND_GLOBAL.USER_ID,
524: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
525: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
526: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
527: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
528: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
523: p_CREATED_BY => FND_GLOBAL.USER_ID,
524: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
525: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
526: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
527: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
528: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
524: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
525: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
526: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
527: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
528: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
525: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
526: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
527: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
528: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
526: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
527: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
528: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
527: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
528: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
528: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
539: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
539: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
540: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
539: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
540: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
541: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
539: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
540: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
541: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
542: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
539: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
540: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
541: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
542: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
543:
536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
539: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
540: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
541: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
542: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
543:
544: -- Standard check for p_commit
537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
539: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
540: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
541: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
542: x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
543:
544: -- Standard check for p_commit
545: IF FND_API.to_Boolean( p_commit )
624:
625: -- Initialize API return status to SUCCESS
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: -- Invoke table handler(CSC_PLAN_LINES_PKG.Delete_Row)
629: CSC_PLAN_LINES_PKG.Delete_Row(
630: p_PLAN_ID => P_PLAN_ID,
631: p_LINE_ID => P_LINE_ID);
632:
625: -- Initialize API return status to SUCCESS
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: -- Invoke table handler(CSC_PLAN_LINES_PKG.Delete_Row)
629: CSC_PLAN_LINES_PKG.Delete_Row(
630: p_PLAN_ID => P_PLAN_ID,
631: p_LINE_ID => P_LINE_ID);
632:
633: -- Standard check for p_commit
690: )
691: IS
692: cursor check_dup_line_id is
693: select line_id
694: from CSC_PLAN_LINES
695: where line_id = p_line_id;
696:
697: l_line_id number;
698: l_api_name varchar2(30) := 'Validate_Line_Id';
817: where id = p_condition_id;
818:
819: cursor c2 is
820: select 1
821: from csc_plan_lines
822: where plan_id = p_plan_id
823: and condition_id = p_condition_id;
824:
825: l_id NUMBER;
928:
929: END Validate_OBJECT_VERSION_NUMBER;
930:
931:
932: PROCEDURE Validate_csc_plan_lines(
933: P_Init_Msg_List IN VARCHAR2,
934: P_Validation_level IN NUMBER,
935: P_Validation_mode IN VARCHAR2,
936: P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
932: PROCEDURE Validate_csc_plan_lines(
933: P_Init_Msg_List IN VARCHAR2,
934: P_Validation_level IN NUMBER,
935: P_Validation_mode IN VARCHAR2,
936: P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
937: X_Return_Status OUT NOCOPY VARCHAR2,
938: X_Msg_Count OUT NOCOPY NUMBER,
939: X_Msg_Data OUT NOCOPY VARCHAR2
940: )
938: X_Msg_Count OUT NOCOPY NUMBER,
939: X_Msg_Data OUT NOCOPY VARCHAR2
940: )
941: IS
942: l_api_name CONSTANT VARCHAR2(30) := 'Validate_csc_plan_lines';
943: BEGIN
944: -- Initialize API return status to SUCCESS
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
948: Validate_LINE_ID(
949: p_init_msg_list => FND_API.G_FALSE,
950: p_validation_mode => p_validation_mode,
951: p_LINE_ID => P_CSC_PLAN_LINES_Rec.LINE_ID,
952: x_return_status => x_return_status,
953: x_msg_count => x_msg_count,
954: x_msg_data => x_msg_data);
955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
958:
959: Validate_PLAN_ID(
960: p_init_msg_list => FND_API.G_FALSE,
961: p_validation_mode => p_validation_mode,
962: p_PLAN_ID => P_CSC_PLAN_LINES_Rec.PLAN_ID,
963: x_return_status => x_return_status,
964: x_msg_count => x_msg_count,
965: x_msg_data => x_msg_data);
966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
969:
970: Validate_CONDITION_ID(
971: p_init_msg_list => FND_API.G_FALSE,
972: p_validation_mode => p_validation_mode,
973: P_PLAN_ID => P_CSC_PLAN_LINES_REC.PLAN_ID,
974: p_CONDITION_ID => P_CSC_PLAN_LINES_Rec.CONDITION_ID,
975: x_return_status => x_return_status,
976: x_msg_count => x_msg_count,
977: x_msg_data => x_msg_data);
970: Validate_CONDITION_ID(
971: p_init_msg_list => FND_API.G_FALSE,
972: p_validation_mode => p_validation_mode,
973: P_PLAN_ID => P_CSC_PLAN_LINES_REC.PLAN_ID,
974: p_CONDITION_ID => P_CSC_PLAN_LINES_Rec.CONDITION_ID,
975: x_return_status => x_return_status,
976: x_msg_count => x_msg_count,
977: x_msg_data => x_msg_data);
978:
981: END IF;
982: END IF;
983:
984:
985: END Validate_csc_plan_lines;
986:
987: End CSC_PLAN_LINES_PVT;
983:
984:
985: END Validate_csc_plan_lines;
986:
987: End CSC_PLAN_LINES_PVT;