APPS.IGS_AD_GEN_003 dependencies on IGS_AD_PS_APPL_INST

Line 25: -- IGS_AD_PS_APPL_INST. adm_outcome_status was set.

21: p_date OUT NOCOPY DATE )
22: RETURN NUMBER IS
23: BEGIN -- admp_get_acai_aos_id
24: -- This module gets the person id and date of the current
25: -- IGS_AD_PS_APPL_INST. adm_outcome_status was set.
26: DECLARE
27: v_person_id IGS_AD_PS_APPL_INST.person_id%TYPE;
28:
29: CURSOR c_acai IS

Line 27: v_person_id IGS_AD_PS_APPL_INST.person_id%TYPE;

23: BEGIN -- admp_get_acai_aos_id
24: -- This module gets the person id and date of the current
25: -- IGS_AD_PS_APPL_INST. adm_outcome_status was set.
26: DECLARE
27: v_person_id IGS_AD_PS_APPL_INST.person_id%TYPE;
28:
29: CURSOR c_acai IS
30: SELECT acai.decision_date,
31: acai.decision_make_id

Line 32: FROM IGS_AD_PS_APPL_INST acai

28:
29: CURSOR c_acai IS
30: SELECT acai.decision_date,
31: acai.decision_make_id
32: FROM IGS_AD_PS_APPL_INST acai
33: WHERE acai.person_id = p_person_id AND
34: acai.admission_appl_number = p_admission_appl_number AND
35: acai.nominated_course_cd = p_nominated_course_cd AND
36: acai.sequence_number = p_acai_sequence_number AND

Line 72: -- IGS_AD_PS_APPL_INST.course_cd/crv_version_number

68: p_crv_version_number OUT NOCOPY NUMBER )
69: RETURN VARCHAR2 IS
70: BEGIN -- admp_get_acai_crv
71: -- Description: This module gets
72: -- IGS_AD_PS_APPL_INST.course_cd/crv_version_number
73: DECLARE
74: CURSOR c_acai IS
75: SELECT acai.course_cd,
76: acai.crv_version_number

Line 77: FROM IGS_AD_PS_APPL_INST acai

73: DECLARE
74: CURSOR c_acai IS
75: SELECT acai.course_cd,
76: acai.crv_version_number
77: FROM IGS_AD_PS_APPL_INST acai
78: WHERE acai.person_id = p_person_id AND
79: acai.admission_appl_number = p_admission_appl_number AND
80: acai.nominated_course_cd = p_nominated_course_cd AND
81: acai.sequence_number = p_sequence_number;

Line 114: -- for the specified IGS_AD_PS_APPL_INST. It returns the statuses

110: p_adm_offer_resp_status OUT NOCOPY VARCHAR2 )
111: RETURN VARCHAR2 IS
112: BEGIN -- admp_get_acai_status
113: -- This module gets the adm_outcome_status and adm_offer_resp_status
114: -- for the specified IGS_AD_PS_APPL_INST. It returns the statuses
115: -- formatted to be used by admission course application context blocks.
116: DECLARE
117: CURSOR c_acai IS
118: SELECT acai.adm_outcome_status,

Line 121: FROM IGS_AD_PS_APPL_INST acai,

117: CURSOR c_acai IS
118: SELECT acai.adm_outcome_status,
119: acai.adm_offer_resp_status,
120: aors.s_adm_offer_resp_status
121: FROM IGS_AD_PS_APPL_INST acai,
122: IGS_AD_OFR_RESP_STAT aors
123: WHERE aors.adm_offer_resp_status = acai.adm_offer_resp_status AND
124: acai.person_id = p_person_id AND
125: acai.admission_appl_number = p_admission_appl_number AND

Line 755: l_adm_doc_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE,

751: END admp_get_apcs_mndtry;
752:
753: PROCEDURE get_entr_doc_apc (p_admission_cat IN IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
754: p_s_admission_process_type IN IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
755: l_adm_doc_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE,
756: l_adm_entr_qual_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE) IS
757: /*****************************************************************************************
758: Created By: [email protected]
759: Date Created : 09-SEP-2002

Line 756: l_adm_entr_qual_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE) IS

752:
753: PROCEDURE get_entr_doc_apc (p_admission_cat IN IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
754: p_s_admission_process_type IN IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
755: l_adm_doc_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE,
756: l_adm_entr_qual_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE) IS
757: /*****************************************************************************************
758: Created By: [email protected]
759: Date Created : 09-SEP-2002
760: Purpose: 1.Returns the application completion status and entry qual status based on APC