APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_PE_TYP_INSTANCES_PKG

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 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,