[Home] [Help]
1: PACKAGE BODY igs_pe_typ_instances_pkg AS
2: /* $Header: IGSNI46B.pls 120.12 2006/07/12 12:17:22 vskumar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_typ_instances_all%RowType;
5: new_references igs_pe_typ_instances_all%RowType;
273:
274: IF l_system_type = 'STUDENT' then
275: for c_appl_rec in c_get_applicant('APPLICANT',new_references.person_id,new_references.course_cd)loop
276: l_flag := 'TRUE' ;
277: igs_pe_typ_instances_pkg.update_row(
278: X_ROWID => c_appl_rec.rowid,
279: X_PERSON_ID => c_appl_rec.PERSON_ID,
280: X_COURSE_CD => c_appl_rec.COURSE_CD,
281: X_TYPE_INSTANCE_ID => c_appl_rec.TYPE_INSTANCE_ID,
1034: AND pti.person_type_code IN
1035: (select person_type_code from igs_pe_person_types pt where system_type =cp_system_type) ;
1036: l_max_active_date DATE;
1037: l_person_end_date_other DATE;
1038: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_pe_typ_instances_pkg.after_dml';
1039: l_label VARCHAR2(500);
1040: l_debug_str VARCHAR2(3200);
1041: l_old_end_date DATE;
1042: l_default_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
1053: l_person_end_date_other:= new_references.end_date; -- 4612440,4612692
1054: l_old_end_date := old_references.end_date;
1055:
1056: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1057: l_label := 'igs.plsql.igs_pe_typ_instances_pkg.after_dml.'||p_action;
1058: l_debug_str := 'Person Type Code : '||l_person_type_w_other ||'/'|| ' Person id : ' ||l_person_id_w_other || ' End Date ' ||'/' ||l_person_end_date_other;
1059: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1060: END IF;
1061:
1665: p_action => 'DELETE',
1666: x_rowid => X_ROWID
1667: );
1668: end DELETE_ROW;
1669: END igs_pe_typ_instances_pkg;