27:
28: -- Id of record inserted into CSC_CUST_PLANS_AUDIT when-ever and insert, update or
29: -- a delete is performed on the CSC_CUST_PLANS table.
30: -- NOCOPY changes made for OUT NOCOPY parameters
31: G_PLAN_AUDIT_ID NUMBER := FND_API.G_MISS_NUM;
32:
33: TYPE CSC_CUST_PLANS_Rec_Type IS RECORD
34: (
35: CUST_PLAN_ID NUMBER ,
35: CUST_PLAN_ID NUMBER ,
36: PLAN_ID NUMBER,
37: PARTY_ID NUMBER,
38: CUST_ACCOUNT_ID NUMBER,
39: -- CUST_ACCOUNT_ORG NUMBER := FND_API.G_MISS_NUM,,
40: START_DATE_ACTIVE DATE ,
41: END_DATE_ACTIVE DATE,
42: MANUAL_FLAG VARCHAR2(3),
43: PLAN_STATUS_CODE VARCHAR2(30),
99: -- handler to insert record into CSC_CUST_PLANS table.
100: -- Parameters:
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
107: --
100: -- Parameters:
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
107: --
108: -- OUT NOCOPY:
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
107: --
108: -- OUT NOCOPY:
109: -- x_cust_plan_id OUT NOCOPY NUMBER
136: -- Pre-Req :
137: -- Parameters:
138: -- IN
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
137: -- Parameters:
138: -- IN
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
138: -- IN
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
139: -- p_api_version_number IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
140: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
141: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
142: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
143: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
144: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
145: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
146: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
147: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
148: -- P_PLAN_NAME IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
149: -- P_GROUP_NAME IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
150: -- P_PARTY_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
151: -- P_PARTY_NAME IN VARCHAR2(255) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
152: -- P_PARTY_TYPE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
153: -- P_ACCOUNT_NUMBER IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
154: -- P_ACCOUNT_NAME IN VARCHAR2(240) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
155: -- P_PRIORITY IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
156: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
157: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
158: -- P_CUSTOMIZED_PLAN IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
159: -- P_USE_FOR_CUST_ACCOUNT IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
160: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
161: -- P_PLAN_STATUS_MEANING IN VARCHAR2(80) := FND_API.G_MISS_CHAR,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
162: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
163: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
164: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
165: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
166: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
167: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
168: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
169: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
170: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
171: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
172: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
173: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
174: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
175: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
176: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
177: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
178: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
186: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
179: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
186: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
187: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
180: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
186: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
187: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
188: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
181: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
186: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
187: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
188: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
189: --
182: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
186: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
187: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
188: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
189: --
190: -- X_CUST_PLAN_ID OUT NOCOPY NUMBER,
183: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
186: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
187: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
188: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
189: --
190: -- X_CUST_PLAN_ID OUT NOCOPY NUMBER,
191: -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
184: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
185: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
186: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
187: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
188: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
189: --
190: -- X_CUST_PLAN_ID OUT NOCOPY NUMBER,
191: -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
192: -- x_return_status OUT NOCOPY VARCHAR2
254: -- to update the record in CSC_CUST_PLANS.
255: -- Parameters:
256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
262: --
255: -- Parameters:
256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
262: --
263: -- OUT NOCOPY :
256: -- IN
257: -- p_api_version_number IN NUMBER Required
258: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
259: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
260: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
261: -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
262: --
263: -- OUT NOCOPY :
264: -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
290: -- Pre-Req :
291: -- Parameters:
292: -- IN
293: -- p_api_version_number IN NUMBER Required
294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
291: -- Parameters:
292: -- IN
293: -- p_api_version_number IN NUMBER Required
294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
292: -- IN
293: -- p_api_version_number IN NUMBER Required
294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
293: -- p_api_version_number IN NUMBER Required
294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
294: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
295: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
296: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
297: -- P_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
298: -- P_CUST_PLAN_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
299: -- P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
300: -- P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
301: -- P_CUST_ACCOUNT_ORG IN NUMBER := FND_API.G_MISS_NUM,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
302: -- P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
303: -- P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
304: -- P_MANUAL_FLAG IN VARCHAR2(3) := FND_API.G_MISS_CHAR,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
305: -- P_PLAN_STATUS_CODE IN VARCHAR2(30) := FND_API.G_MISS_CHAR,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
306: -- P_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
307: -- P_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
308: -- P_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
309: -- P_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
310: -- P_CREATION_DATE IN DATE := FND_API.G_MISS_DATE,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
311: -- P_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
312: -- P_CREATED_BY IN NUMBER := FND_API.G_MISS_NUM,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
313: -- P_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
314: -- P_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
315: -- P_ATTRIBUTE1 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
316: -- P_ATTRIBUTE2 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
317: -- P_ATTRIBUTE3 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
318: -- P_ATTRIBUTE4 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
319: -- P_ATTRIBUTE5 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
320: -- P_ATTRIBUTE6 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
328: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
321: -- P_ATTRIBUTE7 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
328: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
329: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
322: -- P_ATTRIBUTE8 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
328: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
329: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
330: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
323: -- P_ATTRIBUTE9 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
328: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
329: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
330: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
331: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
324: -- P_ATTRIBUTE10 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
328: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
329: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
330: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
331: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
332: --
325: -- P_ATTRIBUTE11 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
328: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
329: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
330: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
331: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
332: --
333: -- OUT NOCOPY :
326: -- P_ATTRIBUTE12 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
328: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
329: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
330: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
331: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
332: --
333: -- OUT NOCOPY :
334: -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
327: -- P_ATTRIBUTE13 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
328: -- P_ATTRIBUTE14 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
329: -- P_ATTRIBUTE15 IN VARCHAR2(450) := FND_API.G_MISS_CHAR,
330: -- P_ATTRIBUTE_CATEGORY IN VARCHAR2(90) := FND_API.G_MISS_CHAR,
331: -- P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM
332: --
333: -- OUT NOCOPY :
334: -- X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
335: -- x_return_status OUT NOCOPY VARCHAR2
395: -- CSC_CUST_PLANS.
396: -- Parameters:
397: -- IN
398: -- p_api_version_number IN NUMBER Required
399: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
400: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
401: -- p_plan_id IN NUMBER Required
402: -- p_party_id_tbl IN CSC_PARTY_ID_TBL_TYPE
403: -- Required
396: -- Parameters:
397: -- IN
398: -- p_api_version_number IN NUMBER Required
399: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
400: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
401: -- p_plan_id IN NUMBER Required
402: -- p_party_id_tbl IN CSC_PARTY_ID_TBL_TYPE
403: -- Required
404: -- p_plan_status_code IN VARCHAR2 Optional Default =
434: -- CSC_CUST_PLANS.
435: -- Parameters:
436: -- IN
437: -- p_api_version_number IN NUMBER Required
438: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
439: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
440: -- p_plan_id IN NUMBER Required
441: -- p_party_id_tbl IN CSC_PARTY_ID_TBL_TYPE
442: -- Required
435: -- Parameters:
436: -- IN
437: -- p_api_version_number IN NUMBER Required
438: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
439: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
440: -- p_plan_id IN NUMBER Required
441: -- p_party_id_tbl IN CSC_PARTY_ID_TBL_TYPE
442: -- Required
443: -- p_plan_status_code IN NUMBER Optional Default =
473: -- CSC_CUST_PLANS.
474: -- Parameters:
475: -- IN
476: -- p_api_version_number IN NUMBER Required
477: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
478: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
479: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
480: -- P_CUST_PLAN_ID IN NUMBER Required
481: --
474: -- Parameters:
475: -- IN
476: -- p_api_version_number IN NUMBER Required
477: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
478: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
479: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
480: -- P_CUST_PLAN_ID IN NUMBER Required
481: --
482: -- OUT NOCOPY :
475: -- IN
476: -- p_api_version_number IN NUMBER Required
477: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
478: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
479: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
480: -- P_CUST_PLAN_ID IN NUMBER Required
481: --
482: -- OUT NOCOPY :
483: -- x_return_status OUT NOCOPY VARCHAR2
508: -- parties, to the new customized plan id;
509: -- Parameters:
510: -- IN
511: -- p_api_version_number IN NUMBER Required
512: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
513: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
514: -- p_plan_id IN NUMBER Required
515: -- p_original_plan_id IN NUMBER Required
516: -- p_party_id IN NUMBER Required
509: -- Parameters:
510: -- IN
511: -- p_api_version_number IN NUMBER Required
512: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
513: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
514: -- p_plan_id IN NUMBER Required
515: -- p_original_plan_id IN NUMBER Required
516: -- p_party_id IN NUMBER Required
517: -- p_cust_account_id IN NUMBER Optional Default = NULL
554: --
555: -- Parameters:
556: -- IN
557: -- p_api_version_number IN NUMBER Required
558: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
559: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
560: -- p_where_clause IN VARCHAR2
561: --
562: -- OUT NOCOPY :
555: -- Parameters:
556: -- IN
557: -- p_api_version_number IN NUMBER Required
558: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
559: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
560: -- p_where_clause IN VARCHAR2
561: --
562: -- OUT NOCOPY :
563: -- x_cust_plan_id OUT NOCOPY NUMBER
586: -- Pre-Req :
587: -- Function:
588: -- Parameters:
589: -- IN
590: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
591: -- p_validation_mode IN VARCHAR2 Required
592: -- P_CUST_PLAN_ID IN NUMBER Required
593: --
594: -- OUT NOCOPY :
616: -- Pre-Req :
617: -- Function:
618: -- Parameters:
619: -- IN
620: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
621: -- p_validation_mode IN VARCHAR2 Required
622: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
623: -- P_PLAN_ID IN NUMBER Required
624: --
647: -- Pre-Req :
648: -- Function:
649: -- Parameters:
650: -- IN
651: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
652: -- p_validation_mode IN VARCHAR2 Required
653: -- P_PARTY_ID IN NUMBER Required
654: --
655: -- OUT NOCOPY :
679: -- Pre-Req :
680: -- Function:
681: -- Parameters:
682: -- IN
683: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
684: -- p_validation_mode IN VARCHAR2 Required
685: -- P_Party_Id IN NUMBER Required
686: -- P_Cust_Account_Id IN NUMBER Required
687: -- P_Cust_Account_Org IN NUMBER Required
695: -- End of Comments
696: --
697: /****
698: PROCEDURE Validate_CUST_ACC_ORG_ID (
699: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
700: P_Validation_mode IN VARCHAR2,
701: P_PARTY_ID IN NUMBER,
702: P_CUST_ACCOUNT_ID IN NUMBER,
703: P_CUST_ACCOUNT_ORG IN NUMBER,
715: -- Pre-Req :
716: -- Function:
717: -- Parameters:
718: -- IN
719: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
720: -- p_validation_mode IN NUMBER Required
721: -- P_MANUAL_FLAG IN VARCHAR2 Required
722: --
723: -- OUT NOCOPY :
746: -- Pre-Req :
747: -- Function:
748: -- Parameters:
749: -- IN
750: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
751: -- p_validation_mode IN NUMBER Required
752: -- P_Plan_Status_Code IN VARCHAR2 Required
753: --
754: -- OUT NOCOPY :
776: -- Pre-Req :
777: -- Function:
778: -- Parameters:
779: -- IN
780: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
781: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
782: -- p_validation_mode IN VARCHAR2 Required
783: -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
784: --
777: -- Function:
778: -- Parameters:
779: -- IN
780: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
781: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
782: -- p_validation_mode IN VARCHAR2 Required
783: -- P_CSC_CUST_PLANS_Rec IN CSC_CUST_PLANS_Rec_Type Required
784: --
785: -- OUT NOCOPY :