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_AD_APPL_NOTES_PKG dependencies on IGS_AD_APPL_NOTES

Line 1: PACKAGE BODY igs_ad_appl_notes_pkg AS

1: PACKAGE BODY igs_ad_appl_notes_pkg AS
2: /* $Header: IGSAIA6B.pls 120.2 2005/09/21 00:48:43 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_notes%RowType;
5: new_references igs_ad_appl_notes%RowType;

Line 4: old_references igs_ad_appl_notes%RowType;

1: PACKAGE BODY igs_ad_appl_notes_pkg AS
2: /* $Header: IGSAIA6B.pls 120.2 2005/09/21 00:48:43 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_notes%RowType;
5: new_references igs_ad_appl_notes%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_appl_notes%RowType;

1: PACKAGE BODY igs_ad_appl_notes_pkg AS
2: /* $Header: IGSAIA6B.pls 120.2 2005/09/21 00:48:43 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_appl_notes%RowType;
5: new_references igs_ad_appl_notes%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 37: FROM IGS_AD_APPL_NOTES

33: ***************************************************************/
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_AD_APPL_NOTES
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 197: FROM igs_ad_appl_notes

193: ***************************************************************/
194:
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM igs_ad_appl_notes
198: WHERE appl_notes_id = x_appl_notes_id
199: FOR UPDATE NOWAIT;
200:
201: lv_rowid cur_rowid%RowType;

Line 237: FROM igs_ad_appl_notes

233: ***************************************************************/
234:
235: CURSOR cur_rowid IS
236: SELECT rowid
237: FROM igs_ad_appl_notes
238: WHERE admission_appl_number = x_admission_appl_number
239: AND nominated_course_cd = x_nominated_course_cd
240: AND note_type_id = x_note_type_id
241: AND person_id = x_person_id

Line 279: FROM igs_ad_appl_notes

275: ***************************************************************/
276:
277: CURSOR cur_rowid IS
278: SELECT rowid
279: FROM igs_ad_appl_notes
280: WHERE person_id = x_person_id
281: AND admission_appl_number = x_admission_appl_number
282: AND nominated_course_cd = x_nominated_course_cd
283: AND sequence_number = x_sequence_number ;

Line 318: FROM igs_ad_appl_notes

314: ***************************************************************/
315:
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM igs_ad_appl_notes
319: WHERE note_type_id = x_notes_type_id ;
320:
321: lv_rowid cur_rowid%RowType;
322:

Line 490: WHERE REFERENCE_NUMBER = (SELECT ref_notes_id FROM igs_ad_appl_notes WHERE rowid = x_rowid);

486:
487: CURSOR C_NOTE IS
488: SELECT ROWID
489: FROM IGS_GE_NOTE
490: WHERE REFERENCE_NUMBER = (SELECT ref_notes_id FROM igs_ad_appl_notes WHERE rowid = x_rowid);
491:
492: BEGIN
493:
494: l_rowid := x_rowid;

Line 537: cursor C is select ROWID from IGS_AD_APPL_NOTES

533:
534: (reverse chronological order - newest change first)
535: ***************************************************************/
536:
537: cursor C is select ROWID from IGS_AD_APPL_NOTES
538: where APPL_NOTES_ID= X_APPL_NOTES_ID
539: ;
540: X_LAST_UPDATE_DATE DATE ;
541: X_LAST_UPDATED_BY NUMBER ;

Line 600: INSERT INTO IGS_AD_APPL_NOTES (

596: x_last_update_login=>X_LAST_UPDATE_LOGIN);
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.set_ctx('R');
599: END IF;
600: INSERT INTO IGS_AD_APPL_NOTES (
601: APPL_NOTES_ID
602: ,PERSON_ID
603: ,ADMISSION_APPL_NUMBER
604: ,NOMINATED_COURSE_CD

Line 618: IGS_AD_APPL_NOTES_S.NEXTVAL

614: ,PROGRAM_ID
615: ,PROGRAM_APPLICATION_ID
616: ,PROGRAM_UPDATE_DATE
617: ) values (
618: IGS_AD_APPL_NOTES_S.NEXTVAL
619: ,NEW_REFERENCES.PERSON_ID
620: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
621: ,NEW_REFERENCES.NOMINATED_COURSE_CD
622: ,NEW_REFERENCES.SEQUENCE_NUMBER

Line 695: from IGS_AD_APPL_NOTES

691: , NOMINATED_COURSE_CD
692: , SEQUENCE_NUMBER
693: , NOTE_TYPE_ID
694: , REF_NOTES_ID
695: from IGS_AD_APPL_NOTES
696: where ROWID = X_ROWID
697: for update nowait;
698: tlinfo c1%rowtype;
699: begin

Line 809: update IGS_AD_APPL_NOTES set

805:
806: IF (x_mode = 'S') THEN
807: igs_sc_gen_001.set_ctx('R');
808: END IF;
809: update IGS_AD_APPL_NOTES set
810: PERSON_ID = NEW_REFERENCES.PERSON_ID,
811: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
812: NOMINATED_COURSE_CD = NEW_REFERENCES.NOMINATED_COURSE_CD,
813: SEQUENCE_NUMBER = NEW_REFERENCES.SEQUENCE_NUMBER,

Line 882: cursor c1 is select ROWID from IGS_AD_APPL_NOTES

878:
879: (reverse chronological order - newest change first)
880: ***************************************************************/
881:
882: cursor c1 is select ROWID from IGS_AD_APPL_NOTES
883: where APPL_NOTES_ID= X_APPL_NOTES_ID
884: ;
885: l_mode VARCHAR2(1);
886: begin

Line 940: DELETE FROM IGS_AD_APPL_NOTES

936: );
937: IF (x_mode = 'S') THEN
938: igs_sc_gen_001.set_ctx('R');
939: END IF;
940: DELETE FROM IGS_AD_APPL_NOTES
941: WHERE ROWID = X_ROWID;
942: IF (sql%notfound) THEN
943: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
944: igs_ge_msg_stack.add;

Line 976: END igs_ad_appl_notes_pkg;

972: RAISE;
973: END IF;
974: end DELETE_ROW;
975:
976: END igs_ad_appl_notes_pkg;