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_AD_IMP_ADM_DES dependencies on IGS_AD_PS_APPL_INST

Line 20: | new columns being added to IGS_AD_PS_APPL_INST

16: | HISTORY |
17: | Who When What |
18: | rrengara 2001/08/14 Creation of this code |
19: | cdcruz 18-feb-2002 Bug 2217104 Admit to future term Enhancement,updated tbh call for
20: | new columns being added to IGS_AD_PS_APPL_INST
21: |
22: | kamohan 09-SEP-2002 Bug 2536463 Modified the package to accomodate the detailed |
23: | error codes for the outcome status validation failure |
24: | nshee 29-Aug-2002 Bug 2395510 added 6 columns as part of deferments build |

Line 70: p_decision_make_id OUT NOCOPY igs_ad_ps_appl_inst.decision_make_id%TYPE,

66: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
67: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
68: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
69: p_s_adm_outcome_status IN igs_ad_ou_Stat.s_adm_outcome_status%TYPE,
70: p_decision_make_id OUT NOCOPY igs_ad_ps_appl_inst.decision_make_id%TYPE,
71: p_decision_date OUT NOCOPY igs_ad_ps_appl_inst.decision_date%TYPE,
72: p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,
73: p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,
74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,

Line 71: p_decision_date OUT NOCOPY igs_ad_ps_appl_inst.decision_date%TYPE,

67: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
68: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
69: p_s_adm_outcome_status IN igs_ad_ou_Stat.s_adm_outcome_status%TYPE,
70: p_decision_make_id OUT NOCOPY igs_ad_ps_appl_inst.decision_make_id%TYPE,
71: p_decision_date OUT NOCOPY igs_ad_ps_appl_inst.decision_date%TYPE,
72: p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,
73: p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,
74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,
75: p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,

Line 72: p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,

68: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
69: p_s_adm_outcome_status IN igs_ad_ou_Stat.s_adm_outcome_status%TYPE,
70: p_decision_make_id OUT NOCOPY igs_ad_ps_appl_inst.decision_make_id%TYPE,
71: p_decision_date OUT NOCOPY igs_ad_ps_appl_inst.decision_date%TYPE,
72: p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,
73: p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,
74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,
75: p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,
76: p_error_msg OUT NOCOPY fnd_new_messages.message_name%TYPE, -- Replaced error_code with error_msg Bug 3297241

Line 73: p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,

69: p_s_adm_outcome_status IN igs_ad_ou_Stat.s_adm_outcome_status%TYPE,
70: p_decision_make_id OUT NOCOPY igs_ad_ps_appl_inst.decision_make_id%TYPE,
71: p_decision_date OUT NOCOPY igs_ad_ps_appl_inst.decision_date%TYPE,
72: p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,
73: p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,
74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,
75: p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,
76: p_error_msg OUT NOCOPY fnd_new_messages.message_name%TYPE, -- Replaced error_code with error_msg Bug 3297241
77: p_return_status OUT NOCOPY VARCHAR2,

Line 74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,

70: p_decision_make_id OUT NOCOPY igs_ad_ps_appl_inst.decision_make_id%TYPE,
71: p_decision_date OUT NOCOPY igs_ad_ps_appl_inst.decision_date%TYPE,
72: p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,
73: p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,
74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,
75: p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,
76: p_error_msg OUT NOCOPY fnd_new_messages.message_name%TYPE, -- Replaced error_code with error_msg Bug 3297241
77: p_return_status OUT NOCOPY VARCHAR2,
78: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL

Line 75: p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,

71: p_decision_date OUT NOCOPY igs_ad_ps_appl_inst.decision_date%TYPE,
72: p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,
73: p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,
74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,
75: p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,
76: p_error_msg OUT NOCOPY fnd_new_messages.message_name%TYPE, -- Replaced error_code with error_msg Bug 3297241
77: p_return_status OUT NOCOPY VARCHAR2,
78: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL
79: )

Line 122: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE

118: l_decision_maker VARCHAR2(1);
119:
120: CURSOR appl_dt_cur (
121: cp_person_id igs_pe_person.person_id%TYPE,
122: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE
123: )
124: IS
125: SELECT appl_dt
126: FROM igs_ad_appl

Line 253: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

249:
250: PROCEDURE prc_adm_outcome_status (
251: p_person_id IN igs_pe_person.person_id%TYPE,
252: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
253: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
254: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
255: p_adm_outcome_status IN igs_ad_ou_stat.adm_outcome_status%TYPE,
256: p_s_adm_outcome_status IN igs_ad_ou_stat.s_adm_outcome_status%TYPE,
257: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,

Line 254: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,

250: PROCEDURE prc_adm_outcome_status (
251: p_person_id IN igs_pe_person.person_id%TYPE,
252: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
253: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
254: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
255: p_adm_outcome_status IN igs_ad_ou_stat.adm_outcome_status%TYPE,
256: p_s_adm_outcome_status IN igs_ad_ou_stat.s_adm_outcome_status%TYPE,
257: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
258: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 284: -- samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all

280: -- Known limitations/enhancements and/or remarks:
281: --
282: -- Change History:
283: -- Who When What
284: -- samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all
285: -- kamohan 16-SEP-2002 Bug # 2550009 Changed the procedure defnition with
286: -- addition of p_ucas_transaction parameter
287: -- rghosh 18-Jun-2003 Bug#2860852(Request for reconsideration import enhancement) added the parameter p_reconsideration
288: -- rboddu 11/17/2003 Added p_prpsd_commencement_date. Bug:3181590

Line 292: l_decision_make_id igs_ad_ps_appl_inst.decision_make_id%TYPE;

288: -- rboddu 11/17/2003 Added p_prpsd_commencement_date. Bug:3181590
289: -------------------------------------------------------------------
290:
291:
292: l_decision_make_id igs_ad_ps_appl_inst.decision_make_id%TYPE;
293: l_decision_date igs_ad_ps_appl_inst.decision_date%TYPE;
294: l_decision_reason_id igs_ad_ps_appl_inst.decision_reason_id%TYPE;
295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;
296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;

Line 293: l_decision_date igs_ad_ps_appl_inst.decision_date%TYPE;

289: -------------------------------------------------------------------
290:
291:
292: l_decision_make_id igs_ad_ps_appl_inst.decision_make_id%TYPE;
293: l_decision_date igs_ad_ps_appl_inst.decision_date%TYPE;
294: l_decision_reason_id igs_ad_ps_appl_inst.decision_reason_id%TYPE;
295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;
296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
297: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;

Line 294: l_decision_reason_id igs_ad_ps_appl_inst.decision_reason_id%TYPE;

290:
291:
292: l_decision_make_id igs_ad_ps_appl_inst.decision_make_id%TYPE;
293: l_decision_date igs_ad_ps_appl_inst.decision_date%TYPE;
294: l_decision_reason_id igs_ad_ps_appl_inst.decision_reason_id%TYPE;
295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;
296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
297: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
298: l_adm_offer_resp_status igs_ad_ps_appl_inst.adm_offer_resp_status%TYPE;

Line 295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;

291:
292: l_decision_make_id igs_ad_ps_appl_inst.decision_make_id%TYPE;
293: l_decision_date igs_ad_ps_appl_inst.decision_date%TYPE;
294: l_decision_reason_id igs_ad_ps_appl_inst.decision_reason_id%TYPE;
295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;
296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
297: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
298: l_adm_offer_resp_status igs_ad_ps_appl_inst.adm_offer_resp_status%TYPE;
299: l_adm_cndtl_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;

Line 296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;

292: l_decision_make_id igs_ad_ps_appl_inst.decision_make_id%TYPE;
293: l_decision_date igs_ad_ps_appl_inst.decision_date%TYPE;
294: l_decision_reason_id igs_ad_ps_appl_inst.decision_reason_id%TYPE;
295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;
296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
297: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
298: l_adm_offer_resp_status igs_ad_ps_appl_inst.adm_offer_resp_status%TYPE;
299: l_adm_cndtl_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;
300: l_sqlerrm VARCHAR2(2000);

Line 297: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;

293: l_decision_date igs_ad_ps_appl_inst.decision_date%TYPE;
294: l_decision_reason_id igs_ad_ps_appl_inst.decision_reason_id%TYPE;
295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;
296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
297: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
298: l_adm_offer_resp_status igs_ad_ps_appl_inst.adm_offer_resp_status%TYPE;
299: l_adm_cndtl_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;
300: l_sqlerrm VARCHAR2(2000);
301:

Line 298: l_adm_offer_resp_status igs_ad_ps_appl_inst.adm_offer_resp_status%TYPE;

294: l_decision_reason_id igs_ad_ps_appl_inst.decision_reason_id%TYPE;
295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;
296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
297: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
298: l_adm_offer_resp_status igs_ad_ps_appl_inst.adm_offer_resp_status%TYPE;
299: l_adm_cndtl_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;
300: l_sqlerrm VARCHAR2(2000);
301:
302: CURSOR c_appl_cur IS

Line 299: l_adm_cndtl_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;

295: l_pending_reason_id igs_ad_ps_appl_inst.pending_reason_id%TYPE;
296: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
297: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
298: l_adm_offer_resp_status igs_ad_ps_appl_inst.adm_offer_resp_status%TYPE;
299: l_adm_cndtl_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;
300: l_sqlerrm VARCHAR2(2000);
301:
302: CURSOR c_appl_cur IS
303: SELECT a.ROWID, a.*

Line 311: FROM igs_ad_ps_appl_inst a, IGS_AD_PS_APPL b

307: l_c_appl_cur c_appl_cur%ROWTYPE;
308:
309: CURSOR c_aplinst_cur IS
310: SELECT a.ROWID, a.*, b.req_for_reconsideration_ind
311: FROM igs_ad_ps_appl_inst a, IGS_AD_PS_APPL b
312: WHERE a.person_id = p_person_id
313: AND a.admission_appl_number = p_admission_appl_number
314: AND a.nominated_course_cd = p_nominated_course_cd
315: AND a.sequence_number = p_sequence_number

Line 350: FROM igs_ad_ps_appl_inst a

346:
347: -- cursor to get the offer response status
348: CURSOR c_adm_ofr_resp_stat_cur IS
349: SELECT a.adm_offer_resp_status
350: FROM igs_ad_ps_appl_inst a
351: WHERE person_id = p_person_id
352: AND admission_appl_number = p_admission_appl_number
353: AND nominated_course_cd = p_nominated_course_cd
354: AND sequence_number = p_sequence_number;

Line 358: l_prpsd_commencement_dt igs_ad_ps_appl_inst.prpsd_commencement_dt%TYPE;

354: AND sequence_number = p_sequence_number;
355:
356: l_c_ps_appl_cur c_ps_appl_cur%ROWTYPE;
357: l_req_for_reconsideration_ind igs_ad_ps_appl.req_for_reconsideration_ind%TYPE;
358: l_prpsd_commencement_dt igs_ad_ps_appl_inst.prpsd_commencement_dt%TYPE;
359: l_actual_response_dt igs_ad_ps_appl_inst.actual_response_dt%TYPE;
360: l_cur_msg_count NUMBER;
361: l_max_msg_count NUMBER;
362: l_msg_index_out NUMBER;

Line 359: l_actual_response_dt igs_ad_ps_appl_inst.actual_response_dt%TYPE;

355:
356: l_c_ps_appl_cur c_ps_appl_cur%ROWTYPE;
357: l_req_for_reconsideration_ind igs_ad_ps_appl.req_for_reconsideration_ind%TYPE;
358: l_prpsd_commencement_dt igs_ad_ps_appl_inst.prpsd_commencement_dt%TYPE;
359: l_actual_response_dt igs_ad_ps_appl_inst.actual_response_dt%TYPE;
360: l_cur_msg_count NUMBER;
361: l_max_msg_count NUMBER;
362: l_msg_index_out NUMBER;
363: l_app_name VARCHAR2(2000);

Line 550: FROM igs_ad_ps_appl_inst aplinst, igs_ad_appl appl

546: FROM igs_ad_admde_int_all mdi, igs_ad_batc_def_det_all abdd
547: WHERE mdi.batch_id = p_batch_id
548: AND mdi.batch_id = abdd.batch_id
549: AND EXISTS ( SELECT 1
550: FROM igs_ad_ps_appl_inst aplinst, igs_ad_appl appl
551: WHERE aplinst.person_id = appl.person_id
552: AND aplinst.admission_appl_number = appl.admission_appl_number
553: AND aplinst.person_id = mdi.person_id
554: AND aplinst.admission_appl_number = mdi.admission_appl_number

Line 574: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

570:
571: CURSOR c_old_adm_outcome_status (
572: cp_person_id IN igs_pe_person.person_id%TYPE,
573: cp_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
574: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
575: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
576: ) IS
577: SELECT adm_outcome_status
578: FROM igs_ad_ps_appl_inst

Line 575: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE

571: CURSOR c_old_adm_outcome_status (
572: cp_person_id IN igs_pe_person.person_id%TYPE,
573: cp_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
574: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
575: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
576: ) IS
577: SELECT adm_outcome_status
578: FROM igs_ad_ps_appl_inst
579: WHERE person_id = cp_person_id

Line 578: FROM igs_ad_ps_appl_inst

574: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
575: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
576: ) IS
577: SELECT adm_outcome_status
578: FROM igs_ad_ps_appl_inst
579: WHERE person_id = cp_person_id
580: AND admission_appl_number = cp_admission_appl_number
581: AND nominated_course_cd = cp_nominated_course_cd
582: AND sequence_number = cp_sequence_number;

Line 584: l_old_adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;

580: AND admission_appl_number = cp_admission_appl_number
581: AND nominated_course_cd = cp_nominated_course_cd
582: AND sequence_number = cp_sequence_number;
583:
584: l_old_adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
585: l_error_msg fnd_new_messages.message_text%TYPE;
586:
587: BEGIN
588: DECLARE