eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_INT_TYPE_PKG dependencies on CN_INTERVAL_TYPES

Line 7: -- Table handler for CN_INTERVAL_TYPES

3: --
4: -- Package Name
5: -- CN_INT_TYPE_PKG
6: -- Purpose
7: -- Table handler for CN_INTERVAL_TYPES
8: -- Form
9: -- CNINTTP
10: -- Block
11: -- INTERVAL_TYPES

Line 24: SELECT cn_interval_types_s.NEXTVAL

20: -- Get the sequence number to create a new interval type
21: -- *--------------------------------------------------------------------------*/
22: PROCEDURE get_interval_type_id( x_interval_type_id IN OUT NOCOPY NUMBER) IS
23: BEGIN
24: SELECT cn_interval_types_s.NEXTVAL
25: INTO x_interval_type_id
26: FROM dual;
27: END get_interval_type_id;
28:

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 114: insert into CN_INTERVAL_TYPES_ALL_TL (

110: X_LAST_UPDATE_LOGIN,
111: X_ORG_ID
112: );
113:
114: insert into CN_INTERVAL_TYPES_ALL_TL (
115: INTERVAL_TYPE_ID,
116: NAME,
117: CREATED_BY,
118: CREATION_DATE,

Line 140: from CN_INTERVAL_TYPES_ALL_TL T

136: from FND_LANGUAGES L
137: where L.INSTALLED_FLAG in ('I', 'B')
138: and not exists
139: (select NULL
140: from CN_INTERVAL_TYPES_ALL_TL T
141: where T.INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID
142: and T.LANGUAGE = L.LANGUAGE_CODE
143: and T.ORG_ID = X_ORG_ID);
144:

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 204: from CN_INTERVAL_TYPES_ALL_TL

200:
201: cursor c1 is select
202: NAME,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from CN_INTERVAL_TYPES_ALL_TL
205: where INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
207: for update of INTERVAL_TYPE_ID nowait;
208: begin

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 326: update CN_INTERVAL_TYPES_ALL_TL set

322: if (sql%notfound) then
323: raise no_data_found;
324: end if;
325:
326: update CN_INTERVAL_TYPES_ALL_TL set
327: NAME = X_NAME,
328: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
329: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
330: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 344: delete from CN_INTERVAL_TYPES_ALL_TL

340: procedure DELETE_ROW (
341: X_INTERVAL_TYPE_ID in NUMBER
342: ) is
343: begin
344: delete from CN_INTERVAL_TYPES_ALL_TL
345: where INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID;
346:
347: if (sql%notfound) then
348: raise no_data_found;

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 362: delete from CN_INTERVAL_TYPES_ALL_TL T

358:
359: procedure ADD_LANGUAGE
360: is
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

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 370: update CN_INTERVAL_TYPES_ALL_TL T set (

366: where B.INTERVAL_TYPE_ID = T.interval_type_id
367: and B.ORG_ID = T.ORG_ID
368: );
369:
370: update CN_INTERVAL_TYPES_ALL_TL T set (
371: NAME
372: ) = (select
373: B.NAME
374: from CN_INTERVAL_TYPES_ALL_TL B

Line 374: from CN_INTERVAL_TYPES_ALL_TL B

370: update CN_INTERVAL_TYPES_ALL_TL T set (
371: NAME
372: ) = (select
373: B.NAME
374: from CN_INTERVAL_TYPES_ALL_TL B
375: where B.INTERVAL_TYPE_ID = T.INTERVAL_TYPE_ID
376: and B.LANGUAGE = T.source_lang
377: and B.ORG_ID = T.ORG_ID)
378: where (

Line 384: from CN_INTERVAL_TYPES_ALL_TL SUBB, CN_INTERVAL_TYPES_ALL_TL SUBT

380: T.LANGUAGE
381: ) in (select
382: SUBT.INTERVAL_TYPE_ID,
383: SUBT.LANGUAGE
384: from CN_INTERVAL_TYPES_ALL_TL SUBB, CN_INTERVAL_TYPES_ALL_TL SUBT
385: where SUBB.INTERVAL_TYPE_ID = SUBT.INTERVAL_TYPE_ID
386: and SUBB.LANGUAGE = SUBT.source_lang
387: and SUBB.ORG_ID =SUBT.ORG_ID
388: and (SUBB.NAME <> SUBT.NAME

Line 393: insert into CN_INTERVAL_TYPES_ALL_TL (

389: or (SUBB.NAME is null and SUBT.NAME is not null)
390: or (SUBB.NAME is not null and SUBT.NAME is null)
391: ));
392:
393: insert into CN_INTERVAL_TYPES_ALL_TL (
394: ORG_ID,
395: INTERVAL_TYPE_ID,
396: NAME,
397: CREATED_BY,

Line 415: from CN_INTERVAL_TYPES_ALL_TL B, FND_LANGUAGES L

411: B.LAST_UPDATE_DATE,
412: B.LAST_UPDATE_LOGIN,
413: L.LANGUAGE_CODE,
414: B.SOURCE_LANG
415: from CN_INTERVAL_TYPES_ALL_TL B, FND_LANGUAGES L
416: where L.INSTALLED_FLAG in ('I', 'B')
417: and B.LANGUAGE = userenv('LANG')
418: and not exists
419: (select NULL

Line 420: from CN_INTERVAL_TYPES_ALL_TL T

416: where L.INSTALLED_FLAG in ('I', 'B')
417: and B.LANGUAGE = userenv('LANG')
418: and not exists
419: (select NULL
420: from CN_INTERVAL_TYPES_ALL_TL T
421: where T.INTERVAL_TYPE_ID = B.INTERVAL_TYPE_ID
422: and T.LANGUAGE = L.language_code
423: and T.ORG_ID = B.ORG_ID );
424: end ADD_LANGUAGE;

Line 433: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,

429: -- Purpose
430: -- Populate the table cn_cal_per_int_types after creating an interval type
431: -- *--------------------------------------------------------------------------*/
432: PROCEDURE post_insert
433: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
434: x_last_update_date cn_interval_types.last_update_date%TYPE,
435: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
436: x_creation_date cn_interval_types.creation_date%TYPE,
437: x_created_by cn_interval_types.created_by%TYPE,

Line 434: x_last_update_date cn_interval_types.last_update_date%TYPE,

430: -- Populate the table cn_cal_per_int_types after creating an interval type
431: -- *--------------------------------------------------------------------------*/
432: PROCEDURE post_insert
433: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
434: x_last_update_date cn_interval_types.last_update_date%TYPE,
435: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
436: x_creation_date cn_interval_types.creation_date%TYPE,
437: x_created_by cn_interval_types.created_by%TYPE,
438: x_last_update_login cn_interval_types.last_update_login%TYPE,

Line 435: x_last_updated_by cn_interval_types.last_updated_by%TYPE,

431: -- *--------------------------------------------------------------------------*/
432: PROCEDURE post_insert
433: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
434: x_last_update_date cn_interval_types.last_update_date%TYPE,
435: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
436: x_creation_date cn_interval_types.creation_date%TYPE,
437: x_created_by cn_interval_types.created_by%TYPE,
438: x_last_update_login cn_interval_types.last_update_login%TYPE,
439: x_org_id cn_interval_types.org_id%TYPE

Line 436: x_creation_date cn_interval_types.creation_date%TYPE,

432: PROCEDURE post_insert
433: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
434: x_last_update_date cn_interval_types.last_update_date%TYPE,
435: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
436: x_creation_date cn_interval_types.creation_date%TYPE,
437: x_created_by cn_interval_types.created_by%TYPE,
438: x_last_update_login cn_interval_types.last_update_login%TYPE,
439: x_org_id cn_interval_types.org_id%TYPE
440: ) IS

Line 437: x_created_by cn_interval_types.created_by%TYPE,

433: ( x_interval_type_id cn_interval_types.interval_type_id%TYPE,
434: x_last_update_date cn_interval_types.last_update_date%TYPE,
435: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
436: x_creation_date cn_interval_types.creation_date%TYPE,
437: x_created_by cn_interval_types.created_by%TYPE,
438: x_last_update_login cn_interval_types.last_update_login%TYPE,
439: x_org_id cn_interval_types.org_id%TYPE
440: ) IS
441: l_period_set_id NUMBER;

Line 438: x_last_update_login cn_interval_types.last_update_login%TYPE,

434: x_last_update_date cn_interval_types.last_update_date%TYPE,
435: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
436: x_creation_date cn_interval_types.creation_date%TYPE,
437: x_created_by cn_interval_types.created_by%TYPE,
438: x_last_update_login cn_interval_types.last_update_login%TYPE,
439: x_org_id cn_interval_types.org_id%TYPE
440: ) IS
441: l_period_set_id NUMBER;
442: l_period_type_id NUMBER;

Line 439: x_org_id cn_interval_types.org_id%TYPE

435: x_last_updated_by cn_interval_types.last_updated_by%TYPE,
436: x_creation_date cn_interval_types.creation_date%TYPE,
437: x_created_by cn_interval_types.created_by%TYPE,
438: x_last_update_login cn_interval_types.last_update_login%TYPE,
439: x_org_id cn_interval_types.org_id%TYPE
440: ) IS
441: l_period_set_id NUMBER;
442: l_period_type_id NUMBER;
443: l_period_id NUMBER;

Line 489: PROCEDURE post_delete( x_interval_type_id cn_interval_types.interval_type_id%TYPE) IS

485: -- post_delete
486: -- Purpose
487: -- Delete the corresponding records in cn_cal_per_int_types after deleting an interval type
488: -- *--------------------------------------------------------------------------*/
489: PROCEDURE post_delete( x_interval_type_id cn_interval_types.interval_type_id%TYPE) IS
490: BEGIN
491: DELETE FROM cn_cal_per_int_types_all
492: WHERE interval_type_id = x_interval_type_id;
493: EXCEPTION

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,

Line 554: UPDATE cn_interval_types_all_tl SET

550: x_org_id
551: );
552: END IF;
553: -- Load The record to _TL table
554: UPDATE cn_interval_types_all_tl SET
555: name = x_name,
556: last_update_date = sysdate,
557: last_updated_by = user_id,
558: last_update_login = 0,

Line 565: INSERT INTO cn_interval_types_all_tl

561: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
562:
563: IF (SQL%NOTFOUND) THEN
564: -- Insert new record to _TL table
565: INSERT INTO cn_interval_types_all_tl
566: (interval_type_id,
567: name,
568: creation_date,
569: created_by,

Line 591: FROM cn_interval_types_all_tl t

587: FROM fnd_languages l
588: WHERE l.installed_flag IN ('I', 'B')
589: AND NOT EXISTS
590: (SELECT NULL
591: FROM cn_interval_types_all_tl t
592: WHERE t.interval_type_id = x_interval_type_id
593: AND t.language = l.language_code
594: and t.org_id = x_org_id);
595: END IF;

Line 623: UPDATE cn_interval_types_all_tl SET

619: ELSE
620: user_id := 0;
621: END IF;
622: -- Update the translation
623: UPDATE cn_interval_types_all_tl SET
624: name = x_name,
625: last_update_date = sysdate,
626: last_updated_by = user_id,
627: last_update_login = 0,