PACKAGE: APPS.IGS_AD_VAL_APCOOD

Source

1 PACKAGE IGS_AD_VAL_APCOOD AUTHID CURRENT_USER AS
2 /* $Header: IGSAD41S.pls 115.5 2002/11/28 21:32:11 nsidana ship $ */
3   -- Validate admission period calendar instance
4   -- Bug #1956374
5   -- As part of the bug# 1956374 removed the function crsp_val_loc_cd
6   -- Bug No 1956374 , Procedure admp_val_adm_ci is removed
7   -- Validate the adm period course off option date details
8   FUNCTION admp_val_apcood_opt(
9   p_course_cd IN VARCHAR2 ,
10   p_version_number IN NUMBER ,
11   p_acad_cal_type IN VARCHAR2 ,
12   p_location_cd IN VARCHAR2 ,
13   p_attendance_mode IN VARCHAR2 ,
14   p_attendance_type IN VARCHAR2 ,
15   p_adm_cal_type IN VARCHAR2 ,
16   p_adm_ci_sequence_number IN NUMBER ,
17   p_admission_cat IN VARCHAR2 ,
18   p_s_admission_process_type IN VARCHAR2 ,
19   p_message_name OUT NOCOPY VARCHAR2 )
20 RETURN BOOLEAN;
21 
22   -- Validate the adm period course off option date course offeringing
23   FUNCTION admp_val_apcood_co(
24   p_course_cd IN VARCHAR2 ,
25   p_version_number IN NUMBER ,
26   p_acad_cal_type IN VARCHAR2 ,
27   p_admission_cat IN VARCHAR2 ,
28   p_s_admission_process_type IN VARCHAR2 ,
29   p_adm_cal_type IN VARCHAR2 ,
30   p_adm_ci_sequence_number IN NUMBER ,
31   p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33   -- Validate the adm period course off option date optional components.
34   FUNCTION admp_val_apcood_link(
35   p_adm_cal_type IN VARCHAR2 ,
36   p_adm_ci_sequence_number IN NUMBER ,
37   p_admission_cat IN VARCHAR2 ,
38   p_dt_alias IN VARCHAR2 ,
39   p_dai_sequence_number IN NUMBER ,
40   p_apcood_sequence_number IN NUMBER ,
41   p_s_admission_process_type IN VARCHAR2 ,
42   p_course_cd IN VARCHAR2 ,
43   p_version_number IN NUMBER ,
44   p_acad_cal_type IN VARCHAR2 ,
45   p_location_cd IN VARCHAR2 ,
46   p_attendance_mode IN VARCHAR2 ,
47   p_attendance_type IN VARCHAR2 ,
48   p_message_name OUT NOCOPY VARCHAR2 )
49 RETURN BOOLEAN;
50 
51   -- Validate the adm period course off option date optional components.
52   FUNCTION admp_val_apcood_lnk2(
53   p_adm_cal_type IN VARCHAR2 ,
54   p_adm_ci_sequence_number IN NUMBER ,
55   p_acad_cal_type IN VARCHAR2 ,
56   p_admission_cat IN VARCHAR2 ,
57   p_dt_alias IN VARCHAR2 ,
58   p_dai_sequence_number IN NUMBER ,
59   p_apcood_sequence_number IN NUMBER ,
60   p_s_admission_process_type IN VARCHAR2 ,
61   p_course_cd IN VARCHAR2 ,
62   p_version_number IN NUMBER ,
63   p_location_cd IN VARCHAR2 ,
64   p_attendance_mode IN VARCHAR2 ,
65   p_attendance_type IN VARCHAR2 ,
66   p_db_s_admission_process_type IN VARCHAR2 ,
67   p_db_course_cd IN VARCHAR2 ,
68   p_db_version_number IN NUMBER ,
69   p_db_location_cd IN VARCHAR2 ,
70   p_db_attendance_mode IN VARCHAR2 ,
71   p_db_attendance_type IN VARCHAR2 ,
72   p_message_name OUT NOCOPY VARCHAR2 )
73 RETURN BOOLEAN;
74   -- Validate insert of adm period course off option date
75   FUNCTION admp_val_apcood_ins(
76   p_adm_cal_type IN VARCHAR2 ,
77   p_adm_ci_sequence_number IN NUMBER ,
78   p_admission_cat IN VARCHAR2 ,
79   p_dt_alias IN VARCHAR2 ,
80   p_dai_sequence_number IN NUMBER ,
81   p_apcood_sequence_number IN NUMBER ,
82   p_message_name OUT NOCOPY VARCHAR2 )
83 RETURN BOOLEAN;
84 
85   -- Validate the adm period course off option date date alias
86   FUNCTION admp_val_apcood_da(
87   p_dt_alias IN VARCHAR2 ,
88   p_message_name OUT NOCOPY VARCHAR2 )
89 RETURN BOOLEAN;
90  PRAGMA RESTRICT_REFERENCES(admp_val_apcood_da, WNDS);
91 
92 END IGS_AD_VAL_APCOOD;