APPS.CN_INT_TYPE_PKG dependencies on CN_INTERVAL_TYPES_ALL_B

Line 57: cursor C is select ROWID from CN_INTERVAL_TYPES_ALL_B

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

Line 62: insert into CN_INTERVAL_TYPES_ALL_B (

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,

Line 195: from CN_INTERVAL_TYPES_ALL_B

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;

Line 298: update CN_INTERVAL_TYPES_ALL_B set

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,

Line 351: delete from CN_INTERVAL_TYPES_ALL_B

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;

Line 365: from CN_INTERVAL_TYPES_ALL_B B

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:

Line 524: UPDATE cn_interval_types_all_b SET

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

Line 533: INSERT INTO cn_interval_types_all_b

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,