156: x_msg_data => x_msg_data);
157:
158: x_dist_list_id := l_dist_list_id; -- Bug 4565156.
159:
160: -- Inserting record in pa_obj_status_lists
161: SELECT pa_obj_status_lists_s.NEXTVAL
162: INTO l_obj_status_list_id
163: FROM sys.dual;
164:
157:
158: x_dist_list_id := l_dist_list_id; -- Bug 4565156.
159:
160: -- Inserting record in pa_obj_status_lists
161: SELECT pa_obj_status_lists_s.NEXTVAL
162: INTO l_obj_status_list_id
163: FROM sys.dual;
164:
165: pa_obj_status_lists_pkg.INSERT_ROW (
161: SELECT pa_obj_status_lists_s.NEXTVAL
162: INTO l_obj_status_list_id
163: FROM sys.dual;
164:
165: pa_obj_status_lists_pkg.INSERT_ROW (
166: X_ROWID => l_obj_sl_rowid,
167: X_OBJ_STATUS_LIST_ID => l_obj_status_list_id,
168: X_OBJECT_TYPE => 'PA_CI_TYPES',
169: X_OBJECT_ID => x_ci_type_id,
447: x_last_update_date => p_last_update_date,
448: x_last_updated_by => p_last_updated_by,
449: x_last_update_login => p_last_update_login);
450:
451: pa_obj_status_lists_pkg.UPDATE_ROW (
452: X_OBJ_STATUS_LIST_ID => p_obj_status_list_id,
453: X_OBJECT_TYPE => 'PA_CI_TYPES',
454: X_OBJECT_ID => p_ci_type_id,
455: X_STATUS_LIST_ID => p_status_list_id,
514: WHERE ci_type_id = p_ci_type_id;
515:
516: CURSOR c_obj_status_lists IS
517: SELECT *
518: FROM pa_obj_status_lists
519: WHERE obj_status_list_id = p_obj_status_list_id;
520:
521: l_temp VARCHAR2(1);
522: BEGIN
620: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
621: pa_ci_types_pkg.delete_row(
622: x_ci_type_id => p_ci_type_id);
623:
624: --Deleting the association from pa_obj_status_lists
625: pa_obj_status_lists_pkg.delete_row(
626: x_obj_status_list_id => p_obj_status_list_id);
627: END IF;
628:
621: pa_ci_types_pkg.delete_row(
622: x_ci_type_id => p_ci_type_id);
623:
624: --Deleting the association from pa_obj_status_lists
625: pa_obj_status_lists_pkg.delete_row(
626: x_obj_status_list_id => p_obj_status_list_id);
627: END IF;
628:
629: IF p_commit = fnd_api.g_true THEN