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_EN_STDNT_PS_INTM_PKG dependencies on IGS_EN_STDNT_PS_INTM

Line 1: package body IGS_EN_STDNT_PS_INTM_PKG AS

1: package body IGS_EN_STDNT_PS_INTM_PKG AS
2: /* $Header: IGSEI18B.pls 120.4 2006/04/16 23:49:10 smaddali ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_STDNT_PS_INTM%RowType;
5: new_references IGS_EN_STDNT_PS_INTM%RowType;

Line 4: old_references IGS_EN_STDNT_PS_INTM%RowType;

1: package body IGS_EN_STDNT_PS_INTM_PKG AS
2: /* $Header: IGSEI18B.pls 120.4 2006/04/16 23:49:10 smaddali ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_STDNT_PS_INTM%RowType;
5: new_references IGS_EN_STDNT_PS_INTM%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_EN_STDNT_PS_INTM%RowType;

1: package body IGS_EN_STDNT_PS_INTM_PKG AS
2: /* $Header: IGSEI18B.pls 120.4 2006/04/16 23:49:10 smaddali ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_STDNT_PS_INTM%RowType;
5: new_references IGS_EN_STDNT_PS_INTM%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 55: FROM IGS_EN_STDNT_PS_INTM

51: ) AS
52:
53: CURSOR cur_old_ref_values IS
54: SELECT *
55: FROM IGS_EN_STDNT_PS_INTM
56: WHERE rowid = x_rowid;
57:
58: BEGIN
59:

Line 128: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_EN_STDNT_PS_INTM

124: END Set_Column_Values;
125:
126: -- Trigger description :-
127: -- TRG_SCI_BR_IUD
128: -- BEFORE INSERT OR UPDATE OR DELETE ON IGS_EN_STDNT_PS_INTM
129: -- REFERENCING
130: -- NEW AS NEW
131: -- OLD AS OLD
132: -- FOR EACH ROW

Line 142: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_INTM') THEN

138: ) AS
139: v_message_name varchar2(30);
140: BEGIN
141: -- If trigger has not been disabled, perform required processing
142: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_INTM') THEN
143: IF p_inserting OR p_updating THEN
144: -- Validate that the IGS_PS_COURSE attempt status allows p_inserting/p_updating of
145: -- intermission details.
146: IF IGS_EN_VAL_SCI.enrp_val_sci_alwd (

Line 171: -- ON IGS_EN_STDNT_PS_INTM

167:
168: -- Trigger description :-
169: -- "OSS_TST".trg_sci_ar_iud
170: -- AFTER INSERT OR DELETE OR UPDATE
171: -- ON IGS_EN_STDNT_PS_INTM
172: -- FOR EACH ROW
173:
174: PROCEDURE AfterRowInsertUpdateDelete2(
175: p_inserting IN BOOLEAN ,

Line 183: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_INTM') THEN

179: v_message_name varchar2(30);
180: --v_rowid_saved BOOLEAN := FALSE;
181: BEGIN
182: -- If trigger has not been disabled, perform required processing
183: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_INTM') THEN
184: -- Validate for date overlaps.
185: IF p_inserting OR (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
186: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
187:

Line 417: FROM IGS_EN_STDNT_PS_INTM

413: )RETURN BOOLEAN AS
414:
415: CURSOR cur_rowid IS
416: SELECT rowid
417: FROM IGS_EN_STDNT_PS_INTM
418: WHERE person_id = x_person_id
419: AND course_cd = x_course_cd
420: AND start_dt = x_start_dt
421: AND logical_delete_date = x_logical_delete_date

Line 448: FROM IGS_EN_STDNT_PS_INTM

444: ) AS
445:
446: CURSOR cur_rowid IS
447: SELECT rowid
448: FROM IGS_EN_STDNT_PS_INTM
449: WHERE person_id = x_person_id
450: AND course_cd = x_course_cd ;
451:
452: lv_rowid cur_rowid%RowType;

Line 479: IGS_EN_SPI_RCONDS_PKG.get_fk_igs_en_stdnt_ps_intm(

475: || Who When What
476: || (reverse chronological order - newest change first)
477: */
478: BEGIN
479: IGS_EN_SPI_RCONDS_PKG.get_fk_igs_en_stdnt_ps_intm(
480: old_references.person_id,
481: old_references.course_cd,
482: old_references.start_dt,
483: old_references.logical_delete_date

Line 717: cursor C is select ROWID from IGS_EN_STDNT_PS_INTM

713: X_ATTRIBUTE19 IN VARCHAR2 ,
714: X_ATTRIBUTE20 IN VARCHAR2 ,
715: x_COND_RETURN_FLAG IN VARCHAR2
716: ) AS
717: cursor C is select ROWID from IGS_EN_STDNT_PS_INTM
718: where PERSON_ID = X_PERSON_ID
719: and COURSE_CD = X_COURSE_CD
720: and START_DT = X_START_DT
721: and LOGICAL_DELETE_DATE = X_LOGICAL_DELETE_DATE;

Line 794: insert into IGS_EN_STDNT_PS_INTM (

790:
791: IF (x_mode = 'S') THEN
792: igs_sc_gen_001.set_ctx('R');
793: END IF;
794: insert into IGS_EN_STDNT_PS_INTM (
795: PERSON_ID,
796: COURSE_CD,
797: START_DT,
798: LOGICAL_DELETE_DATE,

Line 985: from IGS_EN_STDNT_PS_INTM

981: ATTRIBUTE18,
982: ATTRIBUTE19,
983: ATTRIBUTE20,
984: COND_RETURN_FLAG
985: from IGS_EN_STDNT_PS_INTM
986: where ROWID = X_ROWID
987: for update nowait;
988: tlinfo c1%rowtype;
989:

Line 1215: update IGS_EN_STDNT_PS_INTM set

1211:
1212: IF (x_mode = 'S') THEN
1213: igs_sc_gen_001.set_ctx('R');
1214: END IF;
1215: update IGS_EN_STDNT_PS_INTM set
1216: LOGICAL_DELETE_DATE = NEW_REFERENCES.LOGICAL_DELETE_DATE,
1217: END_DT = NEW_REFERENCES.END_DT,
1218: VOLUNTARY_IND = NEW_REFERENCES.VOLUNTARY_IND,
1219: COMMENTS = NEW_REFERENCES.COMMENTS,

Line 1325: cursor c1 is select rowid from IGS_EN_STDNT_PS_INTM

1321: X_ATTRIBUTE19 IN VARCHAR2 ,
1322: X_ATTRIBUTE20 IN VARCHAR2 ,
1323: X_COND_RETURN_FLAG IN VARCHAR2
1324: ) AS
1325: cursor c1 is select rowid from IGS_EN_STDNT_PS_INTM
1326: where PERSON_ID = X_PERSON_ID
1327: and COURSE_CD = X_COURSE_CD
1328: and START_DT = X_START_DT
1329: and LOGICAL_DELETE_DATE = X_LOGICAL_DELETE_DATE

Line 1436: delete from IGS_EN_STDNT_PS_INTM

1432:
1433: IF (x_mode = 'S') THEN
1434: igs_sc_gen_001.set_ctx('R');
1435: END IF;
1436: delete from IGS_EN_STDNT_PS_INTM
1437: where ROWID = X_ROWID;
1438: if (sql%notfound) then
1439: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1440: igs_ge_msg_stack.add;

Line 1458: end IGS_EN_STDNT_PS_INTM_PKG;

1454:
1455:
1456: end DELETE_ROW;
1457:
1458: end IGS_EN_STDNT_PS_INTM_PKG;