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_APPL

Line 63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,

59: PROCEDURE validate_set_decision_details (
60: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
61: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
62: p_person_id IN igs_pe_person.person_id%TYPE,
63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%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,

Line 64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,

60: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
61: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
62: p_person_id IN igs_pe_person.person_id%TYPE,
63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%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,

Line 65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,

61: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
62: p_person_id IN igs_pe_person.person_id%TYPE,
63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%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,

Line 66: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,

62: p_person_id IN igs_pe_person.person_id%TYPE,
63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%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,

Line 67: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,

63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%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,

Line 68: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,

64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%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,

Line 126: FROM igs_ad_appl

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
127: WHERE person_id = cp_person_id
128: AND admission_appl_number = cp_admission_appl_number;
129:
130: l_appl_dt igs_ad_appl.appl_dt%TYPE;

Line 130: l_appl_dt igs_ad_appl.appl_dt%TYPE;

126: FROM igs_ad_appl
127: WHERE person_id = cp_person_id
128: AND admission_appl_number = cp_admission_appl_number;
129:
130: l_appl_dt igs_ad_appl.appl_dt%TYPE;
131:
132: CURSOR c_code_classes (cp_class igs_ad_code_classes.class%TYPE,
133: cp_code_id igs_ad_code_classes.code_id%TYPE) IS
134: SELECT 'x'

Line 252: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,

248: END validate_set_decision_details;
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,

Line 257: p_acad_cal_type IN igs_ad_appl.acad_cal_type%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,
259: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,

Line 258: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%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,
259: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,

Line 259: p_adm_cal_type IN igs_ad_appl.adm_cal_type%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,
259: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,

Line 260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%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,
259: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
264: p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,

Line 261: p_admission_cat IN igs_ad_appl.admission_cat%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,
259: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
264: p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,
265: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,

Line 262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,

258: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
259: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
260: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
261: p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
264: p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,
265: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
266: p_error_message OUT NOCOPY fnd_new_messages.message_text%TYPE,

Line 304: FROM IGS_AD_APPL a

300: l_sqlerrm VARCHAR2(2000);
301:
302: CURSOR c_appl_cur IS
303: SELECT a.ROWID, a.*
304: FROM IGS_AD_APPL a
305: WHERE person_id = p_person_id
306: AND admission_appl_number = p_admission_appl_number;
307: l_c_appl_cur c_appl_cur%ROWTYPE;
308:

Line 464: IGS_AdmApplication_PUB.Record_Outcome_AdmApplication(

460:
461:
462: l_cur_msg_count := igs_ge_msg_stack.count_msg;
463:
464: IGS_AdmApplication_PUB.Record_Outcome_AdmApplication(
465: p_api_version => 1.0,
466: p_init_msg_list => FND_API.G_TRUE,
467: p_commit => FND_API.G_FALSE,
468: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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 573: cp_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,

569: AND status = '2';
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