[Home] [Help]
PACKAGE: APPS.IGS_AD_IMP_ADM_DES
Source
1 PACKAGE igs_ad_imp_adm_des AS
2 /* $Header: IGSADB1S.pls 120.0 2005/06/01 21:35:09 appldev noship $ */
3 PROCEDURE update_int_table (
4 p_status IN igs_ad_admde_int.status%TYPE,
5 p_error_msg IN fnd_new_messages.message_text%TYPE,
6 p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
7 p_outcome_status IN igs_ad_admde_int.adm_outcome_status%TYPE
8 );
9
10 PROCEDURE validate_set_decision_details (
11 p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
12 p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
13 p_person_id IN igs_pe_person.person_id%TYPE,
14 p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
15 p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
16 p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
17 p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
18 p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
19 p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
20 p_s_adm_outcome_status IN igs_ad_ou_Stat.s_adm_outcome_status%TYPE,
21 p_decision_make_id OUT NOCOPY igs_ad_ps_appl_inst.decision_make_id%TYPE,
22 p_decision_date OUT NOCOPY igs_ad_ps_appl_inst.decision_date%TYPE,
23 p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,
24 p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,
25 p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,
26 p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,
27 p_error_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
28 p_return_status OUT NOCOPY VARCHAR2,
29 p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL
30 );
31
32 PROCEDURE prc_adm_outcome_status (
33 p_person_id IN igs_pe_person.person_id%TYPE,
34 p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
35 p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
36 p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
37 p_adm_outcome_status IN igs_ad_ou_stat.adm_outcome_status%TYPE,
38 p_s_adm_outcome_status IN igs_ad_ou_stat.s_adm_outcome_status%TYPE,
39 p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
40 p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
41 p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
42 p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,
43 p_admission_cat IN igs_ad_appl.admission_cat%TYPE,
44 p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
45 p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
46 p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,
47 p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
48 p_error_message OUT NOCOPY fnd_new_messages.message_text%TYPE,
49 p_return_status OUT NOCOPY VARCHAR2,
50 p_ucas_transaction IN VARCHAR2 DEFAULT 'N',
51 p_reconsideration IN VARCHAR2 DEFAULT 'N',
52 p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL
53
54 );
55
56 PROCEDURE import_adm_decision (
57 p_batch_id IN igs_ad_batc_def_det_all.batch_id%TYPE,
58 p_ucas_transaction IN VARCHAR2,
59 p_message_name OUT NOCOPY VARCHAR2,
60 p_msg_token_rec_prc_cnt OUT NOCOPY NUMBER
61 );
62
63 PROCEDURE discard_adm_decision (
64 p_batch_id IN igs_ad_batc_def_det_all.batch_id%TYPE,
65 p_message_name OUT NOCOPY VARCHAR2,
66 p_msg_token_rec_prc_cnt OUT NOCOPY NUMBER
67 );
68
69 END igs_ad_imp_adm_des;