53: X_LAST_UPDATED_BY in NUMBER,
54: X_LAST_UPDATE_LOGIN in NUMBER,
55: X_ORG_ID in NUMBER
56: ) is
57: cursor C is select ROWID from CN_INTERVAL_TYPES_ALL_B
58: where INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID
59: and ORG_ID = X_ORG_ID
60: ;
61: begin
58: where INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID
59: and ORG_ID = X_ORG_ID
60: ;
61: begin
62: insert into CN_INTERVAL_TYPES_ALL_B (
63: INTERVAL_TYPE_ID,
64: DESCRIPTION,
65: ATTRIBUTE_CATEGORY,
66: ATTRIBUTE1,
191: ATTRIBUTE12,
192: ATTRIBUTE13,
193: ATTRIBUTE14,
194: ATTRIBUTE15
195: from CN_INTERVAL_TYPES_ALL_B
196: where INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID
197: and ORG_ID = nvl(X_ORG_ID, ORG_ID)
198: for update of INTERVAL_TYPE_ID nowait;
199: recinfo c%rowtype;
294: X_LAST_UPDATE_LOGIN in NUMBER,
295: X_ORG_ID in NUMBER
296: ) is
297: begin
298: update CN_INTERVAL_TYPES_ALL_B set
299: DESCRIPTION = X_DESCRIPTION,
300: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
301: ATTRIBUTE1 = X_ATTRIBUTE1,
302: ATTRIBUTE2 = X_ATTRIBUTE2,
347: if (sql%notfound) then
348: raise no_data_found;
349: end if;
350:
351: delete from CN_INTERVAL_TYPES_ALL_B
352: where INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID;
353:
354: if (sql%notfound) then
355: raise no_data_found;
361: begin
362: delete from CN_INTERVAL_TYPES_ALL_TL T
363: where not exists
364: (select NULL
365: from CN_INTERVAL_TYPES_ALL_B B
366: where B.INTERVAL_TYPE_ID = T.interval_type_id
367: and B.ORG_ID = T.ORG_ID
368: );
369:
520: ELSE
521: user_id := 0;
522: END IF;
523: -- Load The record to _B table
524: UPDATE cn_interval_types_all_b SET
525: description = x_description,
526: last_update_date = sysdate,
527: last_updated_by = user_id,
528: last_update_login = 0
529: WHERE interval_type_id = x_interval_type_id;
530:
531: IF (SQL%NOTFOUND) THEN
532: -- Insert new record to _B table
533: INSERT INTO cn_interval_types_all_b
534: (interval_type_id,
535: description,
536: creation_date,
537: created_by,