[Home] [Help]
31: FUNCTION create_application_detail
32: (p_person_id IN igs_pe_typ_instances_all.person_id%TYPE,
33: p_adm_appl_number IN igs_pe_typ_instances_all.admission_appl_number%TYPE,
34: p_ss_adm_appl_number IN NUMBER) RETURN BOOLEAN;
35: FUNCTION create_application(p_appl_rec IN igs_ss_adm_appl_stg%ROWTYPE,
36: p_message_name OUT NOCOPY VARCHAR2,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_adm_appl_number OUT NOCOPY NUMBER)
39: RETURN BOOLEAN;
36: p_message_name OUT NOCOPY VARCHAR2,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_adm_appl_number OUT NOCOPY NUMBER)
39: RETURN BOOLEAN;
40: FUNCTION create_program(p_appl_rec IN igs_ss_adm_appl_stg%ROWTYPE,
41: p_message_name OUT NOCOPY VARCHAR2,
42: p_return_status OUT NOCOPY VARCHAR2,
43: p_adm_appl_number IN NUMBER) RETURN BOOLEAN;
44: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,
134:
135: --Cursor Declaration
136: CURSOR c_adm_appl IS
137: SELECT *
138: FROM igs_ss_adm_appl_stg
139: WHERE person_id = x_person_id
140: AND ss_adm_appl_id = x_application_id;
141:
142: c_adm_appl_rec c_adm_appl%ROWTYPE;
219: -- App_Exception.Raise_Exception; x_return_status is an OUT NOCOPY parameter and will not show the value set, for it if the exception is raised. So commenting out NOCOPY Bug# 2224624
220: END transfer_data;
221:
222: --This Function Creates an Application and Returns TRUE if Application is created.
223: FUNCTION create_application(p_appl_rec IN igs_ss_adm_appl_stg%ROWTYPE,
224: p_message_name OUT NOCOPY VARCHAR2,
225: p_return_status OUT NOCOPY VARCHAR2,
226: p_adm_appl_number OUT NOCOPY NUMBER)
227: RETURN BOOLEAN IS
337:
338: END create_application; --Main End
339:
340: --This Function Creates Program Application and Program Application Instance
341: FUNCTION create_program(p_appl_rec IN igs_ss_adm_appl_stg%ROWTYPE,
342: p_message_name OUT NOCOPY VARCHAR2,
343: p_return_status OUT NOCOPY VARCHAR2,
344: p_adm_appl_number IN NUMBER) RETURN BOOLEAN AS
345: /*****************************************************************************************
368: l_error_code VARCHAR2(30);
369:
370: CURSOR c_admappl_pgm IS
371: SELECT d.*, m.app_source_id
372: FROM igs_ss_adm_appl_stg m, IGS_SS_APP_PGM_STG d
373: WHERE m.ss_adm_appl_id = d.ss_adm_appl_id
374: AND m.ss_adm_appl_id = p_appl_rec.ss_adm_appl_id
375: AND m.person_id = p_appl_rec.person_id;
376: --Autoadmit
1089: othinst.institution_code,
1090: i.name,
1091: othinst.new_institution
1092: FROM igs_ss_ad_othins_stg othinst,
1093: igs_ss_adm_appl_stg appl,
1094: igs_or_institution i,
1095: igs_pe_hz_parties php
1096: WHERE othinst.ss_adm_appl_id = appl.ss_adm_appl_id
1097: AND othinst.institution_code = i.institution_cd
1222: *****************************************************************************************/
1223:
1224: BEGIN
1225: BEGIN
1226: INSERT INTO igs_ss_adm_appl_stg
1227: (ss_adm_appl_id,
1228: person_id,
1229: appl_date,
1230: admission_application_type,
1255: END IF;
1256: END;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: logDetail('insert igs_ss_adm_appl_stg' || SQLERRM ||
1260: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1261: 'S');
1262: x_return_status := 'E';
1263: x_message_name := 'IGS_GE_UNHANDLED_EXP';
1433: DELETE FROM igs_ss_app_pgm_stg
1434: WHERE person_id = p_person_id
1435: AND ss_adm_appl_id = p_adm_appl_number;
1436:
1437: DELETE FROM igs_ss_adm_appl_stg
1438: WHERE ss_adm_appl_id = p_adm_appl_number
1439: AND person_id = p_person_id;
1440:
1441: END;
3175: Who When What
3176: stammine 10-June-05 Modified the Cursor of Checklist values.
3177: *****************************************************************************************/
3178:
3179: CURSOR c_chklist(cp_ApplNum igs_ss_Adm_appl_stg.SS_ADM_APPL_ID%TYPE, cp_person_id igs_ss_Adm_appl_stg.PERSON_ID%TYPE) IS
3180: SELECT pgs.page_name section
3181: FROM igs_ad_ss_appl_pgs pgs
3182: WHERE pgs.admission_application_type =
3183: (SELECT admission_application_type
3180: SELECT pgs.page_name section
3181: FROM igs_ad_ss_appl_pgs pgs
3182: WHERE pgs.admission_application_type =
3183: (SELECT admission_application_type
3184: FROM igs_ss_adm_appl_stg
3185: WHERE ss_adm_appl_id = cp_ApplNum)
3186: AND pgs.include_ind = 'Y'
3187: AND NOT EXISTS ( SELECT 'x'
3188: FROM igs_ss_ad_sec_stat
4593: Known limitations,enhancements,remarks:
4594: Change History
4595: Who When What
4596: *****************************************************************************************/
4597: CURSOR c_NoPgs(cp_ApplType igs_ss_Adm_appl_stg.ADMISSION_APPLICATION_TYPE%TYPE) IS
4598: SELECT count(*)
4599: FROM igs_ad_ss_appl_pgs
4600: WHERE admission_application_type = cp_ApplType
4601: AND include_ind = 'Y';
5137:
5138: CURSOR c_appl_Stg(cp_ss_adm_appl_id NUMBER) IS
5139: SELECT person_id, acad_cal_type, acad_cal_seq_number, adm_cal_type,
5140: adm_cal_seq_number , admission_cat, s_adm_process_type
5141: FROM igs_ss_adm_appl_stg
5142: WHERE ss_adm_appl_id = cp_ss_adm_appl_id;
5143:
5144: CURSOR c_apcs (cp_step_type VARCHAR2, cp_admission_cat VARCHAR2, cp_s_admission_process_type VARCHAR2) IS
5145: SELECT s_admission_step_type, step_type_restriction_num
5308:
5309: CURSOR c_appl_Stg(cp_ss_adm_appl_id NUMBER) IS
5310: SELECT person_id, acad_cal_type, acad_cal_seq_number, adm_cal_type,
5311: adm_cal_seq_number , admission_cat, s_adm_process_type
5312: FROM igs_ss_adm_appl_stg
5313: WHERE ss_adm_appl_id = cp_ss_adm_appl_id;
5314:
5315: CURSOR c_apcs (cp_step_type VARCHAR2, cp_admission_cat VARCHAR2, cp_s_admission_process_type VARCHAR2) IS
5316: SELECT s_admission_step_type, step_type_restriction_num