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.IGS_PE_ALTERNATV_EXT_PKG dependencies on IGS_PE_ALTERNATV_EXT

Line 1: package body IGS_PE_ALTERNATV_EXT_PKG as

1: package body IGS_PE_ALTERNATV_EXT_PKG as
2: /* $Header: IGSNI01B.pls 115.3 2002/11/29 01:13:42 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_ALTERNATV_EXT%RowType;

Line 5: old_references IGS_PE_ALTERNATV_EXT%RowType;

1: package body IGS_PE_ALTERNATV_EXT_PKG as
2: /* $Header: IGSNI01B.pls 115.3 2002/11/29 01:13:42 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_ALTERNATV_EXT%RowType;
6: new_references IGS_PE_ALTERNATV_EXT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PE_ALTERNATV_EXT%RowType;

2: /* $Header: IGSNI01B.pls 115.3 2002/11/29 01:13:42 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_ALTERNATV_EXT%RowType;
6: new_references IGS_PE_ALTERNATV_EXT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PE_ALTERNATV_EXT

20: ) as
21:
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_PE_ALTERNATV_EXT
25: WHERE rowid = x_rowid;
26:
27: BEGIN
28:

Line 65: -- ON IGS_PE_ALTERNATV_EXT

61:
62: -- Trigger description :-
63: -- "OSS_TST".trg_ae_br_iud
64: -- BEFORE INSERT OR DELETE OR UPDATE
65: -- ON IGS_PE_ALTERNATV_EXT
66: -- FOR EACH ROW
67:
68: PROCEDURE BeforeRowInsertUpdateDelete1(
69: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 74: v_course_cd IGS_PE_ALTERNATV_EXT.course_cd%TYPE;

70: p_updating IN BOOLEAN DEFAULT FALSE,
71: p_deleting IN BOOLEAN DEFAULT FALSE
72: ) as
73: v_message_name varchar2(30);
74: v_course_cd IGS_PE_ALTERNATV_EXT.course_cd%TYPE;
75: v_version_number IGS_PE_ALTERNATV_EXT.version_number%TYPE;
76: BEGIN
77: -- Set variables.
78: IF p_deleting THEN

Line 75: v_version_number IGS_PE_ALTERNATV_EXT.version_number%TYPE;

71: p_deleting IN BOOLEAN DEFAULT FALSE
72: ) as
73: v_message_name varchar2(30);
74: v_course_cd IGS_PE_ALTERNATV_EXT.course_cd%TYPE;
75: v_version_number IGS_PE_ALTERNATV_EXT.version_number%TYPE;
76: BEGIN
77: -- Set variables.
78: IF p_deleting THEN
79: v_course_cd := old_references.course_cd;

Line 170: IGS_PS_STDNT_APV_ALT_PKG.GET_FK_IGS_PE_ALTERNATV_EXT (

166:
167: PROCEDURE Check_Child_Existance as
168: BEGIN
169:
170: IGS_PS_STDNT_APV_ALT_PKG.GET_FK_IGS_PE_ALTERNATV_EXT (
171: old_references.course_cd,
172: old_references.version_number,
173: old_references.exit_course_cd
174: );

Line 186: FROM IGS_PE_ALTERNATV_EXT

182: ) RETURN BOOLEAN as
183:
184: CURSOR cur_rowid IS
185: SELECT rowid
186: FROM IGS_PE_ALTERNATV_EXT
187: WHERE course_cd = x_course_cd
188: AND version_number = x_version_number
189: AND exit_course_cd = x_exit_course_cd
190: FOR UPDATE NOWAIT;

Line 214: FROM IGS_PE_ALTERNATV_EXT

210: ) as
211:
212: CURSOR cur_rowid IS
213: SELECT rowid
214: FROM IGS_PE_ALTERNATV_EXT
215: WHERE exit_course_cd = x_course_cd ;
216:
217: lv_rowid cur_rowid%RowType;
218:

Line 241: FROM IGS_PE_ALTERNATV_EXT

237: ) as
238:
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM IGS_PE_ALTERNATV_EXT
242: WHERE course_cd = x_course_cd
243: AND version_number = x_version_number ;
244:
245: lv_rowid cur_rowid%RowType;

Line 368: cursor C is select ROWID from IGS_PE_ALTERNATV_EXT

364: X_EXIT_COURSE_CD in VARCHAR2,
365: X_EXIT_VERSION_SET in VARCHAR2,
366: X_MODE in VARCHAR2 default 'R'
367: ) as
368: cursor C is select ROWID from IGS_PE_ALTERNATV_EXT
369: where COURSE_CD = X_COURSE_CD
370: and VERSION_NUMBER = X_VERSION_NUMBER
371: and EXIT_COURSE_CD = X_EXIT_COURSE_CD;
372: X_LAST_UPDATE_DATE DATE;

Line 407: insert into IGS_PE_ALTERNATV_EXT (

403: x_last_update_date=>X_LAST_UPDATE_DATE,
404: x_last_updated_by=>X_LAST_UPDATED_BY,
405: x_last_update_login=>X_LAST_UPDATE_LOGIN
406: );
407: insert into IGS_PE_ALTERNATV_EXT (
408: COURSE_CD,
409: VERSION_NUMBER,
410: EXIT_COURSE_CD,
411: EXIT_VERSION_SET,

Line 452: from IGS_PE_ALTERNATV_EXT

448: X_EXIT_VERSION_SET in VARCHAR2
449: ) as
450: cursor c1 is select
451: EXIT_VERSION_SET
452: from IGS_PE_ALTERNATV_EXT
453: where ROWID = X_ROWID
454: for update nowait;
455: tlinfo c1%rowtype;
456:

Line 524: update IGS_PE_ALTERNATV_EXT set

520: x_last_update_date=>X_LAST_UPDATE_DATE,
521: x_last_updated_by=>X_LAST_UPDATED_BY,
522: x_last_update_login=>X_LAST_UPDATE_LOGIN
523: );
524: update IGS_PE_ALTERNATV_EXT set
525: EXIT_VERSION_SET = NEW_REFERENCES.EXIT_VERSION_SET,
526: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
527: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
528: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 550: cursor c1 is select rowid from IGS_PE_ALTERNATV_EXT

546: X_EXIT_COURSE_CD in VARCHAR2,
547: X_EXIT_VERSION_SET in VARCHAR2,
548: X_MODE in VARCHAR2 default 'R'
549: ) as
550: cursor c1 is select rowid from IGS_PE_ALTERNATV_EXT
551: where COURSE_CD = X_COURSE_CD
552: and VERSION_NUMBER = X_VERSION_NUMBER
553: and EXIT_COURSE_CD = X_EXIT_COURSE_CD
554: ;

Line 589: delete from IGS_PE_ALTERNATV_EXT

585: p_action => 'DELETE',
586: x_rowid => X_ROWID
587: );
588:
589: delete from IGS_PE_ALTERNATV_EXT
590: where ROWID = X_ROWID;
591: if (sql%notfound) then
592: raise no_data_found;
593: end if;

Line 603: end IGS_PE_ALTERNATV_EXT_PKG;

599:
600:
601: end DELETE_ROW;
602:
603: end IGS_PE_ALTERNATV_EXT_PKG;