APPS.IGS_EN_SPA_AWD_AIM_PKG dependencies on IGS_PE_TYP_INSTANCES_PKG

Line 246: igs_pe_typ_instances_pkg.insert_row(

242:
243: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);
244: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
245: IF cur_typ_id_inst%NOTFOUND THEN
246: igs_pe_typ_instances_pkg.insert_row(
247: X_ROWID => l_ROWID,
248: X_PERSON_ID => new_references.PERSON_ID,
249: X_COURSE_CD => new_references.COURSE_CD,
250: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,

Line 276: igs_pe_typ_instances_pkg.update_row(

272: 'GRADUATE');
273: FETCH cur_pe_typ_inst INTO cur_pe_typ_inst_rec;
274: IF cur_pe_typ_inst%FOUND THEN
275: l_date := cur_pe_typ_inst_rec.START_DATE;
276: igs_pe_typ_instances_pkg.update_row(
277: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
278: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
279: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
280: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 316: igs_pe_typ_instances_pkg.update_row(

312: 'FORMER_STUDENT',
313: l_date);
314: FETCH cur_per_typ_dt INTO cur_per_typ_dt_rec;
315: IF cur_per_typ_dt%FOUND THEN
316: igs_pe_typ_instances_pkg.update_row(
317: X_ROWID => cur_per_typ_dt_rec.ROW_ID,
318: X_PERSON_ID => cur_per_typ_dt_rec.PERSON_ID,
319: X_COURSE_CD => cur_per_typ_dt_rec.COURSE_CD,
320: X_TYPE_INSTANCE_ID => cur_per_typ_dt_rec.TYPE_INSTANCE_ID,

Line 343: igs_pe_typ_instances_pkg.update_row(

339: new_references.COURSE_CD,
340: 'FORMER_STUDENT');
341: FETCH cur_pe_typ_inst INTO cur_pe_typ_inst_rec;
342: IF cur_pe_typ_inst%FOUND THEN
343: igs_pe_typ_instances_pkg.update_row(
344: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
345: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
346: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
347: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 391: igs_pe_typ_instances_pkg.update_row(

387: IF SYSDATE < cur_pe_typ_inst_rec.START_DATE THEN
388: l_date := cur_pe_typ_inst_rec.START_DATE;
389: ELSE l_date := SYSDATE;
390: END IF;
391: igs_pe_typ_instances_pkg.update_row(
392: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
393: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
394: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
395: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 428: igs_pe_typ_instances_pkg.insert_row(

424: IF l_date = SYSDATE THEN
425: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);
426: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
427: IF cur_typ_id_inst%NOTFOUND THEN
428: igs_pe_typ_instances_pkg.insert_row(
429: X_ROWID => l_ROWID,
430: X_PERSON_ID => new_references.PERSON_ID,
431: X_COURSE_CD => new_references.COURSE_CD,
432: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,

Line 458: igs_pe_typ_instances_pkg.update_row(

454: 'FORMER_STUDENT',
455: l_date);
456: FETCH cur_per_typ_dt INTO cur_per_typ_dt_rec;
457: IF cur_per_typ_dt%FOUND THEN
458: igs_pe_typ_instances_pkg.update_row(
459: X_ROWID => cur_per_typ_dt_rec.ROW_ID,
460: X_PERSON_ID => cur_per_typ_dt_rec.PERSON_ID,
461: X_COURSE_CD => cur_per_typ_dt_rec.COURSE_CD,
462: X_TYPE_INSTANCE_ID => cur_per_typ_dt_rec.TYPE_INSTANCE_ID,

Line 508: igs_pe_typ_instances_pkg.update_row(

504: IF cur_pe_typ_inst%FOUND THEN
505: IF SYSDATE < cur_pe_typ_inst_rec.START_DATE THEN
506: l_date := cur_pe_typ_inst_rec.START_DATE;
507: END IF;
508: igs_pe_typ_instances_pkg.update_row(
509: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
510: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
511: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
512: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 544: igs_pe_typ_instances_pkg.insert_row(

540: IF l_date = SYSDATE THEN
541: OPEN cur_typ_id_inst(cur_conf_dt_rec.PERSON_ID,cur_conf_dt_rec.COURSE_CD,l_person_type);
542: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
543: IF cur_typ_id_inst%NOTFOUND THEN
544: igs_pe_typ_instances_pkg.insert_row(
545: X_ROWID => l_ROWID,
546: X_PERSON_ID => cur_conf_dt_rec.PERSON_ID,
547: X_COURSE_CD => cur_conf_dt_rec.COURSE_CD,
548: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,

Line 574: igs_pe_typ_instances_pkg.update_row(

570: 'FORMER_STUDENT',
571: l_date);
572: FETCH cur_per_typ_dt INTO cur_per_typ_dt_rec;
573: IF cur_per_typ_dt%FOUND THEN
574: igs_pe_typ_instances_pkg.update_row(
575: X_ROWID => cur_per_typ_dt_rec.ROW_ID,
576: X_PERSON_ID => cur_per_typ_dt_rec.PERSON_ID,
577: X_COURSE_CD => cur_per_typ_dt_rec.COURSE_CD,
578: X_TYPE_INSTANCE_ID => cur_per_typ_dt_rec.TYPE_INSTANCE_ID,