APPS.IGS_AD_GEN_012 dependencies on IGS_AD_APPL

Line 27: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

23: RETURN BOOLEAN IS
24:
25: -- This module updates the IGS_AD_PS_APPL_INST.prpsd_commencement_dt.
26:
27: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
28: v_dummy VARCHAR2(1);
29: v_message_name VARCHAR2(30);
30: v_update_non_enrol_detail_ind VARCHAR2(1);
31: CURSOR c_acai IS

Line 41: FROM IGS_AD_APPL aa

37: acai.sequence_number = p_acai_sequence_number
38: FOR UPDATE OF acai.prpsd_commencement_dt NOWAIT;
39: CURSOR c_aa IS
40: SELECT aa.adm_appl_status
41: FROM IGS_AD_APPL aa
42: WHERE aa.person_id = p_person_id AND
43: aa.admission_appl_number = p_admission_appl_number;
44: e_resource_busy_exception EXCEPTION;
45: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);

Line 81: IF ( v_message_name = 'IGS_AD_APPL_INST_COMPL')

77:
78: -- begin apadegal adtd001 igs.m
79:
80: -- PRPSD_COMMENCEMENT_DT can be udpated in proceed phase
81: IF ( v_message_name = 'IGS_AD_APPL_INST_COMPL')
82: THEN
83:
84:
85: IF igs_ad_gen_002.check_adm_appl_inst_stat( p_person_id => Rec_IGS_AD_PS_APPL_Inst.PERSON_ID ,

Line 92: p_message_name := 'IGS_AD_APPL_INST_COMPL';

88: p_sequence_number => Rec_IGS_AD_PS_APPL_Inst.SEQUENCE_NUMBER ,
89: p_updateable => 'Y'
90: )='N' --- not updateable.. so throw error
91: THEN
92: p_message_name := 'IGS_AD_APPL_INST_COMPL';
93: RETURN FALSE;
94: END IF;
95: ELSE
96: --end apadegal adtd001 igs.m

Line 537: IGS_AD_APPL aa

533: aa.admission_appl_number,
534: aa.appl_dt,
535: aca.nominated_course_cd
536: FROM IGS_AD_PS_APPL aca,
537: IGS_AD_APPL aa
538: WHERE aa.person_id = aca.person_id
539: AND aa.admission_appl_number = aca.admission_appl_number
540: AND aca.req_for_reconsideration_ind = 'Y'
541: AND EXISTS ( SELECT 'x' FROM igs_ad_prd_ad_prc_ca apapc

Line 564: cp_person_id IGS_AD_APPL.person_id%TYPE,

560: Rec_IGS_AD_PS_APPL c_aca%ROWTYPE;
561:
562: CURSOR c_acaiv (
563: cp_start_dt IGS_CA_INST.start_dt%TYPE,
564: cp_person_id IGS_AD_APPL.person_id%TYPE,
565: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
566: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE) IS
567: SELECT acaiv.person_id,
568: acaiv.admission_appl_number,

Line 565: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

561:
562: CURSOR c_acaiv (
563: cp_start_dt IGS_CA_INST.start_dt%TYPE,
564: cp_person_id IGS_AD_APPL.person_id%TYPE,
565: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
566: cp_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE) IS
567: SELECT acaiv.person_id,
568: acaiv.admission_appl_number,
569: acaiv.nominated_course_cd,

Line 579: igs_ad_appl aa

575: acaiv.attendance_type,
576: acaiv.attendance_mode,
577: acaiv.location_cd
578: FROM igs_ad_ps_appl_inst acaiv,
579: igs_ad_appl aa
580: WHERE aa.person_id = acaiv.person_id
581: AND aa.admission_appl_number = acaiv.admission_appl_number
582: AND acaiv.person_id = cp_person_id
583: AND acaiv.admission_appl_number = cp_admission_appl_number

Line 903: v_log_message_name := 'IGS_AD_APPL_NOT_PROCESSED';

899: CLOSE c_acai;
900: END IF;
901: EXCEPTION
902: WHEN e_resource_busy_exception THEN
903: v_log_message_name := 'IGS_AD_APPL_NOT_PROCESSED';
904: WHEN OTHERS THEN
905: IF c_acai%ISOPEN THEN
906: CLOSE c_acai;
907: END IF;

Line 952: v_log_message_name := 'IGS_AD_APPL_CURR_BEING_UPD';

948: CLOSE c_aca;
949: END IF;
950: EXCEPTION
951: WHEN e_resource_busy_exception THEN
952: v_log_message_name := 'IGS_AD_APPL_CURR_BEING_UPD';
953: -- Insert into log for reporting
954: IGS_GE_GEN_003.genp_ins_log_entry(
955: cst_adm_recon,
956: v_creation_dt,