[Home] [Help]
101: P_ATTRIBUTE14 IN VARCHAR2,
102: P_ATTRIBUTE15 IN VARCHAR2,
103: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
104: P_OBJECT_VERSION_NUMBER IN NUMBER,
105: X_PVT_CSC_PLAN_HEADERS_B_REC OUT NOCOPY CSC_PLAN_HEADERS_B_REC_TYPE )
106: IS
107:
108: BEGIN
109: x_pvt_csc_plan_headers_b_rec.ROW_ID := p_row_id;
105: X_PVT_CSC_PLAN_HEADERS_B_REC OUT NOCOPY CSC_PLAN_HEADERS_B_REC_TYPE )
106: IS
107:
108: BEGIN
109: x_pvt_csc_plan_headers_b_rec.ROW_ID := p_row_id;
110: x_pvt_csc_plan_headers_b_rec.PLAN_ID := p_plan_id;
111: x_pvt_csc_plan_headers_b_rec.ORIGINAL_PLAN_ID := p_original_plan_id;
112: x_pvt_csc_plan_headers_b_rec.PLAN_GROUP_CODE := p_plan_group_code;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
106: IS
107:
108: BEGIN
109: x_pvt_csc_plan_headers_b_rec.ROW_ID := p_row_id;
110: x_pvt_csc_plan_headers_b_rec.PLAN_ID := p_plan_id;
111: x_pvt_csc_plan_headers_b_rec.ORIGINAL_PLAN_ID := p_original_plan_id;
112: x_pvt_csc_plan_headers_b_rec.PLAN_GROUP_CODE := p_plan_group_code;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
107:
108: BEGIN
109: x_pvt_csc_plan_headers_b_rec.ROW_ID := p_row_id;
110: x_pvt_csc_plan_headers_b_rec.PLAN_ID := p_plan_id;
111: x_pvt_csc_plan_headers_b_rec.ORIGINAL_PLAN_ID := p_original_plan_id;
112: x_pvt_csc_plan_headers_b_rec.PLAN_GROUP_CODE := p_plan_group_code;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
108: BEGIN
109: x_pvt_csc_plan_headers_b_rec.ROW_ID := p_row_id;
110: x_pvt_csc_plan_headers_b_rec.PLAN_ID := p_plan_id;
111: x_pvt_csc_plan_headers_b_rec.ORIGINAL_PLAN_ID := p_original_plan_id;
112: x_pvt_csc_plan_headers_b_rec.PLAN_GROUP_CODE := p_plan_group_code;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
109: x_pvt_csc_plan_headers_b_rec.ROW_ID := p_row_id;
110: x_pvt_csc_plan_headers_b_rec.PLAN_ID := p_plan_id;
111: x_pvt_csc_plan_headers_b_rec.ORIGINAL_PLAN_ID := p_original_plan_id;
112: x_pvt_csc_plan_headers_b_rec.PLAN_GROUP_CODE := p_plan_group_code;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
110: x_pvt_csc_plan_headers_b_rec.PLAN_ID := p_plan_id;
111: x_pvt_csc_plan_headers_b_rec.ORIGINAL_PLAN_ID := p_original_plan_id;
112: x_pvt_csc_plan_headers_b_rec.PLAN_GROUP_CODE := p_plan_group_code;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
111: x_pvt_csc_plan_headers_b_rec.ORIGINAL_PLAN_ID := p_original_plan_id;
112: x_pvt_csc_plan_headers_b_rec.PLAN_GROUP_CODE := p_plan_group_code;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
112: x_pvt_csc_plan_headers_b_rec.PLAN_GROUP_CODE := p_plan_group_code;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
113: x_pvt_csc_plan_headers_b_rec.START_DATE_ACTIVE := p_start_date_active;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
114: x_pvt_csc_plan_headers_b_rec.END_DATE_ACTIVE := p_end_date_active;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
115: x_pvt_csc_plan_headers_b_rec.USE_FOR_CUST_ACCOUNT := p_use_for_cust_account;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
116: x_pvt_csc_plan_headers_b_rec.END_USER_TYPE := p_end_user_type;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
117: x_pvt_csc_plan_headers_b_rec.CUSTOMIZED_PLAN := p_customized_plan;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
118: x_pvt_csc_plan_headers_b_rec.PROFILE_CHECK_ID := p_profile_check_id;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
119: x_pvt_csc_plan_headers_b_rec.RELATIONAL_OPERATOR := p_relational_operator;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
120: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_HIGH := p_criteria_value_high;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
121: x_pvt_csc_plan_headers_b_rec.CRITERIA_VALUE_LOW := p_criteria_value_low;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
122: x_pvt_csc_plan_headers_b_rec.CREATION_DATE := p_creation_date;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
123: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_DATE := p_last_update_date;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
124: x_pvt_csc_plan_headers_b_rec.CREATED_BY := p_created_by;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
125: x_pvt_csc_plan_headers_b_rec.LAST_UPDATED_BY := p_last_updated_by;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
126: x_pvt_csc_plan_headers_b_rec.LAST_UPDATE_LOGIN := p_last_update_login;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
127: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE1 := p_attribute1;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
128: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE2 := p_attribute2;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
129: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE3 := p_attribute3;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
130: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE4 := p_attribute4;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
131: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE5 := p_attribute5;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
132: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE6 := p_attribute6;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
140: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE14 := p_attribute14;
133: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE7 := p_attribute7;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
140: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE14 := p_attribute14;
141: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE15 := p_attribute15;
134: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE8 := p_attribute8;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
140: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE14 := p_attribute14;
141: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE15 := p_attribute15;
142: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE_CATEGORY := p_attribute_category;
135: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE9 := p_attribute9;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
140: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE14 := p_attribute14;
141: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE15 := p_attribute15;
142: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE_CATEGORY := p_attribute_category;
143: x_pvt_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER:= p_object_version_number;
136: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE10 := p_attribute10;
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
140: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE14 := p_attribute14;
141: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE15 := p_attribute15;
142: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE_CATEGORY := p_attribute_category;
143: x_pvt_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER:= p_object_version_number;
144:
137: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE11 := p_attribute11;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
140: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE14 := p_attribute14;
141: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE15 := p_attribute15;
142: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE_CATEGORY := p_attribute_category;
143: x_pvt_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER:= p_object_version_number;
144:
145: END convert_columns_to_rec_type;
138: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE12 := p_attribute12;
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
140: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE14 := p_attribute14;
141: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE15 := p_attribute15;
142: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE_CATEGORY := p_attribute_category;
143: x_pvt_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER:= p_object_version_number;
144:
145: END convert_columns_to_rec_type;
146:
139: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE13 := p_attribute13;
140: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE14 := p_attribute14;
141: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE15 := p_attribute15;
142: x_pvt_csc_plan_headers_b_rec.ATTRIBUTE_CATEGORY := p_attribute_category;
143: x_pvt_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER:= p_object_version_number;
144:
145: END convert_columns_to_rec_type;
146:
147:
195: X_Return_Status OUT NOCOPY VARCHAR2,
196: X_Msg_Count OUT NOCOPY NUMBER,
197: X_Msg_Data OUT NOCOPY VARCHAR2 )
198: IS
199: l_pvt_csc_plan_headers_b_rec CSC_PLAN_HEADERS_B_REC_TYPE;
200:
201: BEGIN
202: convert_columns_to_rec_type(
203: p_row_id => p_row_id,
234: P_ATTRIBUTE14 => p_attribute14,
235: P_ATTRIBUTE15 => p_attribute15,
236: P_ATTRIBUTE_CATEGORY => p_attribute_category,
237: P_OBJECT_VERSION_NUMBER => p_object_version_number,
238: X_PVT_CSC_PLAN_HEADERS_B_REC => l_pvt_csc_plan_headers_b_rec );
239:
240: /*** CALL PROCEDURE WITH RECORD TYPE STRUCTURE ***/
241:
242: create_plan_header(
243: p_api_version_number => p_api_version_number,
244: p_init_msg_list => p_init_msg_list,
245: p_commit => p_commit,
246: p_validation_level => p_validation_level,
247: p_csc_plan_headers_b_rec => l_pvt_csc_plan_headers_b_rec,
248: p_description => p_description,
249: p_name => p_name,
250: p_party_id_tbl => p_party_id_tbl,
251: x_plan_id => x_plan_id,
261: P_Api_Version_Number IN NUMBER,
262: P_Init_Msg_List IN VARCHAR2,
263: P_Commit IN VARCHAR2,
264: p_validation_level IN NUMBER,
265: P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
266: P_DESCRIPTION IN VARCHAR2,
267: P_NAME IN VARCHAR2,
268: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
269: X_PLAN_ID OUT NOCOPY NUMBER,
279: -- The following assignment is done, because the correct values have to be passed into the
280: -- table handler insert pkg. If FND_API.G_MISS_ is being passed in, then these values have to
281: -- be nullified because FND_API.G_MISS_NUM is a huge value and does not fit into most db
282: -- columns. These assignments are done before the call to the table handler API.
283: l_ins_plan_headers_b_rec CSC_PLAN_HEADERS_B_REC_TYPE := P_CSC_PLAN_HEADERS_B_REC;
284: l_name VARCHAR2(90) := P_NAME;
285: l_description VARCHAR2(720) := P_DESCRIPTION;
286:
287: -- A local party_id table type is declared because sometimes plans can be customized
332: Validate_csc_relationship_plan(
333: p_init_msg_list => FND_API.G_FALSE,
334: p_validation_level => p_validation_level,
335: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
336: P_CSC_PLAN_HEADERS_B_REC => P_CSC_PLAN_HEADERS_B_REC,
337: P_DESCRIPTION => p_description,
338: P_NAME => p_name,
339: x_return_status => x_return_status,
340: x_msg_count => x_msg_count,
360: -- NOTE : If parent plan which is customized is a PARTY level plan, then allow the
361: -- customization only at PARTY level, else return back and error status. The same
362: -- applies to ACCOUNT level plans.
363:
364: IF ( P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN = 'Y' ) then
365: Validate_ORIGINAL_PLAN_ID(
366: p_init_msg_list => FND_API.G_FALSE,
367: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
368: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
364: IF ( P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN = 'Y' ) then
365: Validate_ORIGINAL_PLAN_ID(
366: p_init_msg_list => FND_API.G_FALSE,
367: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
368: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
369: p_ORIGINAL_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.ORIGINAL_PLAN_ID,
370: p_CUSTOMIZED_PLAN => P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN,
371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,
365: Validate_ORIGINAL_PLAN_ID(
366: p_init_msg_list => FND_API.G_FALSE,
367: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
368: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
369: p_ORIGINAL_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.ORIGINAL_PLAN_ID,
370: p_CUSTOMIZED_PLAN => P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN,
371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data);
366: p_init_msg_list => FND_API.G_FALSE,
367: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
368: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
369: p_ORIGINAL_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.ORIGINAL_PLAN_ID,
370: p_CUSTOMIZED_PLAN => P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN,
371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data);
374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
384: RAISE FND_API.G_EXC_ERROR;
385: else
386: for i in 1..l_party_id_tbl.count
387: loop
388: if ( p_csc_plan_headers_b_rec.use_for_cust_account = 'N' ) then
389: if ( l_party_id_tbl(i).cust_account_id is not NULL )
390: -- OR l_party_id_tbl(i).cust_account_org is not NULL )
391: then
392: -- cannot allow update because parent plan is at account level and this
393: -- operation is trying to customize at party level.
394: -- fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
395: fnd_message.set_name ('CS', 'CS_API_ALL_INVALID_ARGUMENT');
396: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
397: fnd_message.set_token('VALUE', p_csc_plan_headers_b_rec.use_for_cust_account);
398: fnd_message.set_token('PARAMETER', 'USE_FOR_CUST_ACCOUNT');
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: RAISE FND_API.G_EXC_ERROR;
401: end if;
412: end if;
413:
414: /********************** 04-10-2000
415:
416: IF ( P_CSC_PLAN_HEADERS_B_REC.USE_FOR_CUST_ACCOUNT = 'Y' ) then
417: CSC_CUST_PLANS_PVT.Validate_CUST_ACC_ORG_ID (
418: P_Init_Msg_List => FND_API.G_TRUE,
419: P_Validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
420: P_PARTY_ID => l_party_id_tbl(i).party_id,
440: -- increases performance by using shared pool.
441:
442: /********** This check is not required, NULL can be passed directly as parameter value
443:
444: if ( p_csc_plan_headers_b_rec.original_plan_id = FND_API.G_MISS_NUM ) then
445: l_ins_plan_headers_b_rec.original_plan_id := NULL;
446: end if;
447:
448: if ( p_csc_plan_headers_b_rec.plan_group_code = FND_API.G_MISS_CHAR ) then
444: if ( p_csc_plan_headers_b_rec.original_plan_id = FND_API.G_MISS_NUM ) then
445: l_ins_plan_headers_b_rec.original_plan_id := NULL;
446: end if;
447:
448: if ( p_csc_plan_headers_b_rec.plan_group_code = FND_API.G_MISS_CHAR ) then
449: l_ins_plan_headers_b_rec.plan_group_code := NULL;
450: end if;
451:
452: if ( p_csc_plan_headers_b_rec.start_date_active = FND_API.G_MISS_DATE ) then
448: if ( p_csc_plan_headers_b_rec.plan_group_code = FND_API.G_MISS_CHAR ) then
449: l_ins_plan_headers_b_rec.plan_group_code := NULL;
450: end if;
451:
452: if ( p_csc_plan_headers_b_rec.start_date_active = FND_API.G_MISS_DATE ) then
453: l_ins_plan_headers_b_rec.start_date_active := NULL;
454: end if;
455:
456: if ( p_csc_plan_headers_b_rec.end_date_active = FND_API.G_MISS_DATE ) then
452: if ( p_csc_plan_headers_b_rec.start_date_active = FND_API.G_MISS_DATE ) then
453: l_ins_plan_headers_b_rec.start_date_active := NULL;
454: end if;
455:
456: if ( p_csc_plan_headers_b_rec.end_date_active = FND_API.G_MISS_DATE ) then
457: l_ins_plan_headers_b_rec.end_date_active := NULL;
458: end if;
459:
460: if ( p_csc_plan_headers_b_rec.use_for_cust_account = FND_API.G_MISS_CHAR ) then
456: if ( p_csc_plan_headers_b_rec.end_date_active = FND_API.G_MISS_DATE ) then
457: l_ins_plan_headers_b_rec.end_date_active := NULL;
458: end if;
459:
460: if ( p_csc_plan_headers_b_rec.use_for_cust_account = FND_API.G_MISS_CHAR ) then
461: l_ins_plan_headers_b_rec.use_for_cust_account := NULL;
462: end if;
463:
464: if ( p_csc_plan_headers_b_rec.end_user_type = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) then
460: if ( p_csc_plan_headers_b_rec.use_for_cust_account = FND_API.G_MISS_CHAR ) then
461: l_ins_plan_headers_b_rec.use_for_cust_account := NULL;
462: end if;
463:
464: if ( p_csc_plan_headers_b_rec.end_user_type = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) then
465: l_ins_plan_headers_b_rec.end_user_type := NULL;
466: end if;
467:
468: if ( p_csc_plan_headers_b_rec.customized_plan = FND_API.G_MISS_CHAR ) then
464: if ( p_csc_plan_headers_b_rec.end_user_type = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) then
465: l_ins_plan_headers_b_rec.end_user_type := NULL;
466: end if;
467:
468: if ( p_csc_plan_headers_b_rec.customized_plan = FND_API.G_MISS_CHAR ) then
469: l_ins_plan_headers_b_rec.customized_plan := NULL;
470: end if;
471:
472: if ( p_csc_plan_headers_b_rec.profile_check_id = FND_API.G_MISS_NUM ) then
468: if ( p_csc_plan_headers_b_rec.customized_plan = FND_API.G_MISS_CHAR ) then
469: l_ins_plan_headers_b_rec.customized_plan := NULL;
470: end if;
471:
472: if ( p_csc_plan_headers_b_rec.profile_check_id = FND_API.G_MISS_NUM ) then
473: l_ins_plan_headers_b_rec.profile_check_id := NULL;
474: end if;
475:
476: if ( p_csc_plan_headers_b_rec.relational_operator = FND_API.G_MISS_CHAR ) then
472: if ( p_csc_plan_headers_b_rec.profile_check_id = FND_API.G_MISS_NUM ) then
473: l_ins_plan_headers_b_rec.profile_check_id := NULL;
474: end if;
475:
476: if ( p_csc_plan_headers_b_rec.relational_operator = FND_API.G_MISS_CHAR ) then
477: l_ins_plan_headers_b_rec.relational_operator := NULL;
478: end if;
479:
480: if ( p_csc_plan_headers_b_rec.criteria_value_high = FND_API.G_MISS_CHAR ) then
476: if ( p_csc_plan_headers_b_rec.relational_operator = FND_API.G_MISS_CHAR ) then
477: l_ins_plan_headers_b_rec.relational_operator := NULL;
478: end if;
479:
480: if ( p_csc_plan_headers_b_rec.criteria_value_high = FND_API.G_MISS_CHAR ) then
481: l_ins_plan_headers_b_rec.criteria_value_high := NULL;
482: end if;
483:
484: if ( p_csc_plan_headers_b_rec.criteria_value_low = FND_API.G_MISS_CHAR ) then
480: if ( p_csc_plan_headers_b_rec.criteria_value_high = FND_API.G_MISS_CHAR ) then
481: l_ins_plan_headers_b_rec.criteria_value_high := NULL;
482: end if;
483:
484: if ( p_csc_plan_headers_b_rec.criteria_value_low = FND_API.G_MISS_CHAR ) then
485: l_ins_plan_headers_b_rec.criteria_value_low := NULL;
486: end if;
487:
488: if ( p_csc_plan_headers_b_rec.attribute1 = FND_API.G_MISS_CHAR ) then
484: if ( p_csc_plan_headers_b_rec.criteria_value_low = FND_API.G_MISS_CHAR ) then
485: l_ins_plan_headers_b_rec.criteria_value_low := NULL;
486: end if;
487:
488: if ( p_csc_plan_headers_b_rec.attribute1 = FND_API.G_MISS_CHAR ) then
489: l_ins_plan_headers_b_rec.attribute1 := NULL;
490: end if;
491:
492: if ( p_csc_plan_headers_b_rec.attribute2 = FND_API.G_MISS_CHAR ) then
488: if ( p_csc_plan_headers_b_rec.attribute1 = FND_API.G_MISS_CHAR ) then
489: l_ins_plan_headers_b_rec.attribute1 := NULL;
490: end if;
491:
492: if ( p_csc_plan_headers_b_rec.attribute2 = FND_API.G_MISS_CHAR ) then
493: l_ins_plan_headers_b_rec.attribute2 := NULL;
494: end if;
495:
496: if ( p_csc_plan_headers_b_rec.attribute3 = FND_API.G_MISS_CHAR ) then
492: if ( p_csc_plan_headers_b_rec.attribute2 = FND_API.G_MISS_CHAR ) then
493: l_ins_plan_headers_b_rec.attribute2 := NULL;
494: end if;
495:
496: if ( p_csc_plan_headers_b_rec.attribute3 = FND_API.G_MISS_CHAR ) then
497: l_ins_plan_headers_b_rec.attribute3 := NULL;
498: end if;
499:
500: if ( p_csc_plan_headers_b_rec.attribute4 = FND_API.G_MISS_CHAR ) then
496: if ( p_csc_plan_headers_b_rec.attribute3 = FND_API.G_MISS_CHAR ) then
497: l_ins_plan_headers_b_rec.attribute3 := NULL;
498: end if;
499:
500: if ( p_csc_plan_headers_b_rec.attribute4 = FND_API.G_MISS_CHAR ) then
501: l_ins_plan_headers_b_rec.attribute4 := NULL;
502: end if;
503:
504: if ( p_csc_plan_headers_b_rec.attribute5 = FND_API.G_MISS_CHAR ) then
500: if ( p_csc_plan_headers_b_rec.attribute4 = FND_API.G_MISS_CHAR ) then
501: l_ins_plan_headers_b_rec.attribute4 := NULL;
502: end if;
503:
504: if ( p_csc_plan_headers_b_rec.attribute5 = FND_API.G_MISS_CHAR ) then
505: l_ins_plan_headers_b_rec.attribute5 := NULL;
506: end if;
507:
508: if ( p_csc_plan_headers_b_rec.attribute6 = FND_API.G_MISS_CHAR ) then
504: if ( p_csc_plan_headers_b_rec.attribute5 = FND_API.G_MISS_CHAR ) then
505: l_ins_plan_headers_b_rec.attribute5 := NULL;
506: end if;
507:
508: if ( p_csc_plan_headers_b_rec.attribute6 = FND_API.G_MISS_CHAR ) then
509: l_ins_plan_headers_b_rec.attribute6 := NULL;
510: end if;
511:
512: if ( p_csc_plan_headers_b_rec.attribute7 = FND_API.G_MISS_CHAR ) then
508: if ( p_csc_plan_headers_b_rec.attribute6 = FND_API.G_MISS_CHAR ) then
509: l_ins_plan_headers_b_rec.attribute6 := NULL;
510: end if;
511:
512: if ( p_csc_plan_headers_b_rec.attribute7 = FND_API.G_MISS_CHAR ) then
513: l_ins_plan_headers_b_rec.attribute7 := NULL;
514: end if;
515:
516: if ( p_csc_plan_headers_b_rec.attribute8 = FND_API.G_MISS_CHAR ) then
512: if ( p_csc_plan_headers_b_rec.attribute7 = FND_API.G_MISS_CHAR ) then
513: l_ins_plan_headers_b_rec.attribute7 := NULL;
514: end if;
515:
516: if ( p_csc_plan_headers_b_rec.attribute8 = FND_API.G_MISS_CHAR ) then
517: l_ins_plan_headers_b_rec.attribute8 := NULL;
518: end if;
519:
520: if ( p_csc_plan_headers_b_rec.attribute9 = FND_API.G_MISS_CHAR ) then
516: if ( p_csc_plan_headers_b_rec.attribute8 = FND_API.G_MISS_CHAR ) then
517: l_ins_plan_headers_b_rec.attribute8 := NULL;
518: end if;
519:
520: if ( p_csc_plan_headers_b_rec.attribute9 = FND_API.G_MISS_CHAR ) then
521: l_ins_plan_headers_b_rec.attribute9 := NULL;
522: end if;
523:
524: if ( p_csc_plan_headers_b_rec.attribute10 = FND_API.G_MISS_CHAR ) then
520: if ( p_csc_plan_headers_b_rec.attribute9 = FND_API.G_MISS_CHAR ) then
521: l_ins_plan_headers_b_rec.attribute9 := NULL;
522: end if;
523:
524: if ( p_csc_plan_headers_b_rec.attribute10 = FND_API.G_MISS_CHAR ) then
525: l_ins_plan_headers_b_rec.attribute10 := NULL;
526: end if;
527:
528: if ( p_csc_plan_headers_b_rec.attribute11 = FND_API.G_MISS_CHAR ) then
524: if ( p_csc_plan_headers_b_rec.attribute10 = FND_API.G_MISS_CHAR ) then
525: l_ins_plan_headers_b_rec.attribute10 := NULL;
526: end if;
527:
528: if ( p_csc_plan_headers_b_rec.attribute11 = FND_API.G_MISS_CHAR ) then
529: l_ins_plan_headers_b_rec.attribute11 := NULL;
530: end if;
531:
532: if ( p_csc_plan_headers_b_rec.attribute12 = FND_API.G_MISS_CHAR ) then
528: if ( p_csc_plan_headers_b_rec.attribute11 = FND_API.G_MISS_CHAR ) then
529: l_ins_plan_headers_b_rec.attribute11 := NULL;
530: end if;
531:
532: if ( p_csc_plan_headers_b_rec.attribute12 = FND_API.G_MISS_CHAR ) then
533: l_ins_plan_headers_b_rec.attribute12 := NULL;
534: end if;
535:
536: if ( p_csc_plan_headers_b_rec.attribute13 = FND_API.G_MISS_CHAR ) then
532: if ( p_csc_plan_headers_b_rec.attribute12 = FND_API.G_MISS_CHAR ) then
533: l_ins_plan_headers_b_rec.attribute12 := NULL;
534: end if;
535:
536: if ( p_csc_plan_headers_b_rec.attribute13 = FND_API.G_MISS_CHAR ) then
537: l_ins_plan_headers_b_rec.attribute13 := NULL;
538: end if;
539:
540: if ( p_csc_plan_headers_b_rec.attribute14 = FND_API.G_MISS_CHAR ) then
536: if ( p_csc_plan_headers_b_rec.attribute13 = FND_API.G_MISS_CHAR ) then
537: l_ins_plan_headers_b_rec.attribute13 := NULL;
538: end if;
539:
540: if ( p_csc_plan_headers_b_rec.attribute14 = FND_API.G_MISS_CHAR ) then
541: l_ins_plan_headers_b_rec.attribute14 := NULL;
542: end if;
543:
544: if ( p_csc_plan_headers_b_rec.attribute15 = FND_API.G_MISS_CHAR ) then
540: if ( p_csc_plan_headers_b_rec.attribute14 = FND_API.G_MISS_CHAR ) then
541: l_ins_plan_headers_b_rec.attribute14 := NULL;
542: end if;
543:
544: if ( p_csc_plan_headers_b_rec.attribute15 = FND_API.G_MISS_CHAR ) then
545: l_ins_plan_headers_b_rec.attribute15 := NULL;
546: end if;
547:
548: if ( p_csc_plan_headers_b_rec.attribute_category = FND_API.G_MISS_CHAR ) then
544: if ( p_csc_plan_headers_b_rec.attribute15 = FND_API.G_MISS_CHAR ) then
545: l_ins_plan_headers_b_rec.attribute15 := NULL;
546: end if;
547:
548: if ( p_csc_plan_headers_b_rec.attribute_category = FND_API.G_MISS_CHAR ) then
549: l_ins_plan_headers_b_rec.attribute_category := NULL;
550: end if;
551:
552: **************************/
558: if ( p_description <> FND_API.G_MISS_CHAR ) then
559: l_description:= p_description;
560: end if;
561:
562: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Insert_Row)
563: x_plan_id := p_csc_plan_headers_b_rec.plan_id;
564: CSC_PLAN_HEADERS_B_PKG.Insert_Row(
565: px_PLAN_ID => x_plan_id,
566: p_ORIGINAL_PLAN_ID => l_ins_plan_headers_b_rec.ORIGINAL_PLAN_ID,
559: l_description:= p_description;
560: end if;
561:
562: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Insert_Row)
563: x_plan_id := p_csc_plan_headers_b_rec.plan_id;
564: CSC_PLAN_HEADERS_B_PKG.Insert_Row(
565: px_PLAN_ID => x_plan_id,
566: p_ORIGINAL_PLAN_ID => l_ins_plan_headers_b_rec.ORIGINAL_PLAN_ID,
567: p_PLAN_GROUP_CODE => l_ins_plan_headers_b_rec.PLAN_GROUP_CODE,
560: end if;
561:
562: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Insert_Row)
563: x_plan_id := p_csc_plan_headers_b_rec.plan_id;
564: CSC_PLAN_HEADERS_B_PKG.Insert_Row(
565: px_PLAN_ID => x_plan_id,
566: p_ORIGINAL_PLAN_ID => l_ins_plan_headers_b_rec.ORIGINAL_PLAN_ID,
567: p_PLAN_GROUP_CODE => l_ins_plan_headers_b_rec.PLAN_GROUP_CODE,
568: p_START_DATE_ACTIVE => l_ins_plan_headers_b_rec.START_DATE_ACTIVE,
598: p_DESCRIPTION => l_DESCRIPTION,
599: p_NAME => l_NAME,
600: x_OBJECT_VERSION_NUMBER => x_object_version_number );
601:
602: IF ( p_csc_plan_headers_b_rec.customized_plan = 'Y' ) then
603: for i in 1..l_party_id_tbl.count
604: LOOP
605: CSC_CUSTOMIZED_PLANS_PKG.INSERT_ROW(
606: px_id => g_customized_id,
615: P_Api_Version_Number => 1.0,
616: P_Init_Msg_List => FND_API.G_TRUE,
617: P_Commit => p_commit,
618: P_PLAN_ID => x_plan_id,
619: P_ORIGINAL_PLAN_ID => p_csc_plan_headers_b_rec.original_plan_id,
620: P_PARTY_ID => l_party_id_tbl(i).party_id,
621: P_CUST_ACCOUNT_ID => l_party_id_tbl(i).cust_account_id,
622: -- P_CUST_ACCOUNT_ORG => l_party_id_tbl(i).cust_account_org,
623: P_OBJECT_VERSION_NUMBER => l_party_id_tbl(i).object_version_number,
730: X_Msg_Count OUT NOCOPY NUMBER,
731: X_Msg_Data OUT NOCOPY VARCHAR2
732: )
733: IS
734: l_pvt_csc_plan_headers_b_rec CSC_PLAN_HEADERS_B_REC_TYPE;
735:
736: BEGIN
737: convert_columns_to_rec_type(
738: P_ROW_ID => p_row_id,
769: P_ATTRIBUTE14 => p_attribute14,
770: P_ATTRIBUTE15 => p_attribute15,
771: P_ATTRIBUTE_CATEGORY => p_attribute_category,
772: P_OBJECT_VERSION_NUMBER => p_object_version_number,
773: X_PVT_CSC_PLAN_HEADERS_B_REC => l_pvt_csc_plan_headers_b_rec );
774:
775: /*** CALL PROCEDURE WITH RECORD TYPE STRUCTURE ***/
776: update_plan_header(
777: P_Api_Version_Number => p_api_version_number,
777: P_Api_Version_Number => p_api_version_number,
778: P_Init_Msg_List => p_init_msg_list,
779: P_Commit => p_commit,
780: P_Validation_level => p_validation_level,
781: P_CSC_PLAN_HEADERS_B_REC => l_pvt_csc_plan_headers_b_rec,
782: P_DESCRIPTION => p_description,
783: P_NAME => p_name,
784: P_PARTY_ID_TBL => p_party_id_tbl,
785: X_Object_Version_number => x_object_version_number,
794: P_Api_Version_Number IN NUMBER,
795: P_Init_Msg_List IN VARCHAR2,
796: P_Commit IN VARCHAR2,
797: p_validation_level IN NUMBER,
798: P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
799: P_DESCRIPTION IN VARCHAR2,
800: P_NAME IN VARCHAR2,
801: P_PARTY_ID_TBL IN CSC_CUST_PLANS_PVT.CSC_PARTY_ID_TBL_TYPE,
802: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
825: l_api_name CONSTANT VARCHAR2(30) := 'Update_plan_header';
826: l_api_version_number CONSTANT NUMBER := 1.0;
827:
828: -- Local Variables
829: l_ref_PLAN_HEADER_rec CSC_relationship_plans_PVT.CSC_PLAN_HEADERS_B_REC_TYPE;
830: l_upd_plan_headers_b_rec CSC_relationship_plans_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=
831: P_CSC_PLAN_HEADERS_B_REC;
832: l_name VARCHAR2(90) := p_name;
833: l_description VARCHAR2(720):= p_description;
826: l_api_version_number CONSTANT NUMBER := 1.0;
827:
828: -- Local Variables
829: l_ref_PLAN_HEADER_rec CSC_relationship_plans_PVT.CSC_PLAN_HEADERS_B_REC_TYPE;
830: l_upd_plan_headers_b_rec CSC_relationship_plans_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=
831: P_CSC_PLAN_HEADERS_B_REC;
832: l_name VARCHAR2(90) := p_name;
833: l_description VARCHAR2(720):= p_description;
834: l_rowid ROWID;
827:
828: -- Local Variables
829: l_ref_PLAN_HEADER_rec CSC_relationship_plans_PVT.CSC_PLAN_HEADERS_B_REC_TYPE;
830: l_upd_plan_headers_b_rec CSC_relationship_plans_PVT.CSC_PLAN_HEADERS_B_REC_TYPE :=
831: P_CSC_PLAN_HEADERS_B_REC;
832: l_name VARCHAR2(90) := p_name;
833: l_description VARCHAR2(720):= p_description;
834: l_rowid ROWID;
835:
835:
836: Cursor C_Get_cust_plans IS
837: Select CUST_PLAN_ID, PARTY_ID, CUST_ACCOUNT_ID, OBJECT_VERSION_NUMBER
838: From CSC_CUST_PLANS
839: WHERE PLAN_ID = nvl(p_csc_plan_headers_b_rec.plan_id, plan_id)
840: AND plan_status_code not in ('MERGED', 'TRANSFERED') ORDER BY OBJECT_VERSION_NUMBER;
841: l_ref_CSC_CUST_PLANS_rec CSC_cust_plans_PVT.CSC_CUST_PLANS_Rec_Type;
842:
843: BEGIN
861:
862: -- Initialize API return status to SUCCESS
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864:
865: CSC_PLAN_HEADERS_B_PKG.LOCK_ROW(
866: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
867: P_OBJECT_VERSION_NUMBER => p_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER );
868:
869: Open c_get_csc_plan_headers( p_csc_plan_headers_b_rec.PLAN_ID );
862: -- Initialize API return status to SUCCESS
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864:
865: CSC_PLAN_HEADERS_B_PKG.LOCK_ROW(
866: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
867: P_OBJECT_VERSION_NUMBER => p_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER );
868:
869: Open c_get_csc_plan_headers( p_csc_plan_headers_b_rec.PLAN_ID );
870:
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864:
865: CSC_PLAN_HEADERS_B_PKG.LOCK_ROW(
866: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
867: P_OBJECT_VERSION_NUMBER => p_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER );
868:
869: Open c_get_csc_plan_headers( p_csc_plan_headers_b_rec.PLAN_ID );
870:
871: Fetch c_get_csc_plan_headers into
865: CSC_PLAN_HEADERS_B_PKG.LOCK_ROW(
866: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
867: P_OBJECT_VERSION_NUMBER => p_csc_plan_headers_b_rec.OBJECT_VERSION_NUMBER );
868:
869: Open c_get_csc_plan_headers( p_csc_plan_headers_b_rec.PLAN_ID );
870:
871: Fetch c_get_csc_plan_headers into
872: l_rowid,
873: l_ref_PLAN_HEADER_rec.PLAN_ID,
923: -- This check is not neccessary because we do the locking based on the plan_id and the
924: -- object_version_number. This lock would fail if any other user updates the selected
925: -- record because the object_version_number would be different.
926:
927: If ( P_CSC_PLAN_HEADERS_B_rec.object_version_number <>
928: l_ref_PLAN_HEADER_rec.OBJECT_VERSION_NUMBER ) THEN
929: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
930: --THEN
931: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_RECORD_CHANGED');
940: -- of the table handler, because, when submitting the update sql. statement to the SGA,
941: -- we need to pass an identical update statement every time. This saves SGA space and
942: -- increases performance by using shared pool.
943:
944: l_upd_plan_headers_b_rec.original_plan_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_plan_headers_b_rec.original_plan_id, l_ref_plan_header_rec.original_plan_id);
945:
946: l_upd_plan_headers_b_rec.plan_group_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.plan_group_code, l_ref_plan_header_rec.plan_group_code);
947:
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
942: -- increases performance by using shared pool.
943:
944: l_upd_plan_headers_b_rec.original_plan_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_plan_headers_b_rec.original_plan_id, l_ref_plan_header_rec.original_plan_id);
945:
946: l_upd_plan_headers_b_rec.plan_group_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.plan_group_code, l_ref_plan_header_rec.plan_group_code);
947:
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
949:
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
944: l_upd_plan_headers_b_rec.original_plan_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_plan_headers_b_rec.original_plan_id, l_ref_plan_header_rec.original_plan_id);
945:
946: l_upd_plan_headers_b_rec.plan_group_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.plan_group_code, l_ref_plan_header_rec.plan_group_code);
947:
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
949:
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
951:
952: l_upd_plan_headers_b_rec.use_for_cust_account := p_csc_plan_headers_b_rec.use_for_cust_account;
946: l_upd_plan_headers_b_rec.plan_group_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.plan_group_code, l_ref_plan_header_rec.plan_group_code);
947:
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
949:
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
951:
952: l_upd_plan_headers_b_rec.use_for_cust_account := p_csc_plan_headers_b_rec.use_for_cust_account;
953:
954: l_upd_plan_headers_b_rec.end_user_type := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.end_user_type, l_ref_plan_header_rec.end_user_type);
948: l_upd_plan_headers_b_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.start_date_active, l_ref_plan_header_rec.start_date_active);
949:
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
951:
952: l_upd_plan_headers_b_rec.use_for_cust_account := p_csc_plan_headers_b_rec.use_for_cust_account;
953:
954: l_upd_plan_headers_b_rec.end_user_type := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.end_user_type, l_ref_plan_header_rec.end_user_type);
955:
956: l_upd_plan_headers_b_rec.customized_plan := p_csc_plan_headers_b_rec.customized_plan;
950: l_upd_plan_headers_b_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_Date(p_csc_plan_headers_b_rec.end_date_active, l_ref_plan_header_rec.end_date_active);
951:
952: l_upd_plan_headers_b_rec.use_for_cust_account := p_csc_plan_headers_b_rec.use_for_cust_account;
953:
954: l_upd_plan_headers_b_rec.end_user_type := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.end_user_type, l_ref_plan_header_rec.end_user_type);
955:
956: l_upd_plan_headers_b_rec.customized_plan := p_csc_plan_headers_b_rec.customized_plan;
957:
958: l_upd_plan_headers_b_rec.profile_check_id := p_csc_plan_headers_b_rec.profile_check_id;
952: l_upd_plan_headers_b_rec.use_for_cust_account := p_csc_plan_headers_b_rec.use_for_cust_account;
953:
954: l_upd_plan_headers_b_rec.end_user_type := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.end_user_type, l_ref_plan_header_rec.end_user_type);
955:
956: l_upd_plan_headers_b_rec.customized_plan := p_csc_plan_headers_b_rec.customized_plan;
957:
958: l_upd_plan_headers_b_rec.profile_check_id := p_csc_plan_headers_b_rec.profile_check_id;
959:
960: l_upd_plan_headers_b_rec.relational_operator := p_csc_plan_headers_b_rec.relational_operator;
954: l_upd_plan_headers_b_rec.end_user_type := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.end_user_type, l_ref_plan_header_rec.end_user_type);
955:
956: l_upd_plan_headers_b_rec.customized_plan := p_csc_plan_headers_b_rec.customized_plan;
957:
958: l_upd_plan_headers_b_rec.profile_check_id := p_csc_plan_headers_b_rec.profile_check_id;
959:
960: l_upd_plan_headers_b_rec.relational_operator := p_csc_plan_headers_b_rec.relational_operator;
961:
962: l_upd_plan_headers_b_rec.criteria_value_high := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_high, l_ref_plan_header_rec.criteria_value_high);
956: l_upd_plan_headers_b_rec.customized_plan := p_csc_plan_headers_b_rec.customized_plan;
957:
958: l_upd_plan_headers_b_rec.profile_check_id := p_csc_plan_headers_b_rec.profile_check_id;
959:
960: l_upd_plan_headers_b_rec.relational_operator := p_csc_plan_headers_b_rec.relational_operator;
961:
962: l_upd_plan_headers_b_rec.criteria_value_high := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_high, l_ref_plan_header_rec.criteria_value_high);
963:
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
958: l_upd_plan_headers_b_rec.profile_check_id := p_csc_plan_headers_b_rec.profile_check_id;
959:
960: l_upd_plan_headers_b_rec.relational_operator := p_csc_plan_headers_b_rec.relational_operator;
961:
962: l_upd_plan_headers_b_rec.criteria_value_high := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_high, l_ref_plan_header_rec.criteria_value_high);
963:
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
965:
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
960: l_upd_plan_headers_b_rec.relational_operator := p_csc_plan_headers_b_rec.relational_operator;
961:
962: l_upd_plan_headers_b_rec.criteria_value_high := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_high, l_ref_plan_header_rec.criteria_value_high);
963:
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
965:
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
967:
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
962: l_upd_plan_headers_b_rec.criteria_value_high := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_high, l_ref_plan_header_rec.criteria_value_high);
963:
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
965:
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
967:
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
969:
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
964: l_upd_plan_headers_b_rec.criteria_value_low := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.criteria_value_low, l_ref_plan_header_rec.criteria_value_low);
965:
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
967:
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
969:
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
971:
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
966: l_upd_plan_headers_b_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute1, l_ref_plan_header_rec.attribute1);
967:
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
969:
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
971:
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
973:
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
968: l_upd_plan_headers_b_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute2, l_ref_plan_header_rec.attribute2);
969:
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
971:
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
973:
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
975:
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
970: l_upd_plan_headers_b_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute3, l_ref_plan_header_rec.attribute3);
971:
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
973:
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
975:
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
977:
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
972: l_upd_plan_headers_b_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute4, l_ref_plan_header_rec.attribute4);
973:
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
975:
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
977:
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
979:
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
974: l_upd_plan_headers_b_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute5, l_ref_plan_header_rec.attribute5);
975:
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
977:
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
979:
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
981:
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
976: l_upd_plan_headers_b_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute6, l_ref_plan_header_rec.attribute6);
977:
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
979:
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
981:
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
983:
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
978: l_upd_plan_headers_b_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute7, l_ref_plan_header_rec.attribute7);
979:
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
981:
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
983:
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
985:
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
980: l_upd_plan_headers_b_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute8, l_ref_plan_header_rec.attribute8);
981:
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
983:
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
985:
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
987:
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
982: l_upd_plan_headers_b_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute9, l_ref_plan_header_rec.attribute9);
983:
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
985:
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
987:
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
989:
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
984: l_upd_plan_headers_b_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute10, l_ref_plan_header_rec.attribute10);
985:
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
987:
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
989:
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
991:
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
986: l_upd_plan_headers_b_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute11, l_ref_plan_header_rec.attribute11);
987:
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
989:
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
991:
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
993:
994: l_upd_plan_headers_b_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute15, l_ref_plan_header_rec.attribute15);
988: l_upd_plan_headers_b_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute12, l_ref_plan_header_rec.attribute12);
989:
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
991:
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
993:
994: l_upd_plan_headers_b_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute15, l_ref_plan_header_rec.attribute15);
995:
996: l_upd_plan_headers_b_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute_category, l_ref_plan_header_rec.attribute_category);
990: l_upd_plan_headers_b_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute13, l_ref_plan_header_rec.attribute13);
991:
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
993:
994: l_upd_plan_headers_b_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute15, l_ref_plan_header_rec.attribute15);
995:
996: l_upd_plan_headers_b_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute_category, l_ref_plan_header_rec.attribute_category);
997:
998: if ( p_name <> FND_API.G_MISS_CHAR ) then
992: l_upd_plan_headers_b_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute14, l_ref_plan_header_rec.attribute14);
993:
994: l_upd_plan_headers_b_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute15, l_ref_plan_header_rec.attribute15);
995:
996: l_upd_plan_headers_b_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_plan_headers_b_rec.attribute_category, l_ref_plan_header_rec.attribute_category);
997:
998: if ( p_name <> FND_API.G_MISS_CHAR ) then
999: l_name := p_name;
1000: end if;
1011: Validate_csc_relationship_plan(
1012: p_init_msg_list => FND_API.G_FALSE,
1013: p_validation_level => p_validation_level,
1014: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1015: P_CSC_PLAN_HEADERS_B_REC => L_UPD_PLAN_HEADERS_B_REC,
1016: P_OLD_PLAN_HEADERS_B_REC => l_ref_plan_header_rec,
1017: P_DESCRIPTION => l_description,
1018: P_NAME => l_name,
1019: --P_PARTY_ID => p_party_id,
1027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Update_Row)
1032: CSC_PLAN_HEADERS_B_PKG.Update_Row(
1033: p_PLAN_ID => l_upd_plan_headers_b_rec.PLAN_ID,
1034: p_ORIGINAL_PLAN_ID => l_upd_plan_headers_b_rec.ORIGINAL_PLAN_ID,
1035: p_PLAN_GROUP_CODE => l_upd_plan_headers_b_rec.PLAN_GROUP_CODE,
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Update_Row)
1032: CSC_PLAN_HEADERS_B_PKG.Update_Row(
1033: p_PLAN_ID => l_upd_plan_headers_b_rec.PLAN_ID,
1034: p_ORIGINAL_PLAN_ID => l_upd_plan_headers_b_rec.ORIGINAL_PLAN_ID,
1035: p_PLAN_GROUP_CODE => l_upd_plan_headers_b_rec.PLAN_GROUP_CODE,
1036: p_START_DATE_ACTIVE => l_upd_plan_headers_b_rec.START_DATE_ACTIVE,
1072: -- and making the plan available to all other eligible customers. The customer
1073: -- may still be assigned to the plan.
1074:
1075: if ( l_ref_plan_header_rec.customized_plan = 'Y'
1076: and p_csc_plan_headers_b_rec.customized_plan = 'N' ) then
1077: delete from csc_customized_plans
1078: where plan_id = p_csc_plan_headers_b_rec.plan_id;
1079: end if;
1080:
1074:
1075: if ( l_ref_plan_header_rec.customized_plan = 'Y'
1076: and p_csc_plan_headers_b_rec.customized_plan = 'N' ) then
1077: delete from csc_customized_plans
1078: where plan_id = p_csc_plan_headers_b_rec.plan_id;
1079: end if;
1080:
1081: -- if plan header end_date_active was null and is updated, update the end_date_active
1082: -- in CSC_CUST_PLANS table for all customers associated to this plan.
1086: -- update fails
1087: -- check for the existing and the new date, before update
1088: -- Fixed bug# 2805474, update Start_Date_Active
1089:
1090: -- if ( p_csc_plan_headers_b_rec.end_date_active >= TRUNC (SYSDATE) ) then
1091:
1092: -- if ( l_ref_plan_header_rec.end_date_active is null ) or
1093: if ( l_ref_plan_header_rec.end_date_active <> p_csc_plan_headers_b_rec.end_date_active ) or
1094: ( l_ref_plan_header_rec.start_date_active <> p_csc_plan_headers_b_rec.start_date_active ) then
1089:
1090: -- if ( p_csc_plan_headers_b_rec.end_date_active >= TRUNC (SYSDATE) ) then
1091:
1092: -- if ( l_ref_plan_header_rec.end_date_active is null ) or
1093: if ( l_ref_plan_header_rec.end_date_active <> p_csc_plan_headers_b_rec.end_date_active ) or
1094: ( l_ref_plan_header_rec.start_date_active <> p_csc_plan_headers_b_rec.start_date_active ) then
1095:
1096: Open C_Get_cust_plans;
1097:
1090: -- if ( p_csc_plan_headers_b_rec.end_date_active >= TRUNC (SYSDATE) ) then
1091:
1092: -- if ( l_ref_plan_header_rec.end_date_active is null ) or
1093: if ( l_ref_plan_header_rec.end_date_active <> p_csc_plan_headers_b_rec.end_date_active ) or
1094: ( l_ref_plan_header_rec.start_date_active <> p_csc_plan_headers_b_rec.start_date_active ) then
1095:
1096: Open C_Get_cust_plans;
1097:
1098: LOOP
1109: P_Api_Version_Number => p_api_version_number,
1110: P_Init_Msg_List => p_init_msg_list,
1111: P_Commit => p_commit,
1112: p_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
1113: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
1114: P_CUST_PLAN_ID => l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1115: P_PARTY_ID => l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1116: P_CUST_ACCOUNT_ID => l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1117: p_start_date_active => p_csc_plan_headers_b_rec.start_date_active,
1113: P_PLAN_ID => p_csc_plan_headers_b_rec.plan_id,
1114: P_CUST_PLAN_ID => l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1115: P_PARTY_ID => l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1116: P_CUST_ACCOUNT_ID => l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1117: p_start_date_active => p_csc_plan_headers_b_rec.start_date_active,
1118: p_end_date_active => p_csc_plan_headers_b_rec.end_date_active,
1119: P_OBJECT_VERSION_NUMBER => l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER,
1120: X_Object_Version_number => x_object_version_number,
1121: X_Return_Status => x_return_status,
1114: P_CUST_PLAN_ID => l_ref_CSC_CUST_PLANS_rec.CUST_PLAN_ID,
1115: P_PARTY_ID => l_ref_CSC_CUST_PLANS_rec.PARTY_ID,
1116: P_CUST_ACCOUNT_ID => l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID,
1117: p_start_date_active => p_csc_plan_headers_b_rec.start_date_active,
1118: p_end_date_active => p_csc_plan_headers_b_rec.end_date_active,
1119: P_OBJECT_VERSION_NUMBER => l_ref_CSC_CUST_PLANS_rec.OBJECT_VERSION_NUMBER,
1120: X_Object_Version_number => x_object_version_number,
1121: X_Return_Status => x_return_status,
1122: X_Msg_Count => x_msg_count,
1225:
1226: -- Initialize API return status to SUCCESS
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1228:
1229: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Disable_Row)
1230: CSC_PLAN_HEADERS_B_PKG.Disable_Row(
1231: p_PLAN_ID => p_PLAN_ID);
1232:
1233: -- Change the end_date_active of the CSC_CUST_PLANS table to sysdate+1 for all records
1226: -- Initialize API return status to SUCCESS
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1228:
1229: -- Invoke table handler(CSC_PLAN_HEADERS_B_PKG.Disable_Row)
1230: CSC_PLAN_HEADERS_B_PKG.Disable_Row(
1231: p_PLAN_ID => p_PLAN_ID);
1232:
1233: -- Change the end_date_active of the CSC_CUST_PLANS table to sysdate+1 for all records
1234: -- with this plan_id. The plan assignment engine will then check all records with
1323: )
1324: IS
1325: cursor check_dup_plan_id is
1326: select plan_id
1327: from CSC_PLAN_HEADERS_B
1328: where plan_id = p_plan_id;
1329:
1330: l_plan_id number;
1331: l_api_name varchar2(30) := 'Validate_Plan_Id';
1463: )
1464: IS
1465: cursor chk_original_plan_id is
1466: select plan_id
1467: from CSC_PLAN_HEADERS_B
1468: where plan_id = p_original_plan_id;
1469:
1470: l_plan_id number;
1471: l_api_name varchar2(30) := 'Validate_Original_Plan_Id';
2235: PROCEDURE Validate_csc_relationship_plan(
2236: P_Init_Msg_List IN VARCHAR2,
2237: P_Validation_level IN NUMBER,
2238: P_Validation_mode IN VARCHAR2,
2239: P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
2240: P_OLD_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
2241: P_DESCRIPTION IN VARCHAR2,
2242: P_NAME IN VARCHAR2,
2243: --P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
2236: P_Init_Msg_List IN VARCHAR2,
2237: P_Validation_level IN NUMBER,
2238: P_Validation_mode IN VARCHAR2,
2239: P_CSC_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
2240: P_OLD_PLAN_HEADERS_B_REC IN CSC_PLAN_HEADERS_B_REC_TYPE,
2241: P_DESCRIPTION IN VARCHAR2,
2242: P_NAME IN VARCHAR2,
2243: --P_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
2244: --P_CUST_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
2256: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
2257: Validate_PLAN_ID(
2258: p_init_msg_list => FND_API.G_FALSE,
2259: p_validation_mode => p_validation_mode,
2260: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2261: x_return_status => x_return_status,
2262: x_msg_count => x_msg_count,
2263: x_msg_data => x_msg_data);
2264: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2267:
2268: Validate_NAME(
2269: p_init_msg_list => FND_API.G_FALSE,
2270: p_validation_mode => p_validation_mode,
2271: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2272: p_NAME => P_NAME,
2273: x_return_status => x_return_status,
2274: x_msg_count => x_msg_count,
2275: x_msg_data => x_msg_data);
2279:
2280: Validate_ORIGINAL_PLAN_ID(
2281: p_init_msg_list => FND_API.G_FALSE,
2282: p_validation_mode => p_validation_mode,
2283: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2284: p_ORIGINAL_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.ORIGINAL_PLAN_ID,
2285: p_CUSTOMIZED_PLAN => P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN,
2286: x_return_status => x_return_status,
2287: x_msg_count => x_msg_count,
2280: Validate_ORIGINAL_PLAN_ID(
2281: p_init_msg_list => FND_API.G_FALSE,
2282: p_validation_mode => p_validation_mode,
2283: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2284: p_ORIGINAL_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.ORIGINAL_PLAN_ID,
2285: p_CUSTOMIZED_PLAN => P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN,
2286: x_return_status => x_return_status,
2287: x_msg_count => x_msg_count,
2288: x_msg_data => x_msg_data);
2281: p_init_msg_list => FND_API.G_FALSE,
2282: p_validation_mode => p_validation_mode,
2283: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2284: p_ORIGINAL_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.ORIGINAL_PLAN_ID,
2285: p_CUSTOMIZED_PLAN => P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN,
2286: x_return_status => x_return_status,
2287: x_msg_count => x_msg_count,
2288: x_msg_data => x_msg_data);
2289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2292:
2293: Validate_PLAN_GROUP_CODE(
2294: p_init_msg_list => FND_API.G_FALSE,
2295: p_validation_mode => p_validation_mode,
2296: p_PLAN_GROUP_CODE => P_CSC_PLAN_HEADERS_B_REC.PLAN_GROUP_CODE,
2297: x_return_status => x_return_status,
2298: x_msg_count => x_msg_count,
2299: x_msg_data => x_msg_data);
2300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2303:
2304: Validate_START_DATE_ACTIVE (
2305: P_Init_Msg_List => FND_API.G_TRUE,
2306: P_Validation_mode => p_validation_mode,
2307: P_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2308: P_START_DATE_ACTIVE => P_CSC_PLAN_HEADERS_B_REC.START_DATE_ACTIVE,
2309: X_Return_Status => x_return_status,
2310: X_Msg_Count => x_msg_count,
2311: X_Msg_Data => x_msg_data );
2304: Validate_START_DATE_ACTIVE (
2305: P_Init_Msg_List => FND_API.G_TRUE,
2306: P_Validation_mode => p_validation_mode,
2307: P_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2308: P_START_DATE_ACTIVE => P_CSC_PLAN_HEADERS_B_REC.START_DATE_ACTIVE,
2309: X_Return_Status => x_return_status,
2310: X_Msg_Count => x_msg_count,
2311: X_Msg_Data => x_msg_data );
2312: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2315:
2316: Validate_END_DATE_ACTIVE (
2317: P_Init_Msg_List => FND_API.G_TRUE,
2318: P_Validation_mode => p_validation_mode,
2319: P_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2320: P_END_DATE_ACTIVE => P_CSC_PLAN_HEADERS_B_REC.END_DATE_ACTIVE,
2321: X_Return_Status => x_return_status,
2322: X_Msg_Count => x_msg_count,
2323: X_Msg_Data => x_msg_data );
2316: Validate_END_DATE_ACTIVE (
2317: P_Init_Msg_List => FND_API.G_TRUE,
2318: P_Validation_mode => p_validation_mode,
2319: P_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2320: P_END_DATE_ACTIVE => P_CSC_PLAN_HEADERS_B_REC.END_DATE_ACTIVE,
2321: X_Return_Status => x_return_status,
2322: X_Msg_Count => x_msg_count,
2323: X_Msg_Data => x_msg_data );
2324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2328: -- issue a call to the CORE UTILITIES package to validate the date fields.
2329: CSC_CORE_UTILS_PVT.VALIDATE_DATES(
2330: p_init_msg_list => FND_API.G_FALSE,
2331: p_validation_mode => p_validation_mode,
2332: P_START_DATE => p_csc_plan_headers_b_rec.start_date_active,
2333: P_END_DATE => p_csc_plan_headers_b_rec.end_date_active,
2334: x_return_status => x_return_status,
2335: x_msg_count => x_msg_count,
2336: x_msg_data => x_msg_data);
2329: CSC_CORE_UTILS_PVT.VALIDATE_DATES(
2330: p_init_msg_list => FND_API.G_FALSE,
2331: p_validation_mode => p_validation_mode,
2332: P_START_DATE => p_csc_plan_headers_b_rec.start_date_active,
2333: P_END_DATE => p_csc_plan_headers_b_rec.end_date_active,
2334: x_return_status => x_return_status,
2335: x_msg_count => x_msg_count,
2336: x_msg_data => x_msg_data);
2337: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2340:
2341: Validate_USE_FOR_CUST_ACCOUNT(
2342: p_init_msg_list => FND_API.G_FALSE,
2343: p_validation_mode => p_validation_mode,
2344: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2345: p_USE_FOR_CUST_ACCOUNT => P_CSC_PLAN_HEADERS_B_REC.USE_FOR_CUST_ACCOUNT,
2346: p_OLD_USE_FOR_CUST_ACCOUNT => P_OLD_PLAN_HEADERS_B_REC.USE_FOR_CUST_ACCOUNT,
2347: x_return_status => x_return_status,
2348: x_msg_count => x_msg_count,
2341: Validate_USE_FOR_CUST_ACCOUNT(
2342: p_init_msg_list => FND_API.G_FALSE,
2343: p_validation_mode => p_validation_mode,
2344: p_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2345: p_USE_FOR_CUST_ACCOUNT => P_CSC_PLAN_HEADERS_B_REC.USE_FOR_CUST_ACCOUNT,
2346: p_OLD_USE_FOR_CUST_ACCOUNT => P_OLD_PLAN_HEADERS_B_REC.USE_FOR_CUST_ACCOUNT,
2347: x_return_status => x_return_status,
2348: x_msg_count => x_msg_count,
2349: x_msg_data => x_msg_data);
2353:
2354: Validate_END_USER_TYPE (
2355: P_Init_Msg_List => FND_API.G_FALSE,
2356: P_Validation_mode => p_validation_mode,
2357: P_END_USER_TYPE => P_CSC_PLAN_HEADERS_B_REC.END_USER_TYPE,
2358: X_Return_Status => x_return_status,
2359: X_Msg_Count => x_msg_count,
2360: X_Msg_Data => x_msg_data );
2361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2364:
2365: Validate_CUSTOMIZED_PLAN(
2366: p_init_msg_list => FND_API.G_FALSE,
2367: p_validation_mode => p_validation_mode,
2368: p_CUSTOMIZED_PLAN => P_CSC_PLAN_HEADERS_B_REC.CUSTOMIZED_PLAN,
2369: x_return_status => x_return_status,
2370: x_msg_count => x_msg_count,
2371: x_msg_data => x_msg_data);
2372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2375:
2376: Validate_PROFILE_CHECK_ID(
2377: p_init_msg_list => FND_API.G_FALSE,
2378: p_validation_mode => p_validation_mode,
2379: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2380: p_PROFILE_CHECK_ID => P_CSC_PLAN_HEADERS_B_REC.PROFILE_CHECK_ID,
2381: p_OLD_PROFILE_CHECK_ID => P_OLD_PLAN_HEADERS_B_REC.PROFILE_CHECK_ID,
2382: x_return_status => x_return_status,
2383: x_msg_count => x_msg_count,
2376: Validate_PROFILE_CHECK_ID(
2377: p_init_msg_list => FND_API.G_FALSE,
2378: p_validation_mode => p_validation_mode,
2379: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2380: p_PROFILE_CHECK_ID => P_CSC_PLAN_HEADERS_B_REC.PROFILE_CHECK_ID,
2381: p_OLD_PROFILE_CHECK_ID => P_OLD_PLAN_HEADERS_B_REC.PROFILE_CHECK_ID,
2382: x_return_status => x_return_status,
2383: x_msg_count => x_msg_count,
2384: x_msg_data => x_msg_data);
2388:
2389: Validate_CRITERIA_VALUE_LOW(
2390: p_init_msg_list => FND_API.G_FALSE,
2391: p_validation_mode => p_validation_mode,
2392: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2393: p_CRITERIA_VALUE_LOW => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_LOW,
2394: p_OLD_CRITERIA_VALUE_LOW => P_OLD_PLAN_HEADERS_B_REC.CRITERIA_VALUE_LOW,
2395: x_return_status => x_return_status,
2396: x_msg_count => x_msg_count,
2389: Validate_CRITERIA_VALUE_LOW(
2390: p_init_msg_list => FND_API.G_FALSE,
2391: p_validation_mode => p_validation_mode,
2392: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2393: p_CRITERIA_VALUE_LOW => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_LOW,
2394: p_OLD_CRITERIA_VALUE_LOW => P_OLD_PLAN_HEADERS_B_REC.CRITERIA_VALUE_LOW,
2395: x_return_status => x_return_status,
2396: x_msg_count => x_msg_count,
2397: x_msg_data => x_msg_data);
2401:
2402: Validate_CRITERIA_VALUE_HIGH(
2403: p_init_msg_list => FND_API.G_FALSE,
2404: p_validation_mode => p_validation_mode,
2405: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2406: p_CRITERIA_VALUE_HIGH => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_HIGH,
2407: p_OLD_CRITERIA_VALUE_HIGH => P_OLD_PLAN_HEADERS_B_REC.CRITERIA_VALUE_HIGH,
2408: x_return_status => x_return_status,
2409: x_msg_count => x_msg_count,
2402: Validate_CRITERIA_VALUE_HIGH(
2403: p_init_msg_list => FND_API.G_FALSE,
2404: p_validation_mode => p_validation_mode,
2405: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2406: p_CRITERIA_VALUE_HIGH => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_HIGH,
2407: p_OLD_CRITERIA_VALUE_HIGH => P_OLD_PLAN_HEADERS_B_REC.CRITERIA_VALUE_HIGH,
2408: x_return_status => x_return_status,
2409: x_msg_count => x_msg_count,
2410: x_msg_data => x_msg_data);
2414:
2415: Validate_RELATIONAL_OPERATOR(
2416: p_init_msg_list => FND_API.G_FALSE,
2417: p_validation_mode => p_validation_mode,
2418: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2419: p_RELATIONAL_OPERATOR => P_CSC_PLAN_HEADERS_B_REC.RELATIONAL_OPERATOR,
2420: p_OLD_RELATIONAL_OPERATOR => P_OLD_PLAN_HEADERS_B_REC.RELATIONAL_OPERATOR,
2421: x_return_status => x_return_status,
2422: x_msg_count => x_msg_count,
2415: Validate_RELATIONAL_OPERATOR(
2416: p_init_msg_list => FND_API.G_FALSE,
2417: p_validation_mode => p_validation_mode,
2418: p_plan_id => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2419: p_RELATIONAL_OPERATOR => P_CSC_PLAN_HEADERS_B_REC.RELATIONAL_OPERATOR,
2420: p_OLD_RELATIONAL_OPERATOR => P_OLD_PLAN_HEADERS_B_REC.RELATIONAL_OPERATOR,
2421: x_return_status => x_return_status,
2422: x_msg_count => x_msg_count,
2423: x_msg_data => x_msg_data);
2427:
2428: Validate_Plan_Criteria (
2429: P_Init_Msg_List => p_init_msg_list,
2430: P_Validation_mode => p_validation_mode,
2431: P_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2432: P_RELATIONAL_OPERATOR => P_CSC_PLAN_HEADERS_B_REC.RELATIONAL_OPERATOR,
2433: P_CRITERIA_VALUE_LOW => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_LOW,
2434: P_CRITERIA_VALUE_HIGH => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_HIGH,
2435: X_Return_Status => x_return_status,
2428: Validate_Plan_Criteria (
2429: P_Init_Msg_List => p_init_msg_list,
2430: P_Validation_mode => p_validation_mode,
2431: P_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2432: P_RELATIONAL_OPERATOR => P_CSC_PLAN_HEADERS_B_REC.RELATIONAL_OPERATOR,
2433: P_CRITERIA_VALUE_LOW => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_LOW,
2434: P_CRITERIA_VALUE_HIGH => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_HIGH,
2435: X_Return_Status => x_return_status,
2436: X_Msg_Count => x_msg_count,
2429: P_Init_Msg_List => p_init_msg_list,
2430: P_Validation_mode => p_validation_mode,
2431: P_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2432: P_RELATIONAL_OPERATOR => P_CSC_PLAN_HEADERS_B_REC.RELATIONAL_OPERATOR,
2433: P_CRITERIA_VALUE_LOW => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_LOW,
2434: P_CRITERIA_VALUE_HIGH => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_HIGH,
2435: X_Return_Status => x_return_status,
2436: X_Msg_Count => x_msg_count,
2437: X_Msg_Data => x_msg_data );
2430: P_Validation_mode => p_validation_mode,
2431: P_PLAN_ID => P_CSC_PLAN_HEADERS_B_REC.PLAN_ID,
2432: P_RELATIONAL_OPERATOR => P_CSC_PLAN_HEADERS_B_REC.RELATIONAL_OPERATOR,
2433: P_CRITERIA_VALUE_LOW => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_LOW,
2434: P_CRITERIA_VALUE_HIGH => P_CSC_PLAN_HEADERS_B_REC.CRITERIA_VALUE_HIGH,
2435: X_Return_Status => x_return_status,
2436: X_Msg_Count => x_msg_count,
2437: X_Msg_Data => x_msg_data );
2438: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN