PACKAGE: APPS.IGS_AD_VAL_ACA

Source

1 PACKAGE IGS_AD_VAL_ACA AUTHID CURRENT_USER AS
2 /* $Header: IGSAD21S.pls 115.7 2002/11/28 21:27:00 nsidana ship $ */
3 
4   TYPE r_aca_aa IS RECORD
5   (
6   person_id NUMBER(15),
7   admission_appl_number NUMBER(2),
8   adm_appl_status VARCHAR2(10));
9 
10   -- To validate discontinuation and student course transfer
11   FUNCTION enrp_val_sca_trnsfr(
12   p_person_id IN NUMBER,
13   p_course_cd IN VARCHAR2 ,
14   p_discontinued_dt IN DATE ,
15   p_validation_ind IN VARCHAR2 DEFAULT 'N',
16   p_message_name   OUT NOCOPY  VARCHAR2)
17 RETURN BOOLEAN;
18 
19   --
20 
21   -- To validate the admission application preference limit.
22   FUNCTION admp_val_pref_limit(
23   p_person_id IN NUMBER ,
24   p_admission_appl_number IN NUMBER ,
25   p_nominated_course_cd IN VARCHAR2 ,
26   p_acai_sequence_number IN NUMBER ,
27   p_s_admission_process_type IN VARCHAR2 ,
28   p_pref_limit  NUMBER ,
29   p_message_name   OUT NOCOPY  VARCHAR2)
30 RETURN BOOLEAN;
31 
32   --
33   -- Validate the course code of the admission application.
34 
35 
36   --
37   -- Perform encumbrance check for admission_course_appl_instance.course_cd
38 
39 
40   --
41   -- Validate course appl process type against the student course attempt.
42 
43   --
44   -- Validate admission course application transfer details.
45   FUNCTION admp_val_aca_trnsfr(
46   p_person_id IN NUMBER ,
47   p_nominated_course_cd IN VARCHAR2 ,
48   p_nominated_version_number IN NUMBER ,
49   p_transfer_course_cd IN VARCHAR2 ,
50   p_s_admission_process_type IN VARCHAR2 ,
51   p_course_encmb_chk_ind IN VARCHAR2 DEFAULT 'N',
52   p_adm_cal_type IN VARCHAR2 ,
53   p_adm_ci_sequence_number IN NUMBER ,
54   p_message_name   OUT NOCOPY  VARCHAR2,
55   p_return_type OUT NOCOPY VARCHAR2 )
56 RETURN BOOLEAN;
57 
58   --
59   -- Validate if IGS_AD_CD.IGS_AD_CD is closed.
60   FUNCTION admp_val_aco_closed(
61   p_admission_cd IN VARCHAR2 ,
62   p_message_name   OUT NOCOPY  VARCHAR2)
63 RETURN BOOLEAN;
64 
65   --
66   -- Validate if IGS_AD_BASIS_FOR_AD.basis_for_admission_type is closed.
67   FUNCTION admp_val_bfa_closed(
68   p_basis_for_admission_type IN VARCHAR2 ,
69   p_message_name   OUT NOCOPY  VARCHAR2)
70 RETURN BOOLEAN;
71 
72   --
73   -- Validate IGS_AD_PS_APPL.req_for_reconsideration_ind.
74   FUNCTION admp_val_aca_req_rec(
75   p_req_for_reconsideration_ind IN VARCHAR2 DEFAULT 'N',
76   p_req_reconsider_allowed IN VARCHAR2 DEFAULT 'N',
77   p_message_name   OUT NOCOPY  VARCHAR2)
78 RETURN BOOLEAN;
79 
80   --
81   -- Validate IGS_AD_PS_APPL.req_for_adv_standing_ind.
82   FUNCTION admp_val_aca_req_adv(
83   p_req_for_adv_standing_ind IN VARCHAR2 DEFAULT 'N',
84   p_req_adv_standing_allowed IN VARCHAR2 DEFAULT 'N',
85   p_message_name   OUT NOCOPY  VARCHAR2)
86 RETURN BOOLEAN;
87 
88 END IGS_AD_VAL_ACA;