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_ATT_PKG dependencies on IGS_PE_TYP_INSTANCES

Line 140: -- igs_pe_typ_instances_pkg.insert_row call ( which null and not correct)

136: -- Populate New Values.
137: -- When the update row of the TBH is called the org_id column is not passed as parameter
138: -- and the before_dml procedure accpets the parameter as default hence it comes into this
139: -- procedure as null. The new_references.org_id is passed to the
140: -- igs_pe_typ_instances_pkg.insert_row call ( which null and not correct)
141: -- Hence modified the condition to pick up the old_references.org_id value if the
142: -- action was update and the x_org_id parameter value is null
143: -- amuthu
144: IF p_action = 'UPDATE' AND x_org_id IS NULL THEN

Line 896: FROM igs_pe_typ_instances_all pti

892: */
893: --modified cursor for perf bug 3696781
894: CURSOR cur_typ_id_inst(p_PERSON_ID NUMBER,p_COURSE_CD VARCHAR2,p_PERSON_TYPE_CODE VARCHAR2) IS
895: SELECT pti.*
896: FROM igs_pe_typ_instances_all pti
897: WHERE pti.PERSON_ID = p_PERSON_ID AND
898: pti.COURSE_CD = p_COURSE_CD AND
899: pti.PERSON_TYPE_CODE = p_PERSON_TYPE_CODE AND
900: pti.END_DATE IS NULL;

Line 911: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,

907:
908: -- Cursor used to fetch the Person Type Instance record which is being opened
909: -- irrespective of the system person type is closed or not.
910: -- Cursor is being created for the bug fix: 2389552
911: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS
914: SELECT pti.rowid row_id ,pti.*
915: FROM igs_pe_typ_instances_all pti,

Line 912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,

908: -- Cursor used to fetch the Person Type Instance record which is being opened
909: -- irrespective of the system person type is closed or not.
910: -- Cursor is being created for the bug fix: 2389552
911: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS
914: SELECT pti.rowid row_id ,pti.*
915: FROM igs_pe_typ_instances_all pti,
916: igs_pe_person_types pty

Line 915: FROM igs_pe_typ_instances_all pti,

911: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS
914: SELECT pti.rowid row_id ,pti.*
915: FROM igs_pe_typ_instances_all pti,
916: igs_pe_person_types pty
917: WHERE pti.person_id = p_person_id AND
918: pti.course_cd = p_course_cd AND
919: pti.end_date IS NULL AND

Line 952: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;

948:
949: v_message_name VARCHAR2(30);
950: v_save_row BOOLEAN := FALSE;
951: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
952: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;
953: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;
954: l_rowid VARCHAR2(25);
955: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;
956: cur_typ_id_inst_rec cur_typ_id_inst%ROWTYPE;

Line 955: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;

951: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
952: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;
953: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;
954: l_rowid VARCHAR2(25);
955: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;
956: cur_typ_id_inst_rec cur_typ_id_inst%ROWTYPE;
957: l_cur_find_interm cur_find_interm%ROWTYPE;
958: ln_cur_re_canditure NUMBER;
959:

Line 987: igs_pe_typ_instances_pkg.update_row(

983: 'APPLICANT' );
984: FETCH cur_pe_typ_inst INTO cur_pe_typ_inst_rec;
985: IF cur_pe_typ_inst%FOUND THEN
986:
987: igs_pe_typ_instances_pkg.update_row(
988: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
989: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
990: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
991: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 1024: igs_pe_typ_instances_pkg.insert_row(

1020:
1021: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);
1022: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
1023: IF cur_typ_id_inst%NOTFOUND THEN
1024: igs_pe_typ_instances_pkg.insert_row(
1025: X_ROWID => l_ROWID,
1026: X_PERSON_ID => new_references.PERSON_ID,
1027: X_COURSE_CD => new_references.COURSE_CD,
1028: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,

Line 1082: igs_pe_typ_instances_pkg.update_row(

1078: IF cur_pe_typ_inst%FOUND THEN
1079:
1080: l_method := 'PERSON_ENROLL_PRG';
1081:
1082: igs_pe_typ_instances_pkg.update_row(
1083: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
1084: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
1085: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
1086: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 1118: igs_pe_typ_instances_pkg.insert_row(

1114:
1115: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);
1116: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
1117: IF cur_typ_id_inst%NOTFOUND THEN
1118: igs_pe_typ_instances_pkg.insert_row(
1119: X_ROWID => l_ROWID,
1120: X_PERSON_ID => new_references.PERSON_ID,
1121: X_COURSE_CD => new_references.COURSE_CD,
1122: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,

Line 1173: igs_pe_typ_instances_pkg.update_row(

1169: IF cur_pe_typ_inst%FOUND THEN
1170:
1171: l_method := 'PERSON_NO_ENROLL_PRG';
1172:
1173: igs_pe_typ_instances_pkg.update_row(
1174: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
1175: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
1176: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
1177: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 1209: igs_pe_typ_instances_pkg.insert_row(

1205:
1206: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);
1207: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
1208: IF cur_typ_id_inst%NOTFOUND THEN
1209: igs_pe_typ_instances_pkg.insert_row(
1210: X_ROWID => l_ROWID,
1211: X_PERSON_ID => new_references.PERSON_ID,
1212: X_COURSE_CD => new_references.COURSE_CD,
1213: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,