APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_UC_OLD_OUSTAT_PKG

Line 19: smaddali 19-oct-2002 added igs_uc_old_oustat_pkg.delete_row call whenever

15: Nishikant 01-OCT-2002 A new column extra_round_nbr added in the TBH calls of
16: the package IGS_UC_APP_CHOICES_PKG.
17: ayedubat 20-OCT-2002 Added a Logic to check whether the decision is required to export or not
18: for the bug fix: 2628041
19: smaddali 19-oct-2002 added igs_uc_old_oustat_pkg.delete_row call whenever
20: export_to_oss_status is being set to "DC" and captured record is found ,for bug 2630219
21: ayedubat 13-DEC-2002 Changed the where clause cursor,cur_oss_appl_inst to replace the local
22: variables used to compare the academic and admissions calendars for bug:2708981
23: ayedubat 26-MAR-2003 Changed the procedure to create a new cursor,c_ch_system which is used to

Line 625: -- smaddali added igs_uc_old_oustat_pkg.delete_row call for bug 2630219

621: -- Update the Appchoice record with export_to_oss_status as 'DC'
622: l_export_to_oss_status := 'DC' ;
623: l_app_choice_error_code := NULL ;
624: l_ch_batch_id := NULL ;
625: -- smaddali added igs_uc_old_oustat_pkg.delete_row call for bug 2630219
626: -- 4. Delete the corresponding record from IGS_UC_OLD_OUSTAT table for current Application and Choice
627: igs_uc_old_oustat_pkg.delete_row(
628: X_ROWID => cur_prev_ou_captured_rec.ROWID ) ;
629:

Line 627: igs_uc_old_oustat_pkg.delete_row(

623: l_app_choice_error_code := NULL ;
624: l_ch_batch_id := NULL ;
625: -- smaddali added igs_uc_old_oustat_pkg.delete_row call for bug 2630219
626: -- 4. Delete the corresponding record from IGS_UC_OLD_OUSTAT table for current Application and Choice
627: igs_uc_old_oustat_pkg.delete_row(
628: X_ROWID => cur_prev_ou_captured_rec.ROWID ) ;
629:
630: -- Write the error message to the Log file indicating the error occurred
631: fnd_message.set_name('IGS','IGS_UC_TRAN_NOT_FOUND');

Line 668: -- smaddali added igs_uc_old_oustat_pkg.delete_row call for bug 2630219

664: l_export_to_oss_status := 'DC' ;
665: l_app_choice_error_code := NULL ;
666: l_ch_batch_id := NULL ;
667:
668: -- smaddali added igs_uc_old_oustat_pkg.delete_row call for bug 2630219
669: -- 4. Delete the corresponding record from IGS_UC_OLD_OUSTAT table for current Application and Choice
670: igs_uc_old_oustat_pkg.delete_row(
671: x_rowid => cur_prev_ou_captured_rec.ROWID ) ;
672:

Line 670: igs_uc_old_oustat_pkg.delete_row(

666: l_ch_batch_id := NULL ;
667:
668: -- smaddali added igs_uc_old_oustat_pkg.delete_row call for bug 2630219
669: -- 4. Delete the corresponding record from IGS_UC_OLD_OUSTAT table for current Application and Choice
670: igs_uc_old_oustat_pkg.delete_row(
671: x_rowid => cur_prev_ou_captured_rec.ROWID ) ;
672:
673: ELSE /* Previous Captured Outcome status is not 'PENDING' */
674:

Line 768: igs_uc_old_oustat_pkg.delete_row(

764: l_export_to_oss_status := 'DP';
765: l_app_choice_error_code := NULL ;
766: l_ch_batch_id := NULL ;
767: -- 4. Delete the corresponding record from IGS_UC_OLD_OUSTAT table for current Application and Choice Number.
768: igs_uc_old_oustat_pkg.delete_row(
769: x_rowid => cur_prev_ou_captured_rec.ROWID ) ;
770:
771: END IF; /* End of checking the outcome status as 'PENDING' */
772: