DBA Data[Home] [Help]

APPS.CSC_PLAN_LINES_PVT dependencies on CSC_PLAN_LINES

Line 1: PACKAGE BODY CSC_PLAN_LINES_PVT as

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

Line 4: -- Package name : CSC_PLAN_LINES_PVT

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 :

Line 6: -- on CSC_PLAN_LINES table. It contains procedures to perform item

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.

Line 23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_PLAN_LINES_PVT';

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,

Line 52: x_csc_plan_lines_rec OUT NOCOPY CSC_PLAN_LINES_REC_TYPE)

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 ;

Line 55: x_csc_plan_lines_rec.LINE_ID := P_LINE_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 ;

Line 56: x_csc_plan_lines_rec.PLAN_ID := P_PLAN_ID ;

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 ;

Line 57: x_csc_plan_lines_rec.CONDITION_ID := P_CONDITION_ID ;

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 ;

Line 58: x_csc_plan_lines_rec.CREATION_DATE := P_CREATION_DATE ;

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 ;

Line 59: x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;

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 ;

Line 60: x_csc_plan_lines_rec.CREATED_BY := P_CREATED_BY ;

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 ;

Line 61: x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;

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 ;

Line 62: x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;

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 ;

Line 63: x_csc_plan_lines_rec.ATTRIBUTE1 := P_ATTRIBUTE1 ;

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 ;

Line 64: x_csc_plan_lines_rec.ATTRIBUTE2 := P_ATTRIBUTE2 ;

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 ;

Line 65: x_csc_plan_lines_rec.ATTRIBUTE3 := P_ATTRIBUTE3 ;

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 ;

Line 66: x_csc_plan_lines_rec.ATTRIBUTE4 := P_ATTRIBUTE4 ;

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 ;

Line 67: x_csc_plan_lines_rec.ATTRIBUTE5 := P_ATTRIBUTE5 ;

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 ;

Line 68: x_csc_plan_lines_rec.ATTRIBUTE6 := P_ATTRIBUTE6 ;

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 ;

Line 69: x_csc_plan_lines_rec.ATTRIBUTE7 := P_ATTRIBUTE7 ;

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 ;

Line 70: x_csc_plan_lines_rec.ATTRIBUTE8 := P_ATTRIBUTE8 ;

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 ;

Line 71: x_csc_plan_lines_rec.ATTRIBUTE9 := P_ATTRIBUTE9 ;

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 ;

Line 72: x_csc_plan_lines_rec.ATTRIBUTE10 := P_ATTRIBUTE10 ;

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 ;

Line 73: x_csc_plan_lines_rec.ATTRIBUTE11 := P_ATTRIBUTE11 ;

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 ;

Line 74: x_csc_plan_lines_rec.ATTRIBUTE12 := P_ATTRIBUTE12 ;

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 ;

Line 75: x_csc_plan_lines_rec.ATTRIBUTE13 := P_ATTRIBUTE13 ;

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 ;

Line 76: x_csc_plan_lines_rec.ATTRIBUTE14 := P_ATTRIBUTE14 ;

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:

Line 77: x_csc_plan_lines_rec.ATTRIBUTE15 := P_ATTRIBUTE15 ;

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;

Line 78: x_csc_plan_lines_rec.ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY ;

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:

Line 79: x_csc_plan_lines_rec.OBJECT_VERSION_NUMBER := P_OBJECT_VERSION_NUMBER ;

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:

Line 124: l_csc_plan_lines_rec CSC_PLAN_LINES_REC_TYPE;

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,

Line 153: x_csc_plan_lines_rec => l_csc_plan_lines_rec);

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(

Line 162: P_CSC_PLAN_LINES_Rec => l_csc_plan_lines_rec,

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,

Line 178: P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,

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,

Line 229: Validate_csc_plan_lines(

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,

Line 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

Line 242: -- Invoke table handler(CSC_PLAN_LINES_PKG.Insert_Row)

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,

Line 243: CSC_PLAN_LINES_PKG.Insert_Row(

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,

Line 245: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,

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,

Line 246: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_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,

Line 252: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,

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,

Line 253: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,

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,

Line 254: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,

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,

Line 255: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,

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,

Line 256: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,

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,

Line 257: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,

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,

Line 258: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,

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,

Line 259: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,

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,

Line 260: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,

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,

Line 261: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,

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,

Line 262: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,

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,

Line 263: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,

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,

Line 264: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,

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);

Line 265: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,

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:

Line 266: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,

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

Line 267: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,

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 )

Line 356: l_csc_plan_lines_rec CSC_PLAN_LINES_REC_TYPE;

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,

Line 385: x_csc_plan_lines_rec => l_csc_plan_lines_rec);

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(

Line 394: P_CSC_PLAN_LINES_Rec => l_csc_plan_lines_rec,

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 );

Line 407: P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,

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

Line 424: From CSC_PLAN_LINES

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';

Line 431: l_ref_CSC_PLAN_LINES_rec CSC_plan_lines_PVT.CSC_PLAN_LINES_Rec_Type;

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

Line 432: l_tar_CSC_PLAN_LINES_rec CSC_plan_lines_PVT.CSC_PLAN_LINES_Rec_Type := P_CSC_PLAN_LINES_Rec;

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;

Line 456: Open C_Get_plan_lines( l_tar_CSC_PLAN_LINES_rec.LINE_ID);

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,

Line 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,

Line 461: l_ref_CSC_PLAN_LINES_rec.PLAN_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,
465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,

Line 462: l_ref_CSC_PLAN_LINES_rec.CONDITION_ID,

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,

Line 463: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,

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,

Line 464: l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,

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,

Line 465: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,

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,

Line 466: l_ref_CSC_PLAN_LINES_rec.CREATED_BY,

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,

Line 467: l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,

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,

Line 468: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,

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,

Line 469: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,

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,

Line 470: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,

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,

Line 471: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,

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,

Line 472: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,

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,

Line 473: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,

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,

Line 474: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,

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,

Line 475: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,

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,

Line 476: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,

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,

Line 477: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,

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,

Line 478: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,

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,

Line 479: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,

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,

Line 480: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,

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;

Line 481: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,

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:

Line 482: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,

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

Line 483: l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,

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)

Line 484: l_ref_CSC_PLAN_LINES_rec.OBJECT_VERSION_NUMBER;

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

Line 502: Validate_csc_plan_lines(

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,

Line 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;

Line 516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)

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,

Line 517: CSC_PLAN_LINES_PKG.Update_Row(

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,

Line 518: p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,

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,

Line 519: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,

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,

Line 520: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_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,

Line 526: p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,

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,

Line 527: p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,

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,

Line 528: p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,

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,

Line 529: p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,

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,

Line 530: p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,

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,

Line 531: p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,

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,

Line 532: p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,

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,

Line 533: p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,

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,

Line 534: p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,

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,

Line 535: p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,

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,

Line 536: p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,

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,

Line 537: p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,

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,

Line 538: p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,

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);

Line 539: p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,

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:

Line 540: p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,

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

Line 541: p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,

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 )

Line 628: -- Invoke table handler(CSC_PLAN_LINES_PKG.Delete_Row)

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:

Line 629: CSC_PLAN_LINES_PKG.Delete_Row(

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

Line 694: from CSC_PLAN_LINES

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';

Line 821: from csc_plan_lines

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;

Line 932: PROCEDURE Validate_csc_plan_lines(

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,

Line 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: )

Line 942: l_api_name CONSTANT VARCHAR2(30) := 'Validate_csc_plan_lines';

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:

Line 951: p_LINE_ID => P_CSC_PLAN_LINES_Rec.LINE_ID,

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

Line 962: p_PLAN_ID => P_CSC_PLAN_LINES_Rec.PLAN_ID,

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

Line 973: P_PLAN_ID => P_CSC_PLAN_LINES_REC.PLAN_ID,

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);

Line 974: p_CONDITION_ID => P_CSC_PLAN_LINES_Rec.CONDITION_ID,

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:

Line 985: END Validate_csc_plan_lines;

981: END IF;
982: END IF;
983:
984:
985: END Validate_csc_plan_lines;
986:
987: End CSC_PLAN_LINES_PVT;

Line 987: End CSC_PLAN_LINES_PVT;

983:
984:
985: END Validate_csc_plan_lines;
986:
987: End CSC_PLAN_LINES_PVT;