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.OE_PC_RSETS_PKG dependencies on OE_PC_RSETS

Line 1: PACKAGE BODY OE_PC_RSETS_PKG AS

1: PACKAGE BODY OE_PC_RSETS_PKG AS
2: /* $Header: OEXPCRDB.pls 120.1 2005/07/14 06:12:29 appldev ship $ */
3:
4:
5: PROCEDURE Insert_Row(

Line 37: CURSOR CROWID IS SELECT rowid FROM oe_pc_rsets

33: ,x_attribute14 in varchar2
34: ,x_attribute15 in varchar2
35: )
36: Is
37: CURSOR CROWID IS SELECT rowid FROM oe_pc_rsets
38: WHERE record_set_id = x_record_set_id;
39:
40: CURSOR CID IS SELECT oe_pc_rsets_s.nextval
41: FROM sys.dual;

Line 40: CURSOR CID IS SELECT oe_pc_rsets_s.nextval

36: Is
37: CURSOR CROWID IS SELECT rowid FROM oe_pc_rsets
38: WHERE record_set_id = x_record_set_id;
39:
40: CURSOR CID IS SELECT oe_pc_rsets_s.nextval
41: FROM sys.dual;
42: Begin
43:
44: IF x_record_set_id IS NULL THEN

Line 54: INSERT INTO oe_pc_rsets (

50: end if;
51: Close CID;
52: END IF;
53:
54: INSERT INTO oe_pc_rsets (
55: record_set_id
56: ,entity_id
57: ,record_set_short_name
58: ,pk_record_set_flag

Line 113: INSERT INTO oe_pc_rsets_tl (

109: ,x_attribute15
110: );
111:
112:
113: INSERT INTO oe_pc_rsets_tl (
114: record_set_id
115: ,language
116: ,source_lang
117: ,created_by

Line 140: FROM oe_pc_rsets_tl t

136: FROM fnd_languages l
137: WHERE l.installed_flag in ('I', 'B')
138: AND not exists (
139: SELECT null
140: FROM oe_pc_rsets_tl t
141: WHERE t.record_set_id = x_record_set_id
142: AND t.language = l.language_code);
143:
144: Open CROWID;

Line 188: FROM oe_pc_rsets

184: )
185: Is
186: CURSOR C IS
187: SELECT *
188: FROM oe_pc_rsets
189: WHERE rowid = x_rowid
190: FOR UPDATE OF record_set_id NOWAIT;
191:
192: Recinfo C%ROWTYPE;

Line 196: FROM oe_pc_rsets_tl t

192: Recinfo C%ROWTYPE;
193:
194: CURSOR C1 IS
195: SELECT *
196: FROM oe_pc_rsets_tl t
197: WHERE record_set_id = x_record_set_id
198: AND language = userenv('LANG')
199: FOR UPDATE OF record_set_id NOWAIT;
200:

Line 295: UPDATE oe_pc_rsets

291: )
292: Is
293: Begin
294:
295: UPDATE oe_pc_rsets
296: SET
297: record_set_id = x_record_set_id
298: ,entity_id = x_entity_id
299: ,record_set_short_name = x_record_set_short_name

Line 329: UPDATE oe_pc_rsets_tl

325: RAISE NO_DATA_FOUND;
326: end if;
327:
328:
329: UPDATE oe_pc_rsets_tl
330: SET
331: source_lang = USERENV('LANG')
332: ,last_updated_by = x_last_updated_by
333: ,last_update_date = x_last_update_date

Line 362: DELETE FROM OE_PC_RSETS_TL

358: DELETE FROM OE_PC_VALIDATION_PKGS
359: WHERE record_set_id = x_record_set_id;
360:
361: -- delete the tl table
362: DELETE FROM OE_PC_RSETS_TL
363: WHERE record_set_id = x_record_set_id;
364:
365: DELETE FROM OE_PC_RSETS
366: WHERE record_set_id = x_record_set_id;

Line 365: DELETE FROM OE_PC_RSETS

361: -- delete the tl table
362: DELETE FROM OE_PC_RSETS_TL
363: WHERE record_set_id = x_record_set_id;
364:
365: DELETE FROM OE_PC_RSETS
366: WHERE record_set_id = x_record_set_id;
367:
368: if (SQL%NOTFOUND) then
369: RAISE NO_DATA_FOUND;

Line 377: DELETE FROM oe_pc_rsets_tl t

373: -------------------------------------------------------------------
374: PROCEDURE Add_Language
375: IS
376: Begin
377: DELETE FROM oe_pc_rsets_tl t
378: WHERE NOT EXISTS
379: (SELECT null
380: FROM oe_pc_rsets b
381: where record_set_id = t.record_set_id);

Line 380: FROM oe_pc_rsets b

376: Begin
377: DELETE FROM oe_pc_rsets_tl t
378: WHERE NOT EXISTS
379: (SELECT null
380: FROM oe_pc_rsets b
381: where record_set_id = t.record_set_id);
382:
383: UPDATE oe_pc_rsets_tl t
384: SET

Line 383: UPDATE oe_pc_rsets_tl t

379: (SELECT null
380: FROM oe_pc_rsets b
381: where record_set_id = t.record_set_id);
382:
383: UPDATE oe_pc_rsets_tl t
384: SET
385: (
386: display_name,
387: description

Line 392: FROM oe_pc_rsets_tl b

388: ) = (
389: SELECT
390: b.display_name,
391: b.description
392: FROM oe_pc_rsets_tl b
393: WHERE b.record_set_id = t.record_set_id
394: AND b.language = t.source_lang
395: )
396: where

Line 404: FROM oe_pc_rsets_tl subb, oe_pc_rsets_tl subt

400: ) IN (
401: SELECT
402: subt.record_set_id,
403: subt.language
404: FROM oe_pc_rsets_tl subb, oe_pc_rsets_tl subt
405: WHERE subb.record_set_id = subt.record_set_id
406: AND subb.language = subt.source_lang
407: AND(subb.display_name <> subt.display_name
408: OR subb.DESCRIPTION <> subt.description

Line 414: INSERT INTO oe_pc_rsets_tl

410: OR (subb.description IS NOT null AND subt.description IS null)
411: )
412: );
413:
414: INSERT INTO oe_pc_rsets_tl
415: (
416: record_set_id
417: ,language
418: ,source_lang

Line 438: FROM oe_pc_rsets_tl b, fnd_languages l

434: ,b.last_update_date
435: ,b.display_name
436: ,b.description
437: ,b.last_update_login
438: FROM oe_pc_rsets_tl b, fnd_languages l
439: WHERE l.installed_flag IN ('I', 'B')
440: AND b.language = USERENV('LANG')
441: AND NOT EXISTS
442: ( SELECT null

Line 443: FROM oe_pc_rsets_tl t

439: WHERE l.installed_flag IN ('I', 'B')
440: AND b.language = USERENV('LANG')
441: AND NOT EXISTS
442: ( SELECT null
443: FROM oe_pc_rsets_tl t
444: WHERE t.record_set_id = b.record_set_id
445: AND t.language = l.language_code);
446: End Add_Language;
447: -------------------------------------------------------------------

Line 498: FROM oe_pc_rsets_vl

494: if (chk_display_name = TRUE) then
495: -- record set short name should be unique within an entity
496: SELECT count(1)
497: INTO dummy
498: FROM oe_pc_rsets_vl
499: WHERE entity_id = x_entity_id
500: AND record_set_display_name = x_record_set_display_name
501: AND ((x_rowid IS null) OR (row_id <> x_rowid));
502:

Line 513: FROM oe_pc_rsets

509: if (chk_short_name = TRUE) then
510: -- record set short name should be unique within an entity
511: SELECT count(1)
512: INTO dummy
513: FROM oe_pc_rsets
514: WHERE entity_id = x_entity_id
515: AND record_set_short_name = x_record_set_short_name
516: AND ((x_rowid IS null) OR (rowid <> x_rowid));
517:

Line 527: FROM oe_pc_rsets

523: if (chk_pk_flag = TRUE) then
524: -- there can be only one record set with pk_record_set_flag = Y
525: SELECT count(1)
526: INTO dummy
527: FROM oe_pc_rsets
528: WHERE entity_id = x_entity_id
529: AND pk_record_set_flag = 'Y'
530: AND x_pk_record_set_flag = 'Y'
531: AND ((x_rowid IS null) OR (rowid <> x_rowid));

Line 552: UPDATE oe_pc_rsets_tl

548: IS
549: l_user_id number :=0;
550: BEGIN
551: l_user_id := fnd_load_util.owner_id(x_owner); --Seed data changes
552: UPDATE oe_pc_rsets_tl
553: SET
554: source_lang = USERENV('LANG')
555: --,last_updated_by = decode(x_OWNER, 'SEED', 1, 0)
556: ,last_updated_by = l_user_id

Line 611: from oe_pc_rsets

607: user_id :=fnd_load_util.owner_id(x_owner);
608: begin
609: select last_updated_by
610: into l_db_user_id
611: from oe_pc_rsets
612: WHERE record_set_id = x_record_set_id;
613: exception
614: when no_data_found then
615: null;

Line 624: OE_PC_Rsets_pkg.UPDATE_ROW(

620: l_valid_release:=true;
621: end if;
622: if l_valid_release then
623: --seed data changes end
624: OE_PC_Rsets_pkg.UPDATE_ROW(
625: x_rowid => row_id
626: ,x_record_set_id => x_record_set_id
627: ,x_record_set_display_name => x_record_set_display_name
628: ,x_record_set_description => x_record_set_description

Line 661: oe_pc_rsets_pkg.INSERT_ROW(

657: when NO_DATA_FOUND then
658:
659: l_record_set_id := x_record_set_id;
660:
661: oe_pc_rsets_pkg.INSERT_ROW(
662: x_rowid => row_id
663: ,x_record_set_id => l_record_set_id
664: ,x_record_set_display_name => x_record_set_display_name
665: ,x_record_set_description => x_record_set_description

Line 696: END OE_PC_RSETS_PKG;

692: end;
693:
694: END LOAD_ROW;
695:
696: END OE_PC_RSETS_PKG;