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_DEF_APPL_PKG dependencies on IGS_AD_APPL

Line 63: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;

59:
60: -- Variable Declarations ----------------------------------------------------------------------------------------------------
61:
62: -- Resolve the parameters to get calendar types and sequence numbers
63: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
64: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
65: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
66: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
67:

Line 64: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;

60: -- Variable Declarations ----------------------------------------------------------------------------------------------------
61:
62: -- Resolve the parameters to get calendar types and sequence numbers
63: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
64: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
65: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
66: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
67:
68: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;

Line 65: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;

61:
62: -- Resolve the parameters to get calendar types and sequence numbers
63: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
64: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
65: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
66: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
67:
68: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
69: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;

Line 66: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;

62: -- Resolve the parameters to get calendar types and sequence numbers
63: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
64: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
65: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
66: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
67:
68: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
69: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
70: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;

Line 68: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;

64: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
65: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
66: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
67:
68: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
69: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
70: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
71: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
72:

Line 69: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;

65: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
66: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
67:
68: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
69: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
70: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
71: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
72:
73: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;

Line 70: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;

66: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
67:
68: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
69: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
70: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
71: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
72:
73: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
74: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;

Line 71: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;

67:
68: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ;
69: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
70: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
71: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
72:
73: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
74: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
75:

Line 77: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

73: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
74: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
75:
76: l_message_name VARCHAR2(1000);
77: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
78: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
79: cst_deferral CONSTANT VARCHAR2(9) := 'DEFERRAL';
80: cst_approved CONSTANT VARCHAR2(9) := 'APPROVED';
81:

Line 131: igs_ad_appl aa,

127: CURSOR c_appl_inst(p_person_id hz_parties.party_id%TYPE) IS
128: SELECT
129: acai.*
130: FROM
131: igs_ad_appl aa,
132: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
133: igs_ad_ofr_resp_stat aous,
134: igs_ad_ofrdfrmt_stat aods
135: WHERE

Line 343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,

339: p_person_id hz_parties.party_id%TYPE,
340: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
341: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
346: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
347: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

Line 344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

340: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
341: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
346: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
347: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
348: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE

Line 345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

341: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
346: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
347: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
348: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
349: ) IS

Line 346: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
346: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
347: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
348: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
349: ) IS
350:

Line 365: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

361: AND apai.sequence_number =p_sequence_number
362: AND apai.adm_offer_dfrmnt_status = aods.adm_offer_dfrmnt_status ;
363:
364: l_message_name VARCHAR2(1000);
365: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
366: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
367: l_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat_v.s_adm_offer_dfrmnt_status%TYPE;
368:
369: v_start_dt DATE;

Line 371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,

367: l_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat_v.s_adm_offer_dfrmnt_status%TYPE;
368:
369: v_start_dt DATE;
370:
371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
372: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
373: SELECT acad_cal_type,acad_ci_sequence_number
374: FROM igs_ad_appl_all
375: WHERE person_id = cp_person_id

Line 372: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

368:
369: v_start_dt DATE;
370:
371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
372: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
373: SELECT acad_cal_type,acad_ci_sequence_number
374: FROM igs_ad_appl_all
375: WHERE person_id = cp_person_id
376: AND admission_appl_number = cp_admission_appl_number;

Line 374: FROM igs_ad_appl_all

370:
371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
372: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
373: SELECT acad_cal_type,acad_ci_sequence_number
374: FROM igs_ad_appl_all
375: WHERE person_id = cp_person_id
376: AND admission_appl_number = cp_admission_appl_number;
377:
378: l_get_acad_cal_info c_get_acad_cal_info%ROWTYPE;

Line 502: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,

498: END cmn_handle_application;
499:
500: FUNCTION handle_application(
501: p_person_id hz_parties.party_id%TYPE,
502: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
503: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

501: p_person_id hz_parties.party_id%TYPE,
502: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
503: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
508: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
509: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,

Line 506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

502: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
503: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
508: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
509: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
510: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE

Line 507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

503: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
508: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
509: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
510: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE
511: ) RETURN BOOLEAN IS

Line 508: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
508: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
509: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
510: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE
511: ) RETURN BOOLEAN IS
512: /*******************************************************************************

Line 509: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,

505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
508: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
509: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
510: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE
511: ) RETURN BOOLEAN IS
512: /*******************************************************************************
513: Created by : Ramesh Rengarajan

Line 546: igs_ad_appl aa,

542: NVL(acai.adm_cal_type,aa.adm_cal_type) final_adm_cal_type,
543: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
544: FROM
545: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
546: igs_ad_appl aa,
547: igs_ad_ps_appl aca
548: WHERE
549: acai.admission_appl_number = p_admission_appl_number
550: AND acai.sequence_number = p_sequence_number

Line 560: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,

556: AND aca.admission_appl_number = acai.admission_appl_number
557: AND aca.nominated_course_cd = acai.nominated_course_cd;
558:
559:
560: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
561: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
562: )
563: IS
564: SELECT admission_application_type

Line 561: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE

557: AND aca.nominated_course_cd = acai.nominated_course_cd;
558:
559:
560: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
561: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
562: )
563: IS
564: SELECT admission_application_type
565: FROM igs_ad_ss_appl_typ

Line 575: l_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;

571: -----End cursor Declarations------------------------------------------------------------------
572:
573: -------------------Variable Declarations------------------------------------------------------
574: l_message_name VARCHAR2(1000);
575: l_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
576: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
577: l_return_type VARCHAR2(100);
578: l_error_code VARCHAR2(100);
579: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;

Line 579: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;

575: l_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
576: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
577: l_return_type VARCHAR2(100);
578: l_error_code VARCHAR2(100);
579: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
580: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
581: l_application_type igs_ad_appl_all.application_type%TYPE;
582: ------------------- End Variable Declarations------------------------------------------------------
583: BEGIN

Line 580: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

576: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
577: l_return_type VARCHAR2(100);
578: l_error_code VARCHAR2(100);
579: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
580: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
581: l_application_type igs_ad_appl_all.application_type%TYPE;
582: ------------------- End Variable Declarations------------------------------------------------------
583: BEGIN
584: FOR c_appl_inst_rec IN c_appl_inst LOOP

Line 581: l_application_type igs_ad_appl_all.application_type%TYPE;

577: l_return_type VARCHAR2(100);
578: l_error_code VARCHAR2(100);
579: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
580: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
581: l_application_type igs_ad_appl_all.application_type%TYPE;
582: ------------------- End Variable Declarations------------------------------------------------------
583: BEGIN
584: FOR c_appl_inst_rec IN c_appl_inst LOOP
585:

Line 760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
761: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
762: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
763: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
764: p_start_dt DATE

Line 761: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
761: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
762: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
763: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
764: p_start_dt DATE
765: ) RETURN BOOLEAN IS

Line 762: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
761: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
762: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
763: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
764: p_start_dt DATE
765: ) RETURN BOOLEAN IS
766: /*******************************************************************************

Line 763: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
761: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
762: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
763: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
764: p_start_dt DATE
765: ) RETURN BOOLEAN IS
766: /*******************************************************************************
767: Created by : Ramesh Rengarajan

Line 809: igs_ad_appl aa

805: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
806:
807: FROM
808: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
809: igs_ad_appl aa
810: WHERE
811: acai.person_id = p_person_id
812: AND acai.nominated_course_cd = p_nominated_course_cd
813: AND acai.sequence_number = p_sequence_number

Line 822: igs_ad_appl

818: CURSOR c_admcat_cur IS
819: SELECT
820: admission_cat, s_admission_process_type, appl_dt
821: FROM
822: igs_ad_appl
823: WHERE
824: person_id = p_person_id AND
825: admission_appl_number = p_admission_appl_number;
826:

Line 877: l_adm_cat IGS_AD_APPL.admission_cat%TYPE;

873: v_deferral_allowed_ind VARCHAR2 (1);
874: v_pre_enrol_ind VARCHAR2 (1);
875: v_warn_level VARCHAR2(10);
876: v_message_name VARCHAR2(100);
877: l_adm_cat IGS_AD_APPL.admission_cat%TYPE;
878: l_s_adm_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
879: l_appl_dt IGS_AD_APPL.appl_dt%TYPE;
880: cst_offer CONSTANT VARCHAR2(9) := 'OFFER';
881: cst_received CONSTANT VARCHAR2(9) := 'RECEIVED';

Line 878: l_s_adm_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

874: v_pre_enrol_ind VARCHAR2 (1);
875: v_warn_level VARCHAR2(10);
876: v_message_name VARCHAR2(100);
877: l_adm_cat IGS_AD_APPL.admission_cat%TYPE;
878: l_s_adm_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
879: l_appl_dt IGS_AD_APPL.appl_dt%TYPE;
880: cst_offer CONSTANT VARCHAR2(9) := 'OFFER';
881: cst_received CONSTANT VARCHAR2(9) := 'RECEIVED';
882: cst_pending CONSTANT VARCHAR2(9) := 'PENDING';

Line 879: l_appl_dt IGS_AD_APPL.appl_dt%TYPE;

875: v_warn_level VARCHAR2(10);
876: v_message_name VARCHAR2(100);
877: l_adm_cat IGS_AD_APPL.admission_cat%TYPE;
878: l_s_adm_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
879: l_appl_dt IGS_AD_APPL.appl_dt%TYPE;
880: cst_offer CONSTANT VARCHAR2(9) := 'OFFER';
881: cst_received CONSTANT VARCHAR2(9) := 'RECEIVED';
882: cst_pending CONSTANT VARCHAR2(9) := 'PENDING';
883: -- End Variable Declarations -------------------------------------------------------------------------------