APPS.IGS_PS_PURGE_DEL_RECORD dependencies on IGS_PS_OFR_OPT_ALL

Line 5: PROCEDURE purge_igs_ps_ofr_opt_all AS

1: PACKAGE BODY igs_ps_purge_del_record AS
2: /* $Header: IGSPS88B.pls 120.1 2005/06/29 05:12:28 appldev ship $ */
3:
4:
5: PROCEDURE purge_igs_ps_ofr_opt_all AS
6: /***********************************************************************************************
7:
8: Created By : Shtatiko
9: Date Created By: 19-FEB-2003

Line 10: Purpose : To purge logically deleted records from the table IGS_PS_OFR_OPT_ALL.

6: /***********************************************************************************************
7:
8: Created By : Shtatiko
9: Date Created By: 19-FEB-2003
10: Purpose : To purge logically deleted records from the table IGS_PS_OFR_OPT_ALL.
11: If any child record exists for a logically deleted record then that
12: record will be updated such that it becomes active else it will be deleted.
13:
14: Known limitations,enhancements,remarks:

Line 20: FROM igs_ps_ofr_opt_all a

16: Who When What
17: ********************************************************************************************** */
18: CURSOR c_del_recs IS
19: SELECT rowid, a.*
20: FROM igs_ps_ofr_opt_all a
21: WHERE delete_flag = 'Y';
22:
23: rec_del_recs c_del_recs%ROWTYPE;
24:

Line 31: SAVEPOINT igs_ps_ofr_opt_all ;

27: l_n_rec_count NUMBER(10);
28:
29: BEGIN
30: -- Create a Savepoint for Rollback
31: SAVEPOINT igs_ps_ofr_opt_all ;
32:
33: fnd_file.put_line ( fnd_file.LOG, ' ' );
34: fnd_message.set_name ( 'IGS', 'IGS_PS_OFR_OPT_PURGE' );
35: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

Line 183: ROLLBACK TO igs_ps_ofr_opt_all;

179:
180: EXCEPTION /* This exception handling is at table level */
181: WHEN OTHERS THEN
182: -- If any exception occurs, whole transaction should be rolled off.
183: ROLLBACK TO igs_ps_ofr_opt_all;
184:
185: -- We have to log message stacked by TBH, if any. Otherwise, we will log the generic unhandled exception.
186: l_c_message := fnd_message.get ;
187: IF ( l_c_message IS NOT NULL ) THEN

Line 191: fnd_message.set_token ( 'NAME', 'purge_igs_ps_ofr_opt_all' );

187: IF ( l_c_message IS NOT NULL ) THEN
188: fnd_file.put_line ( fnd_file.LOG, l_c_message );
189: ELSE
190: fnd_message.set_name ( 'IGS', 'IGS_GE_UNHANDLED_EXP' );
191: fnd_message.set_token ( 'NAME', 'purge_igs_ps_ofr_opt_all' );
192: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );
193: END IF;
194:
195: END purge_igs_ps_ofr_opt_all; /* End Of Processing IGS_PS_OFR_OPT_ALL records */

Line 195: END purge_igs_ps_ofr_opt_all; /* End Of Processing IGS_PS_OFR_OPT_ALL records */

191: fnd_message.set_token ( 'NAME', 'purge_igs_ps_ofr_opt_all' );
192: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );
193: END IF;
194:
195: END purge_igs_ps_ofr_opt_all; /* End Of Processing IGS_PS_OFR_OPT_ALL records */
196:
197:
198:
199: PROCEDURE purge_igs_ps_unit_ofr_pat_all AS

Line 357: purging/activating logically deleted records for IGS_PS_OFR_OPT_ALL table.

353: functionality is being used. If any child record exists for a logically deleted
354: record then that record will be updated such that it becomes active.
355: This package is specific for Program Structure and Planning module only i.e.,
356: this will process only tables of PSP module. The process will currently be
357: purging/activating logically deleted records for IGS_PS_OFR_OPT_ALL table.
358:
359: Known limitations,enhancements,remarks:
360: Change History
361: Who When What

Line 374: -- Begin Processing Records of IGS_PS_OFR_OPT_ALL table.

370: -- should be treated as one transaction. So exceptions raised in processing of one table
371: -- should not affect the processing of another table. So COMMIT, and ROLLBACK are at table level
372: -- instead of at the module level.
373:
374: -- Begin Processing Records of IGS_PS_OFR_OPT_ALL table.
375: purge_igs_ps_ofr_opt_all;
376:
377:
378: -- Begin Processing Records of IGS_PS_UNIT_OFR_PAT_ALL table.

Line 375: purge_igs_ps_ofr_opt_all;

371: -- should not affect the processing of another table. So COMMIT, and ROLLBACK are at table level
372: -- instead of at the module level.
373:
374: -- Begin Processing Records of IGS_PS_OFR_OPT_ALL table.
375: purge_igs_ps_ofr_opt_all;
376:
377:
378: -- Begin Processing Records of IGS_PS_UNIT_OFR_PAT_ALL table.
379: purge_igs_ps_unit_ofr_pat_all;