eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_UC_OLD_OUSTAT

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 168: FROM igs_uc_old_oustat uoc

164: -- Cursor to fetch the previous Outcome Status details captured for the current Application Choice
165: CURSOR cur_prev_ou_captured( p_app_no IGS_UC_APP_CHOICES.APP_NO%TYPE,
166: p_choice_no IGS_UC_APP_CHOICES.CHOICE_NO%TYPE ) IS
167: SELECT uoc.*, uoc.ROWID
168: FROM igs_uc_old_oustat uoc
169: WHERE uoc.app_no = p_app_no
170: AND uoc.choice_no = p_choice_no;
171: cur_prev_ou_captured_rec cur_prev_ou_captured%ROWTYPE;
172:

Line 606: -- in IGS_UC_OLD_OUSTAT Table

602: l_latest_trans_decision := cur_latest_trans_rec.decision;
603: END IF;
604:
605: -- Check whether the previous Outcome details are captured for the current Application Instance or not
606: -- in IGS_UC_OLD_OUSTAT Table
607: OPEN cur_prev_ou_captured( cur_ucas_app_choice_rec.app_no,
608: cur_ucas_app_choice_rec.choice_no );
609: FETCH cur_prev_ou_captured INTO cur_prev_ou_captured_rec;
610:

Line 614: in IGS_UC_OLD_OUSTAT Table, then import the application choice decision */

610:
611:
612: /*** Logic for: Previous Outcome details are captured
613: That is if the previous Outcome details are captured for the current Application Instance
614: in IGS_UC_OLD_OUSTAT Table, then import the application choice decision */
615: IF cur_prev_ou_captured%FOUND THEN
616:
617: -- If Previous Outcome details are captured and there is no trasaction decision found,
618: -- the raise the error with error Code to 'D005'

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 626: -- 4. Delete the corresponding record from IGS_UC_OLD_OUSTAT table for current Application and Choice

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:
630: -- Write the error message to the Log file indicating the error occurred

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 669: -- 4. Delete the corresponding record from IGS_UC_OLD_OUSTAT table for current Application and Choice

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:
673: ELSE /* Previous Captured Outcome status is not 'PENDING' */

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 687: IGS_UC_OLD_OUSTAT table and Application Instance information from CUR_OSS_APPL_INST_REC

683: If the UCAS Transaction Decision maps to the captured OSS user outcome Status or
684: the latest transaction setting decision is an RD or an RA transaction and
685: the decision in the transaction maps to the captured OSS outcome status,
686: then Populate the Decision_maker, decision_reason and Decision Date details from
687: IGS_UC_OLD_OUSTAT table and Application Instance information from CUR_OSS_APPL_INST_REC
688: Else,Populate the Decision_maker, decision_reason,Decision_date details from UCAS Setup
689: and Application Instance information CUR_OSS_APPL_INST_REC.
690:
691: The offer_dt should be set to the decision date from the igs_uc_app_choices for the choice being

Line 767: -- 4. Delete the corresponding record from IGS_UC_OLD_OUSTAT table for current Application and Choice Number.

763: -- Assign DP' to local variable,l_export_to_oss_status and update the Application Choice Record at the end
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' */

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: