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_RE_THESIS_PKG dependencies on IGS_RE_THESIS

Line 1: PACKAGE BODY IGS_RE_THESIS_PKG AS

1: PACKAGE BODY IGS_RE_THESIS_PKG AS
2: /* $Header: IGSRI15B.pls 120.1 2005/07/04 00:42:16 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 13: old_references IGS_RE_THESIS_ALL%RowType;

9: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_the.genp_val_sdtt_sess
10: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
11: -------------------------------------------------------------------------------------------
12: l_rowid VARCHAR2(25);
13: old_references IGS_RE_THESIS_ALL%RowType;
14: new_references IGS_RE_THESIS_ALL%RowType;
15: PROCEDURE Set_Column_Values (
16: p_action IN VARCHAR2,
17: x_rowid IN VARCHAR2,

Line 14: new_references IGS_RE_THESIS_ALL%RowType;

10: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
11: -------------------------------------------------------------------------------------------
12: l_rowid VARCHAR2(25);
13: old_references IGS_RE_THESIS_ALL%RowType;
14: new_references IGS_RE_THESIS_ALL%RowType;
15: PROCEDURE Set_Column_Values (
16: p_action IN VARCHAR2,
17: x_rowid IN VARCHAR2,
18: x_person_id IN NUMBER,

Line 45: FROM IGS_RE_THESIS_ALL

41: x_org_id IN NUMBER
42: ) AS
43: CURSOR cur_old_ref_values IS
44: SELECT *
45: FROM IGS_RE_THESIS_ALL
46: WHERE rowid = x_rowid;
47: BEGIN
48: l_rowid := x_rowid;
49: -- Code for setting the Old and New Reference Values.

Line 98: v_thesis_status IGS_RE_THESIS_V.thesis_status%TYPE;

94: p_updating IN BOOLEAN,
95: p_deleting IN BOOLEAN
96: ) AS
97: v_message_name VARCHAR2(30);
98: v_thesis_status IGS_RE_THESIS_V.thesis_status%TYPE;
99: BEGIN
100: -- Turn off trigger validation when performing insert of IGS_RE_CANDIDATURE details
101: -- as a result of IGS_PS_COURSE transfer
102: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN

Line 151: -- Validate the IGS_RE_THESIS final title indicator.

147: END IF;
148: END IF;
149: END IF;
150: IF p_updating THEN
151: -- Validate the IGS_RE_THESIS final title indicator.
152: IF old_references.final_title_ind <> new_references.final_title_ind THEN
153: IF IGS_RE_VAL_THE.resp_val_the_fnl( new_references.person_id,
154: new_references.ca_sequence_number,
155: new_references.sequence_number,

Line 164: -- Validate the IGS_RE_THESIS IGS_PE_TITLE

160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: END IF;
164: -- Validate the IGS_RE_THESIS IGS_PE_TITLE
165: IF old_references.title <> new_references.title THEN
166: IF IGS_RE_VAL_THE.resp_val_the_ttl( old_references.title,
167: new_references.title,
168: old_references.thesis_result_cd,

Line 227: -- Validate IGS_RE_THESIS result code

223: END IF;
224: IF p_inserting OR
225: (p_updating AND
226: NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' ')) THEN
227: -- Validate IGS_RE_THESIS result code
228: IF IGS_RE_VAL_THE.resp_val_the_thr( new_references.person_id,
229: new_references.ca_sequence_number,
230: new_references.sequence_number,
231: new_references.thesis_result_cd,

Line 288: l_deleted igs_re_thesis.final_title_ind%TYPE;

284: p_updating IN BOOLEAN,
285: p_deleting IN BOOLEAN
286: ) AS
287:
288: l_deleted igs_re_thesis.final_title_ind%TYPE;
289:
290: BEGIN
291: IF p_updating OR p_deleting THEN
292: IGS_RE_GEN_003.RESP_INS_THE_HIST(old_references.person_id,

Line 449: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (

445: IF (((old_references.thesis_result_cd = new_references.thesis_result_cd)) OR
446: ((new_references.thesis_result_cd IS NULL))) THEN
447: NULL;
448: ELSE
449: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (
450: new_references.thesis_result_cd
451: ) THEN
452: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
453: IGS_GE_MSG_STACK.ADD;

Line 460: IGS_RE_THESIS_EXAM_PKG.GET_FK_IGS_RE_THESIS (

456: END IF;
457: END Check_Parent_Existance;
458: PROCEDURE Check_Child_Existance AS
459: BEGIN
460: IGS_RE_THESIS_EXAM_PKG.GET_FK_IGS_RE_THESIS (
461: old_references.person_id,
462: old_references.ca_sequence_number,
463: old_references.sequence_number
464: );

Line 473: FROM IGS_RE_THESIS_ALL

469: x_sequence_number IN NUMBER
470: ) RETURN BOOLEAN AS
471: CURSOR cur_rowid IS
472: SELECT rowid
473: FROM IGS_RE_THESIS_ALL
474: WHERE person_id = x_person_id
475: AND ca_sequence_number = x_ca_sequence_number
476: AND sequence_number = x_sequence_number
477: FOR UPDATE NOWAIT;

Line 496: FROM IGS_RE_THESIS_ALL

492: x_sequence_number IN NUMBER
493: ) AS
494: CURSOR cur_rowid IS
495: SELECT rowid
496: FROM IGS_RE_THESIS_ALL
497: WHERE person_id = x_person_id
498: AND ca_sequence_number = x_sequence_number ;
499: lv_rowid cur_rowid%RowType;
500: BEGIN

Line 512: PROCEDURE GET_FK_IGS_RE_THESIS_RESULT (

508: Return;
509: END IF;
510: Close cur_rowid;
511: END GET_FK_IGS_RE_CANDIDATURE;
512: PROCEDURE GET_FK_IGS_RE_THESIS_RESULT (
513: x_thesis_result_cd IN VARCHAR2
514: ) AS
515: CURSOR cur_rowid IS
516: SELECT rowid

Line 517: FROM IGS_RE_THESIS_ALL

513: x_thesis_result_cd IN VARCHAR2
514: ) AS
515: CURSOR cur_rowid IS
516: SELECT rowid
517: FROM IGS_RE_THESIS_ALL
518: WHERE thesis_result_cd = x_thesis_result_cd ;
519: lv_rowid cur_rowid%RowType;
520: BEGIN
521: Open cur_rowid;

Line 531: END GET_FK_IGS_RE_THESIS_RESULT;

527: App_Exception.Raise_Exception;
528: Return;
529: END IF;
530: Close cur_rowid;
531: END GET_FK_IGS_RE_THESIS_RESULT;
532: PROCEDURE Before_DML (
533: p_action IN VARCHAR2,
534: x_rowid IN VARCHAR2,
535: x_person_id IN NUMBER,

Line 679: cursor C is select ROWID from IGS_RE_THESIS_ALL

675: X_COMMENTS in VARCHAR2,
676: X_MODE in VARCHAR2 ,
677: X_ORG_ID in NUMBER
678: ) as
679: cursor C is select ROWID from IGS_RE_THESIS_ALL
680: where PERSON_ID = X_PERSON_ID
681: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
682: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
683: X_LAST_UPDATE_DATE DATE;

Line 736: insert into IGS_RE_THESIS_ALL (

732: );
733: IF (x_mode = 'S') THEN
734: igs_sc_gen_001.set_ctx('R');
735: END IF;
736: insert into IGS_RE_THESIS_ALL (
737: PERSON_ID,
738: CA_SEQUENCE_NUMBER,
739: SEQUENCE_NUMBER,
740: TITLE,

Line 856: from IGS_RE_THESIS_ALL

852: EMBARGO_DETAILS,
853: THESIS_TOPIC,
854: CITATION,
855: COMMENTS
856: from IGS_RE_THESIS_ALL
857: where ROWID = X_ROWID
858: for update nowait;
859: tlinfo c1%rowtype;
860: begin

Line 994: update IGS_RE_THESIS_ALL set

990: );
991: IF (x_mode = 'S') THEN
992: igs_sc_gen_001.set_ctx('R');
993: END IF;
994: update IGS_RE_THESIS_ALL set
995: TITLE = NEW_REFERENCES.TITLE,
996: FINAL_TITLE_IND = NEW_REFERENCES.FINAL_TITLE_IND,
997: SHORT_TITLE = NEW_REFERENCES.SHORT_TITLE,
998: ABBREVIATED_TITLE = NEW_REFERENCES.ABBREVIATED_TITLE,

Line 1066: cursor c1 is select rowid from IGS_RE_THESIS_ALL

1062: X_COMMENTS in VARCHAR2,
1063: X_MODE in VARCHAR2 ,
1064: X_ORG_ID in NUMBER
1065: ) as
1066: cursor c1 is select rowid from IGS_RE_THESIS_ALL
1067: where PERSON_ID = X_PERSON_ID
1068: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
1069: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
1070: ;

Line 1135: delete from IGS_RE_THESIS_ALL

1131: );
1132: IF (x_mode = 'S') THEN
1133: igs_sc_gen_001.set_ctx('R');
1134: END IF;
1135: delete from IGS_RE_THESIS_ALL
1136: where ROWID = X_ROWID;
1137: if (sql%notfound) then
1138: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1139: igs_ge_msg_stack.add;

Line 1152: end IGS_RE_THESIS_PKG;

1148: p_action => 'DELETE',
1149: x_rowid => X_ROWID
1150: );
1151: end DELETE_ROW;
1152: end IGS_RE_THESIS_PKG;