DBA Data[Home] [Help]

APPS.IGS_PS_PURGE_DEL_RECORD dependencies on IGS_PS_UNIT_OFR_PAT_PKG

Line 245: igs_ps_unit_ofr_pat_pkg.before_dml(

241: l_b_purged := TRUE;
242: l_n_rec_count := l_n_rec_count + 1;
243: BEGIN
244: -- Call before_dml of the TBH to know whether the record can physically be deleted or not.
245: igs_ps_unit_ofr_pat_pkg.before_dml(
246: p_action => 'VALIDATE_DELETE' ,
247: x_rowid => rec_del_recs.rowid,
248: x_unit_cd => rec_del_recs.unit_cd,
249: x_version_number => rec_del_recs.version_number,

Line 277: igs_ps_unit_ofr_pat_pkg.update_row (

273: -- Ignore the message stacked by TBH so delete the message from the stack.
274: IGS_GE_MSG_STACK.DELETE_MSG ;
275:
276: -- Update the delete_flag to 'N'
277: igs_ps_unit_ofr_pat_pkg.update_row (
278: x_rowid => rec_del_recs.rowid ,
279: x_unit_cd => rec_del_recs.unit_cd,
280: x_version_number => rec_del_recs.version_number,
281: x_ci_sequence_number => rec_del_recs.ci_sequence_number,

Line 293: igs_ps_unit_ofr_pat_pkg.delete_row ( x_rowid => rec_del_recs.rowid );

289: );
290: END;
291:
292: IF l_b_purged THEN
293: igs_ps_unit_ofr_pat_pkg.delete_row ( x_rowid => rec_del_recs.rowid );
294: END IF;
295:
296: -- Log the details of record and status of purging.
297: fnd_file.put_line ( fnd_file.LOG, ' ');