APPS.IGS_PS_PURGE_DEL_RECORD dependencies on IGS_PS_OFR_OPT_PKG

Line 43: igs_ps_ofr_opt_pkg.before_dml (

39: l_b_purged := TRUE;
40: l_n_rec_count := l_n_rec_count + 1;
41: BEGIN
42: -- Call before_dml of the TBH to know whether the record can physically be deleted or not.
43: igs_ps_ofr_opt_pkg.before_dml (
44: p_action => 'VALIDATE_DELETE' ,
45: x_rowid => rec_del_recs.rowid ,
46: x_course_cd => rec_del_recs.course_cd ,
47: x_version_number => rec_del_recs.version_number ,

Line 100: igs_ps_ofr_opt_pkg.update_row (

96: -- Ignore the message stacked by TBH so delete the message from the stack.
97: IGS_GE_MSG_STACK.DELETE_MSG ;
98:
99: -- Update the delete_flag to 'N'
100: igs_ps_ofr_opt_pkg.update_row (
101: x_rowid => rec_del_recs.rowid ,
102: x_course_cd => rec_del_recs.course_cd ,
103: x_version_number => rec_del_recs.version_number ,
104: x_cal_type => rec_del_recs.cal_type ,

Line 142: igs_ps_ofr_opt_pkg.delete_row ( x_rowid => rec_del_recs.rowid );

138: );
139: END;
140:
141: IF l_b_purged THEN
142: igs_ps_ofr_opt_pkg.delete_row ( x_rowid => rec_del_recs.rowid );
143: END IF;
144:
145: -- Log the details of record and status of purging.
146: fnd_file.put_line ( fnd_file.LOG, ' ');