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_CONDITIONS_PKG dependencies on OE_PC_CONDITIONS

Line 1: package body OE_PC_CONDITIONS_PKG as

1: package body OE_PC_CONDITIONS_PKG as
2: /* $Header: OEXPCCDB.pls 120.1 2005/07/15 01:32:02 ppnair noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 41: cursor C is select ROWID from OE_PC_CONDITIONS

37: X_LAST_UPDATE_DATE in DATE,
38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER
40: ) is
41: cursor C is select ROWID from OE_PC_CONDITIONS
42: where CONDITION_ID = X_CONDITION_ID
43: ;
44: begin
45:

Line 46: insert into OE_PC_CONDITIONS (

42: where CONDITION_ID = X_CONDITION_ID
43: ;
44: begin
45:
46: insert into OE_PC_CONDITIONS (
47: CONDITION_ID,
48: CONSTRAINT_ID,
49: GROUP_NUMBER,
50: SYSTEM_FLAG,

Line 116: insert into OE_PC_CONDITIONS_TL (

112: X_LAST_UPDATED_BY,
113: X_LAST_UPDATE_LOGIN
114: );
115:
116: insert into OE_PC_CONDITIONS_TL (
117: CONDITION_ID,
118: USER_MESSAGE,
119: CREATED_BY,
120: CREATION_DATE,

Line 140: from OE_PC_CONDITIONS_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_CONDITIONS_TL T
141: where T.CONDITION_ID = X_CONDITION_ID
142: and T.LANGUAGE = L.LANGUAGE_CODE);
143:
144: open c;

Line 215: from OE_PC_CONDITIONS

211: ATTRIBUTE15,
212: START_DATE_ACTIVE,
213: END_DATE_ACTIVE,
214: ENABLED_FLAG
215: from OE_PC_CONDITIONS
216: where CONDITION_ID = X_CONDITION_ID
217: for update of CONDITION_ID nowait;
218: recinfo c%rowtype;
219:

Line 223: from OE_PC_CONDITIONS_TL

219:
220: cursor c1 is select
221: USER_MESSAGE,
222: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
223: from OE_PC_CONDITIONS_TL
224: where CONDITION_ID = X_CONDITION_ID
225: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
226: for update of CONDITION_ID nowait;
227: begin

Line 336: update OE_PC_CONDITIONS set

332: X_LAST_UPDATE_LOGIN in NUMBER
333: ) is
334: begin
335:
336: update OE_PC_CONDITIONS set
337: CONSTRAINT_ID = X_CONSTRAINT_ID,
338: GROUP_NUMBER = X_GROUP_NUMBER,
339: SYSTEM_FLAG = X_SYSTEM_FLAG,
340: MODIFIER_FLAG = X_MODIFIER_FLAG,

Line 373: update OE_PC_CONDITIONS_TL set

369: if (sql%notfound) then
370: raise no_data_found;
371: end if;
372:
373: update OE_PC_CONDITIONS_TL set
374: USER_MESSAGE = X_USER_MESSAGE,
375: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
376: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
377: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 394: delete from OE_PC_CONDITIONS_TL

390: X_CONDITION_ID in NUMBER
391: ) is
392: begin
393:
394: delete from OE_PC_CONDITIONS_TL
395: where CONDITION_ID = X_CONDITION_ID;
396:
397: if (sql%notfound) then
398: raise no_data_found;

Line 401: delete from OE_PC_CONDITIONS

397: if (sql%notfound) then
398: raise no_data_found;
399: end if;
400:
401: delete from OE_PC_CONDITIONS
402: where CONDITION_ID = X_CONDITION_ID;
403:
404: if (sql%notfound) then
405: raise no_data_found;

Line 413: delete from OE_PC_CONDITIONS_TL T

409:
410: procedure ADD_LANGUAGE
411: is
412: begin
413: delete from OE_PC_CONDITIONS_TL T
414: where not exists
415: (select NULL
416: from OE_PC_CONDITIONS B
417: where B.CONDITION_ID = T.CONDITION_ID

Line 416: from OE_PC_CONDITIONS B

412: begin
413: delete from OE_PC_CONDITIONS_TL T
414: where not exists
415: (select NULL
416: from OE_PC_CONDITIONS B
417: where B.CONDITION_ID = T.CONDITION_ID
418: );
419:
420: update OE_PC_CONDITIONS_TL T set (

Line 420: update OE_PC_CONDITIONS_TL T set (

416: from OE_PC_CONDITIONS B
417: where B.CONDITION_ID = T.CONDITION_ID
418: );
419:
420: update OE_PC_CONDITIONS_TL T set (
421: USER_MESSAGE
422: ) = (select
423: B.USER_MESSAGE
424: from OE_PC_CONDITIONS_TL B

Line 424: from OE_PC_CONDITIONS_TL B

420: update OE_PC_CONDITIONS_TL T set (
421: USER_MESSAGE
422: ) = (select
423: B.USER_MESSAGE
424: from OE_PC_CONDITIONS_TL B
425: where B.CONDITION_ID = T.CONDITION_ID
426: and B.LANGUAGE = T.SOURCE_LANG)
427: where (
428: T.CONDITION_ID,

Line 433: from OE_PC_CONDITIONS_TL SUBB, OE_PC_CONDITIONS_TL SUBT

429: T.LANGUAGE
430: ) in (select
431: SUBT.CONDITION_ID,
432: SUBT.LANGUAGE
433: from OE_PC_CONDITIONS_TL SUBB, OE_PC_CONDITIONS_TL SUBT
434: where SUBB.CONDITION_ID = SUBT.CONDITION_ID
435: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
436: and (SUBB.USER_MESSAGE <> SUBT.USER_MESSAGE
437: ));

Line 439: insert into OE_PC_CONDITIONS_TL (

435: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
436: and (SUBB.USER_MESSAGE <> SUBT.USER_MESSAGE
437: ));
438:
439: insert into OE_PC_CONDITIONS_TL (
440: CONDITION_ID,
441: USER_MESSAGE,
442: CREATED_BY,
443: CREATION_DATE,

Line 459: from OE_PC_CONDITIONS_TL B, FND_LANGUAGES L

455: B.LAST_UPDATE_DATE,
456: B.LAST_UPDATE_LOGIN,
457: L.LANGUAGE_CODE,
458: B.SOURCE_LANG
459: from OE_PC_CONDITIONS_TL B, FND_LANGUAGES L
460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL

Line 464: from OE_PC_CONDITIONS_TL T

460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL
464: from OE_PC_CONDITIONS_TL T
465: where T.CONDITION_ID = B.CONDITION_ID
466: and T.LANGUAGE = L.LANGUAGE_CODE);
467: end ADD_LANGUAGE;
468:

Line 478: update OE_PC_CONDITIONS_TL set

474: is
475: l_user_id number:=0;
476: begin
477: l_user_id :=fnd_load_util.owner_id(x_owner); --seed data versioning changes
478: update OE_PC_CONDITIONS_TL set
479: USER_MESSAGE = X_USER_MESSAGE,
480: LAST_UPDATE_DATE = sysdate,
481: --LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
482: LAST_UPDATED_BY =l_user_id ,

Line 523: CURSOR CID IS SELECT oe_pc_conditions_s.nextval from dual;

519: X_START_DATE_ACTIVE in VARCHAR2,
520: X_END_DATE_ACTIVE in VARCHAR2,
521: X_ENABLED_FLAG in VARCHAR2 DEFAULT NULL
522: ) is
523: CURSOR CID IS SELECT oe_pc_conditions_s.nextval from dual;
524: begin
525:
526: declare
527: user_id number := 0;

Line 541: from OE_PC_CONDITIONS

537: user_id :=fnd_load_util.owner_id(x_owner);
538: begin
539: select last_updated_by
540: into l_db_user_id
541: from OE_PC_CONDITIONS
542: where CONDITION_ID = X_CONDITION_ID;
543: exception
544: when no_data_found then null;
545: end;

Line 553: OE_PC_CONDITIONS_pkg.UPDATE_ROW(

549: l_valid_release :=true ;
550: end if;
551: if l_valid_release then
552: --seed data version changes end
553: OE_PC_CONDITIONS_pkg.UPDATE_ROW(
554: x_condition_id => x_condition_id
555: ,x_group_number => x_group_number
556: ,x_constraint_id => x_constraint_id
557: ,x_system_flag => x_system_flag

Line 591: OE_PC_CONDITIONS_pkg.INSERT_ROW(

587: end if;
588: exception
589: when NO_DATA_FOUND then
590:
591: OE_PC_CONDITIONS_pkg.INSERT_ROW(
592: x_rowid => row_id
593: ,x_condition_id => x_condition_id
594: ,x_group_number => x_group_number
595: ,x_constraint_id => x_constraint_id

Line 632: end OE_PC_CONDITIONS_PKG;

628: end;
629:
630: end Load_Row;
631:
632: end OE_PC_CONDITIONS_PKG;