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_UNIT_SETS_PKG dependencies on IGS_AD_UNIT_SETS

Line 1: PACKAGE BODY igs_ad_unit_sets_pkg AS

1: PACKAGE BODY igs_ad_unit_sets_pkg AS
2: /* $Header: IGSAI98B.pls 120.3 2006/05/30 11:42:19 pbondugu ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_unit_sets%RowType;

Line 5: old_references igs_ad_unit_sets%RowType;

1: PACKAGE BODY igs_ad_unit_sets_pkg AS
2: /* $Header: IGSAI98B.pls 120.3 2006/05/30 11:42:19 pbondugu ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_unit_sets%RowType;
6: new_references igs_ad_unit_sets%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_unit_sets%RowType;

2: /* $Header: IGSAI98B.pls 120.3 2006/05/30 11:42:19 pbondugu ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_unit_sets%RowType;
6: new_references igs_ad_unit_sets%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 39: FROM IGS_AD_UNIT_SETS

35: ***************************************************************/
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGS_AD_UNIT_SETS
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 210: FROM igs_ad_unit_sets

206: ***************************************************************/
207:
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM igs_ad_unit_sets
211: WHERE unit_set_id = x_unit_set_id
212: FOR UPDATE NOWAIT;
213:
214: lv_rowid cur_rowid%RowType;

Line 251: FROM igs_ad_unit_sets

247: ***************************************************************/
248:
249: CURSOR cur_rowid IS
250: SELECT rowid
251: FROM igs_ad_unit_sets
252: WHERE sequence_number = x_sequence_number
253: AND unit_set_cd = x_unit_set_cd
254: AND version_number = x_version_number
255: AND admission_appl_number = x_admission_appl_number

Line 295: FROM igs_ad_unit_sets

291: ***************************************************************/
292:
293: CURSOR cur_rowid IS
294: SELECT rowid
295: FROM igs_ad_unit_sets
296: WHERE person_id = x_person_id
297: AND admission_appl_number = x_admission_appl_number
298: AND nominated_course_cd = x_nominated_course_cd
299: AND sequence_number = x_sequence_number ;

Line 334: FROM igs_ad_unit_sets

330: (reverse chronological order - newest change first)
331: ***************************************************************/
332: CURSOR cur_rowid IS
333: SELECT rowid
334: FROM igs_ad_unit_sets
335: WHERE unit_set_cd = x_unit_set_cd
336: AND version_number = x_version_number ;
337:
338: lv_rowid cur_rowid%RowType;

Line 373: FROM igs_ad_unit_sets aus, igs_ad_appl_all apl, igs_ad_ps_appl_inst_all inst

369: (reverse chronological order - newest change first)
370: ***************************************************************/
371: CURSOR cur_rowid IS
372: SELECT aus.rowid
373: FROM igs_ad_unit_sets aus, igs_ad_appl_all apl, igs_ad_ps_appl_inst_all inst
374: WHERE aus.person_id = apl.person_id
375: AND aus.admission_appl_number = apl.admission_appl_number
376: AND aus.person_id = inst.person_id
377: AND aus.admission_appl_number = inst.admission_appl_number

Line 403: FUNCTION Validate_Unit_Set(p_version_number igs_ad_unit_sets.version_number%TYPE

399:
400: END GET_FK_IGS_PS_OFR_UNIT_SET;
401: -- end oxford unit set code bug 5194658
402:
403: FUNCTION Validate_Unit_Set(p_version_number igs_ad_unit_sets.version_number%TYPE
404: ,p_unit_set_cd igs_ad_unit_sets.unit_set_cd%TYPE
405: ,p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
406: ,p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE
407: ,p_admission_cat igs_ad_appl_all.admission_cat%TYPE

Line 404: ,p_unit_set_cd igs_ad_unit_sets.unit_set_cd%TYPE

400: END GET_FK_IGS_PS_OFR_UNIT_SET;
401: -- end oxford unit set code bug 5194658
402:
403: FUNCTION Validate_Unit_Set(p_version_number igs_ad_unit_sets.version_number%TYPE
404: ,p_unit_set_cd igs_ad_unit_sets.unit_set_cd%TYPE
405: ,p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
406: ,p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE
407: ,p_admission_cat igs_ad_appl_all.admission_cat%TYPE
408: ,p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE

Line 701: cursor C is select ROWID from IGS_AD_UNIT_SETS

697:
698: (reverse chronological order - newest change first)
699: ***************************************************************/
700:
701: cursor C is select ROWID from IGS_AD_UNIT_SETS
702: where UNIT_SET_ID= X_UNIT_SET_ID
703: ;
704: X_LAST_UPDATE_DATE DATE ;
705: X_LAST_UPDATED_BY NUMBER ;

Line 762: insert into IGS_AD_UNIT_SETS (

758: x_last_update_login=>X_LAST_UPDATE_LOGIN);
759: IF (x_mode = 'S') THEN
760: igs_sc_gen_001.set_ctx('R');
761: END IF;
762: insert into IGS_AD_UNIT_SETS (
763: UNIT_SET_ID
764: ,PERSON_ID
765: ,ADMISSION_APPL_NUMBER
766: ,NOMINATED_COURSE_CD

Line 781: IGS_AD_UNIT_SETS_S.NEXTVAL

777: ,PROGRAM_ID
778: ,PROGRAM_APPLICATION_ID
779: ,PROGRAM_UPDATE_DATE
780: ) values (
781: IGS_AD_UNIT_SETS_S.NEXTVAL
782: ,NEW_REFERENCES.PERSON_ID
783: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
784: ,NEW_REFERENCES.NOMINATED_COURSE_CD
785: ,NEW_REFERENCES.SEQUENCE_NUMBER

Line 861: from IGS_AD_UNIT_SETS

857: , SEQUENCE_NUMBER
858: , UNIT_SET_CD
859: , VERSION_NUMBER
860: , RANK
861: from IGS_AD_UNIT_SETS
862: where ROWID = X_ROWID
863: for update nowait;
864: tlinfo c1%rowtype;
865: begin

Line 976: update IGS_AD_UNIT_SETS set

972:
973: IF (x_mode = 'S') THEN
974: igs_sc_gen_001.set_ctx('R');
975: END IF;
976: update IGS_AD_UNIT_SETS set
977: PERSON_ID = NEW_REFERENCES.PERSON_ID,
978: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
979: NOMINATED_COURSE_CD = NEW_REFERENCES.NOMINATED_COURSE_CD,
980: SEQUENCE_NUMBER = NEW_REFERENCES.SEQUENCE_NUMBER,

Line 1051: cursor c1 is select ROWID from IGS_AD_UNIT_SETS

1047:
1048: (reverse chronological order - newest change first)
1049: ***************************************************************/
1050:
1051: cursor c1 is select ROWID from IGS_AD_UNIT_SETS
1052: where UNIT_SET_ID= X_UNIT_SET_ID
1053: ;
1054: begin
1055: open c1;

Line 1109: delete from IGS_AD_UNIT_SETS

1105: );
1106: IF (x_mode = 'S') THEN
1107: igs_sc_gen_001.set_ctx('R');
1108: END IF;
1109: delete from IGS_AD_UNIT_SETS
1110: where ROWID = X_ROWID;
1111: if (sql%notfound) then
1112: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1113: igs_ge_msg_stack.add;

Line 1147: END igs_ad_unit_sets_pkg;

1143: RAISE;
1144: END IF;
1145: end DELETE_ROW;
1146:
1147: END igs_ad_unit_sets_pkg;