68: G_MISS_CSC_PLAN_HEADERS_B_REC CSC_PLAN_HEADERS_B_REC_TYPE;
69:
70: /*
71: TYPE CSC_PARTY_ID_REC_TYPE IS RECORD (
72: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
73: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
74: CUST_ACCOUNT_ORG NUMBER := FND_API.G_MISS_NUM );
75:
76: TYPE CSC_PARTY_ID_TBL_TYPE IS TABLE OF CSC_PARTY_ID_REC_TYPE
69:
70: /*
71: TYPE CSC_PARTY_ID_REC_TYPE IS RECORD (
72: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
73: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
74: CUST_ACCOUNT_ORG NUMBER := FND_API.G_MISS_NUM );
75:
76: TYPE CSC_PARTY_ID_TBL_TYPE IS TABLE OF CSC_PARTY_ID_REC_TYPE
77: INDEX BY BINARY_INTEGER;
70: /*
71: TYPE CSC_PARTY_ID_REC_TYPE IS RECORD (
72: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
73: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
74: CUST_ACCOUNT_ORG NUMBER := FND_API.G_MISS_NUM );
75:
76: TYPE CSC_PARTY_ID_TBL_TYPE IS TABLE OF CSC_PARTY_ID_REC_TYPE
77: INDEX BY BINARY_INTEGER;
78: G_MISS_PARTY_ID_TBL CSC_PARTY_ID_TBL_TYPE;
86: -- Pre-Req : None.
87: -- Parameters:
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
94: -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
87: -- Parameters:
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
94: -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
95: -- -- table
88: -- IN
89: -- p_api_version_number IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93: -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
94: -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
95: -- -- table
96: -- P_NAME IN VARCHAR2 Required -- Plan name for translation table.
140: -- Pre-Req : None.
141: -- Parameters:
142: -- IN
143: -- p_api_version_number IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
147: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
141: -- Parameters:
142: -- IN
143: -- p_api_version_number IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
147: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
142: -- IN
143: -- p_api_version_number IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
147: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
143: -- p_api_version_number IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
147: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
147: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
152: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
147: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
152: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
153: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
146: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
147: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
152: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
153: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
154: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
147: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
152: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
153: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
154: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
155: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
148: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
152: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
153: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
154: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
155: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
156: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
149: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
150: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
152: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
153: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
154: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
155: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
156: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
157: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
151: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
152: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
153: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
154: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
155: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
156: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
157: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
158: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
152: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
153: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
154: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
155: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
156: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
157: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
158: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
153: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
154: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
155: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
156: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
157: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
158: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
154: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
155: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
156: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
157: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
158: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
155: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
156: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
157: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
158: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
156: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
157: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
158: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
157: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
158: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
158: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
159: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
160: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
161: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
162: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
163: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
164: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
165: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
166: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
167: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
168: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
169: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
170: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
171: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
179: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
172: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
179: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
180: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
173: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
179: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
180: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
181: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
174: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
179: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
180: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
181: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
182: -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
175: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
179: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
180: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
181: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
182: -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
183: -- -- table
176: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
179: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
180: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
181: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
182: -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
183: -- -- table
184: -- P_NAME IN VARCHAR2 Required -- Plan name for translation table.
177: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
178: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
179: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
180: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
181: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
182: -- P_DESCRIPTION IN VARCHAR2 Required -- Plan description for translation
183: -- -- table
184: -- P_NAME IN VARCHAR2 Required -- Plan name for translation table.
185: -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
261: -- Function: Procedure to update a plan header. Updates record into CSC_PLAN_HEADERS_B
262: -- Parameters:
263: -- IN
264: -- p_api_version_number IN NUMBER Required
265: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
266: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
267: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268: -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
269: -- P_DESCRIPTION IN VARCHAR2 Required
262: -- Parameters:
263: -- IN
264: -- p_api_version_number IN NUMBER Required
265: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
266: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
267: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268: -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
269: -- P_DESCRIPTION IN VARCHAR2 Required
270: -- P_NAME IN VARCHAR2 Required
263: -- IN
264: -- p_api_version_number IN NUMBER Required
265: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
266: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
267: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
268: -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE Required
269: -- P_DESCRIPTION IN VARCHAR2 Required
270: -- P_NAME IN VARCHAR2 Required
271: -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
315: -- Function: Procedure to update a plan header. Updates record into CSC_PLAN_HEADERS_B
316: -- Parameters:
317: -- IN
318: -- p_api_version_number IN NUMBER Required
319: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
320: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
322: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
316: -- Parameters:
317: -- IN
318: -- p_api_version_number IN NUMBER Required
319: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
320: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
322: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
317: -- IN
318: -- p_api_version_number IN NUMBER Required
319: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
320: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
322: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
318: -- p_api_version_number IN NUMBER Required
319: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
320: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
322: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
319: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
320: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
322: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
327: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
320: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
322: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
327: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
328: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
321: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
322: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
327: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
328: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
329: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
322: -- p_ROW_ID IN ROWID := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
327: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
328: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
329: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
330: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
323: -- p_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
327: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
328: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
329: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
330: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
331: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
324: -- p_ORIGINAL_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM
325: -- p_PLAN_GROUP_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
327: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
328: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
329: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
330: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
331: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
332: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
326: -- p_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
327: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
328: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
329: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
330: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
331: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
332: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
333: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
327: -- p_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE
328: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
329: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
330: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
331: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
332: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
333: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
328: -- p_USE_FOR_CUST_ACCOUNT IN VARCHAR2(1) := FND_API.G_MISS_CHAR
329: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
330: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
331: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
332: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
333: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
329: -- p_END_USER_TYPE IN VARCHAR2(30):= CSC_CORE_UTILS_PVT.G_MISS_CHAR
330: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
331: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
332: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
333: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
330: -- p_CUSTOMIZED_PLAN IN VARCHAR2(1) := FND_API.G_MISS_CHAR
331: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
332: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
333: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
331: -- p_PROFILE_CHECK_ID IN NUMBER := FND_API.G_MISS_NUM
332: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
333: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
332: -- p_RELATIONAL_OPERATOR IN VARCHAR2(30) := FND_API.G_MISS_CHAR
333: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
333: -- p_CRITERIA_VALUE_HIGH IN VARCHAR2(50) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
334: -- p_CRITERIA_VALUE_LOW IN VARCHAR2(50) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
335: -- p_CREATION_DATE IN DATE := FND_API.G_MISS_DATE
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
336: -- p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
337: -- p_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
338: -- p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
339: -- p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
340: -- p_ATTRIBUTE1 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
341: -- p_ATTRIBUTE2 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
342: -- p_ATTRIBUTE3 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
343: -- p_ATTRIBUTE4 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
344: -- p_ATTRIBUTE5 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
345: -- p_ATTRIBUTE6 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
346: -- p_ATTRIBUTE7 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
354: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
347: -- p_ATTRIBUTE8 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
354: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
355: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
348: -- p_ATTRIBUTE9 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
354: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
355: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
356: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
349: -- p_ATTRIBUTE10 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
354: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
355: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
356: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
357: -- P_DESCRIPTION IN VARCHAR2 Required
350: -- p_ATTRIBUTE11 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
354: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
355: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
356: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
357: -- P_DESCRIPTION IN VARCHAR2 Required
358: -- P_NAME IN VARCHAR2 Required
351: -- p_ATTRIBUTE12 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
354: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
355: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
356: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
357: -- P_DESCRIPTION IN VARCHAR2 Required
358: -- P_NAME IN VARCHAR2 Required
359: -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
352: -- p_ATTRIBUTE13 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
353: -- p_ATTRIBUTE14 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
354: -- p_ATTRIBUTE15 IN VARCHAR2(150) := FND_API.G_MISS_CHAR
355: -- p_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR
356: -- p_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
357: -- P_DESCRIPTION IN VARCHAR2 Required
358: -- P_NAME IN VARCHAR2 Required
359: -- P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE
360: -- Optional Default =
437: -- CSC_PLAN_HEADERS_B table to sysdate + 1.
438: -- Parameters:
439: -- IN
440: -- p_api_version_number IN NUMBER Required
441: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
442: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
443: -- p_plan_id IN NUMBER
444: --
445: -- OUT :
438: -- Parameters:
439: -- IN
440: -- p_api_version_number IN NUMBER Required
441: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
442: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
443: -- p_plan_id IN NUMBER
444: --
445: -- OUT :
446: -- x_return_status OUT NOCOPY VARCHAR2
452: --
453:
454: PROCEDURE Disable_plan(
455: P_Api_Version_Number IN NUMBER,
456: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
457: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
458: p_plan_id IN NUMBER,
459: X_Return_Status OUT NOCOPY VARCHAR2,
460: X_Msg_Count OUT NOCOPY NUMBER,
453:
454: PROCEDURE Disable_plan(
455: P_Api_Version_Number IN NUMBER,
456: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
457: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
458: p_plan_id IN NUMBER,
459: X_Return_Status OUT NOCOPY VARCHAR2,
460: X_Msg_Count OUT NOCOPY NUMBER,
461: X_Msg_Data OUT NOCOPY VARCHAR2
472: -- Parameters:
473: -- IN
474: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
475: -- For create: G_CREATE, for update: G_UPDATE
476: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
477: -- p_validation_mode IN VARCHAR2
478: -- p_plan_id IN NUMBER
479: --
480: -- OUT :
505: -- Parameters:
506: -- IN
507: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
508: -- For create: G_CREATE, for update: G_UPDATE
509: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
510: -- p_validation_mode IN VARCHAR2
511: -- p_plan_name IN NUMBER
512: --
513: -- OUT :
538: -- Parameters:
539: -- IN
540: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
541: -- For create: G_CREATE, for update: G_UPDATE
542: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
543: -- p_validation_mode IN VARCHAR2
544: -- p_original_plan_id IN NUMBER
545: -- p_customized_plan IN VARCHAR2 Optional Default = 'N'
546: --
573: -- Parameters:
574: -- IN
575: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
576: -- For create: G_CREATE, for update: G_UPDATE
577: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
578: -- p_validation_mode IN VARCHAR2
579: -- p_plan_group_code IN NUMBER
580: --
581: -- OUT :
605: -- Parameters:
606: -- IN
607: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
608: -- For create: G_CREATE, for update: G_UPDATE
609: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
610: -- p_validation_mode IN VARCHAR2
611: -- p_plan_id IN NUMBER
612: -- p_use_for_cust_account IN NUMBER
613: -- p_old_use_for_cust_account IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
609: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
610: -- p_validation_mode IN VARCHAR2
611: -- p_plan_id IN NUMBER
612: -- p_use_for_cust_account IN NUMBER
613: -- p_old_use_for_cust_account IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
614: --
615: -- OUT :
616: -- x_return_status OUT NOCOPY VARCHAR2
617: -- x_msg_count OUT NOCOPY NUMBER
643: -- Parameters:
644: -- IN
645: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
646: -- For create: G_CREATE, for update: G_UPDATE
647: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
648: -- p_validation_mode IN VARCHAR2
649: -- p_end_user_type IN VARCHAR2
650: --
651: -- OUT :
675: -- Parameters:
676: -- IN
677: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
678: -- For create: G_CREATE, for update: G_UPDATE
679: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
680: -- p_validation_mode IN VARCHAR2
681: -- p_customized_plan IN NUMBER
682: --
683: -- OUT :
707: -- Parameters:
708: -- IN
709: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
710: -- For create: G_CREATE, for update: G_UPDATE
711: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
712: -- p_validation_mode IN VARCHAR2
713: -- p_plan_id IN NUMBER
714: -- p_profile_check_id IN NUMBER
715: -- p_old_profile_check_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
711: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
712: -- p_validation_mode IN VARCHAR2
713: -- p_plan_id IN NUMBER
714: -- p_profile_check_id IN NUMBER
715: -- p_old_profile_check_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
716: --
717: -- OUT :
718: -- x_return_status OUT NOCOPY VARCHAR2
719: -- x_msg_count OUT NOCOPY NUMBER
743: -- Parameters:
744: -- IN
745: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
746: -- For create: G_CREATE, for update: G_UPDATE
747: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
748: -- p_validation_mode IN VARCHAR2
749: -- p_plan_id IN NUMBER
750: -- p_criteria_value_low IN NUMBER
751: -- p_old_criteria_value_low IN NUMBER Optional Default = FND_API.G_MISS_NUM
747: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
748: -- p_validation_mode IN VARCHAR2
749: -- p_plan_id IN NUMBER
750: -- p_criteria_value_low IN NUMBER
751: -- p_old_criteria_value_low IN NUMBER Optional Default = FND_API.G_MISS_NUM
752: --
753: -- OUT :
754: -- x_return_status OUT NOCOPY VARCHAR2
755: -- x_msg_count OUT NOCOPY NUMBER
779: -- Parameters:
780: -- IN
781: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
782: -- For create: G_CREATE, for update: G_UPDATE
783: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
784: -- p_validation_mode IN VARCHAR2
785: -- p_plan_id IN NUMBER
786: -- p_criteria_value_high IN VARCHAR2
787: -- p_old_criteria_value_high IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
783: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
784: -- p_validation_mode IN VARCHAR2
785: -- p_plan_id IN NUMBER
786: -- p_criteria_value_high IN VARCHAR2
787: -- p_old_criteria_value_high IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
788: --
789: -- OUT :
790: -- x_return_status OUT NOCOPY VARCHAR2
791: -- x_msg_count OUT NOCOPY NUMBER
815: -- Parameters:
816: -- IN
817: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
818: -- For create: G_CREATE, for update: G_UPDATE
819: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
820: -- p_validation_mode IN VARCHAR2
821: -- p_plan_id IN NUMBER
822: -- p_relational_operator IN VARCHAR2
823: -- p_old_relational_operator IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
819: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
820: -- p_validation_mode IN VARCHAR2
821: -- p_plan_id IN NUMBER
822: -- p_relational_operator IN VARCHAR2
823: -- p_old_relational_operator IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
824: --
825: -- OUT :
826: -- x_return_status OUT NOCOPY VARCHAR2
827: -- x_msg_count OUT NOCOPY NUMBER
853: -- Parameters:
854: -- IN
855: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
856: -- For create: G_CREATE, for update: G_UPDATE
857: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
858: -- p_validation_mode IN VARCHAR2
859: -- p_plan_id IN NUMBER
860: -- p_relational_operator IN VARCHAR2
861: -- p_criteria_value_low IN VARCHAR2
892: -- Parameters:
893: -- IN
894: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
895: -- For create: G_CREATE, for update: G_UPDATE
896: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
897: -- p_validation_mode IN VARCHAR2
898: -- p_plan_id IN NUMBER
899: -- p_start_date_active IN DATE
900: --
929: -- Parameters:
930: -- IN
931: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
932: -- For create: G_CREATE, for update: G_UPDATE
933: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
934: -- p_validation_mode IN VARCHAR2
935: -- p_plan_id IN NUMBER
936: -- p_end_date_active IN DATE
937: --
964: -- Parameters:
965: -- IN
966: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
967: -- For create: G_CREATE, for update: G_UPDATE
968: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
969: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
970: -- p_validation_mode IN VARCHAR2
971: -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE
972: -- P_OLD_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE
965: -- IN
966: -- p_validation_mode is a constant defined in CSC_CORE_UTILS_PVT package
967: -- For create: G_CREATE, for update: G_UPDATE
968: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
969: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
970: -- p_validation_mode IN VARCHAR2
971: -- P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE
972: -- P_OLD_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE
973: -- Optional Default = P_CSC_PLAN_HEADERS_B_REC