APPS.IGS_AD_CANCEL_RECONSIDER dependencies on IGS_AD_CANCEL_RECONSIDER

Line 1: PACKAGE BODY igs_ad_cancel_reconsider AS

1: PACKAGE BODY igs_ad_cancel_reconsider AS
2: /* $Header: IGSADC9B.pls 120.14 2006/05/26 07:21:58 pfotedar ship $ */
3:
4: /*=======================================================================+
5: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|

Line 10: | PL/SQL Body for package: IGS_AD_CANCEL_RECONSIDER |

6: | All rights reserved. |
7: +=======================================================================+
8: | |
9: | DESCRIPTION |
10: | PL/SQL Body for package: IGS_AD_CANCEL_RECONSIDER |
11: | |
12: | NOTES : This job will close all applicatoins that are part of a person|
13: | id group, or are in a specified academic admission calendar |
14: | and admission process category with Outcome status 'Rejected' |

Line 726: igs_ad_cancel_reconsider.g_cancel_recons_on := 'Y';

722: FETCH c_get_pending_hist INTO l_get_pending_hist_rec;
723:
724: IF c_get_pending_hist%FOUND THEN
725:
726: igs_ad_cancel_reconsider.g_cancel_recons_on := 'Y';
727:
728: igs_ad_ps_appl_inst_pkg.update_row (
729: X_ROWID => l_get_inst_dtls_rec.ROWID,
730: x_PERSON_ID => l_get_inst_dtls_rec.PERSON_ID,

Line 861: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';

857: x_appl_inst_status => l_get_inst_dtls_rec.appl_inst_status,
858: x_ais_reason => l_get_inst_dtls_rec.ais_reason,
859: x_decline_ofr_reason => l_get_pending_hist_rec.decline_ofr_reason);
860:
861: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';
862:
863: igs_ad_wf_001.wf_raise_event ( p_person_id => l_get_inst_dtls_rec.Person_Id,
864: p_raised_for => 'AOD',
865: p_admission_appl_number => l_get_inst_dtls_rec.Admission_Appl_Number,

Line 926: IF NVL(igs_ad_cancel_reconsider.g_cancel_recons_on,'N') = 'Y' THEN

922:
923: EXCEPTION
924: WHEN OTHERS THEN
925:
926: IF NVL(igs_ad_cancel_reconsider.g_cancel_recons_on,'N') = 'Y' THEN
927: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';
928: END IF;
929:
930: IF c_get_pending_hist%ISOPEN THEN

Line 927: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';

923: EXCEPTION
924: WHEN OTHERS THEN
925:
926: IF NVL(igs_ad_cancel_reconsider.g_cancel_recons_on,'N') = 'Y' THEN
927: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';
928: END IF;
929:
930: IF c_get_pending_hist%ISOPEN THEN
931: CLOSE c_get_pending_hist;

Line 1247: igs_ad_cancel_reconsider.g_cancel_recons_on := 'Y';

1243: FETCH c_get_pending_hist INTO l_get_pending_hist_rec;
1244:
1245: IF c_get_pending_hist%FOUND THEN
1246:
1247: igs_ad_cancel_reconsider.g_cancel_recons_on := 'Y';
1248:
1249: igs_ad_ps_appl_inst_pkg.update_row (
1250: X_ROWID => l_get_inst_dtls_rec.ROWID,
1251: x_PERSON_ID => l_get_inst_dtls_rec.PERSON_ID,

Line 1382: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';

1378: x_appl_inst_status => l_get_inst_dtls_rec.appl_inst_status,
1379: x_ais_reason => l_get_inst_dtls_rec.ais_reason,
1380: x_decline_ofr_reason => l_get_pending_hist_rec.decline_ofr_reason);
1381:
1382: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';
1383:
1384: igs_ad_wf_001.wf_raise_event ( p_person_id => l_get_inst_dtls_rec.Person_Id,
1385: p_raised_for => 'AOD',
1386: p_admission_appl_number => l_get_inst_dtls_rec.Admission_Appl_Number,

Line 1446: IF NVL(igs_ad_cancel_reconsider.g_cancel_recons_on,'N') = 'Y' THEN

1442:
1443: EXCEPTION
1444: WHEN OTHERS THEN
1445:
1446: IF NVL(igs_ad_cancel_reconsider.g_cancel_recons_on,'N') = 'Y' THEN
1447: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';
1448: END IF;
1449:
1450: IF c_get_pending_hist%ISOPEN THEN

Line 1447: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';

1443: EXCEPTION
1444: WHEN OTHERS THEN
1445:
1446: IF NVL(igs_ad_cancel_reconsider.g_cancel_recons_on,'N') = 'Y' THEN
1447: igs_ad_cancel_reconsider.g_cancel_recons_on := 'N';
1448: END IF;
1449:
1450: IF c_get_pending_hist%ISOPEN THEN
1451: CLOSE c_get_pending_hist;

Line 1705: END igs_ad_cancel_reconsider;

1701: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1702: igs_ge_msg_stack.conc_exception_hndl;
1703: END cancel_reconsider_appl;
1704:
1705: END igs_ad_cancel_reconsider;