DBA Data[Home] [Help]

APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_AD_ADMDE_INT

Line 4: p_status IN igs_ad_admde_int.status%TYPE,

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: );

Line 6: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,

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 (

Line 7: p_outcome_status IN igs_ad_admde_int.adm_outcome_status%TYPE

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,

Line 11: p_batch_id IN igs_ad_admde_int.batch_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,

Line 12: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%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,

Line 29: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL

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,

Line 45: p_batch_id IN igs_ad_admde_int.batch_id%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,

Line 46: p_interface_run_id IN igs_ad_admde_int.interface_run_id%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',

Line 47: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%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',

Line 52: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL

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 (