1 PACKAGE igs_ad_unit_sets_pkg AS
2 /* $Header: IGSAI98S.pls 120.1 2006/05/30 11:41:49 pbondugu noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 x_UNIT_SET_ID IN OUT NOCOPY NUMBER,
7 x_PERSON_ID IN NUMBER,
8 x_ADMISSION_APPL_NUMBER IN NUMBER,
9 x_NOMINATED_COURSE_CD IN VARCHAR2,
10 x_SEQUENCE_NUMBER IN NUMBER,
11 x_UNIT_SET_CD IN VARCHAR2,
12 x_VERSION_NUMBER IN NUMBER,
13 x_RANK IN NUMBER,
14 X_MODE in VARCHAR2 default 'R'
15 );
16
17 procedure LOCK_ROW (
18 X_ROWID in VARCHAR2,
19 x_UNIT_SET_ID IN NUMBER,
20 x_PERSON_ID IN NUMBER,
21 x_ADMISSION_APPL_NUMBER IN NUMBER,
22 x_NOMINATED_COURSE_CD IN VARCHAR2,
23 x_SEQUENCE_NUMBER IN NUMBER,
24 x_UNIT_SET_CD IN VARCHAR2,
25 x_VERSION_NUMBER IN NUMBER,
26 x_RANK IN NUMBER
27 );
28
29 procedure UPDATE_ROW (
30 X_ROWID in VARCHAR2,
31 x_UNIT_SET_ID IN NUMBER,
32 x_PERSON_ID IN NUMBER,
33 x_ADMISSION_APPL_NUMBER IN NUMBER,
34 x_NOMINATED_COURSE_CD IN VARCHAR2,
35 x_SEQUENCE_NUMBER IN NUMBER,
36 x_UNIT_SET_CD IN VARCHAR2,
37 x_VERSION_NUMBER IN NUMBER,
38 x_RANK IN NUMBER,
39 X_MODE in VARCHAR2 default 'R'
40 );
41
42 procedure ADD_ROW (
43 X_ROWID in out NOCOPY VARCHAR2,
44 x_UNIT_SET_ID IN OUT NOCOPY NUMBER,
45 x_PERSON_ID IN NUMBER,
46 x_ADMISSION_APPL_NUMBER IN NUMBER,
47 x_NOMINATED_COURSE_CD IN VARCHAR2,
48 x_SEQUENCE_NUMBER IN NUMBER,
49 x_UNIT_SET_CD IN VARCHAR2,
50 x_VERSION_NUMBER IN NUMBER,
51 x_RANK IN NUMBER,
52 X_MODE in VARCHAR2 default 'R'
53 );
54
55 procedure DELETE_ROW (
56 X_ROWID in VARCHAR2,
57 x_mode IN VARCHAR2 DEFAULT 'R'
58 );
59
60 FUNCTION Get_PK_For_Validation (
61 x_unit_set_id IN NUMBER
62 ) RETURN BOOLEAN ;
63
64 FUNCTION Get_UK_For_Validation (
65 x_sequence_number IN NUMBER,
66 x_unit_set_cd IN VARCHAR2,
67 x_version_number IN NUMBER,
68 x_admission_appl_number IN NUMBER,
69 x_nominated_course_cd IN VARCHAR2,
70 x_person_id IN NUMBER
71 ) RETURN BOOLEAN;
72
73 PROCEDURE Get_FK_Igs_Ad_Ps_Appl_Inst (
74 x_person_id IN NUMBER,
75 x_admission_appl_number IN NUMBER,
76 x_nominated_course_cd IN VARCHAR2,
77 x_sequence_number IN NUMBER
78 );
79
80 PROCEDURE Get_FK_Igs_En_Unit_Set (
81 x_UNIT_SET_CD IN VARCHAR2,
82 x_VERSION_NUMBER IN NUMBER
83 );
84
85 PROCEDURE Check_Constraints (
86 Column_Name IN VARCHAR2 DEFAULT NULL,
87 Column_Value IN VARCHAR2 DEFAULT NULL
88 );
89
90 PROCEDURE Before_DML (
91 p_action IN VARCHAR2,
92 x_rowid IN VARCHAR2 DEFAULT NULL,
93 x_unit_set_id IN NUMBER DEFAULT NULL,
94 x_person_id IN NUMBER DEFAULT NULL,
95 x_admission_appl_number IN NUMBER DEFAULT NULL,
96 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
97 x_sequence_number IN NUMBER DEFAULT NULL,
98 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
99 x_version_number IN NUMBER DEFAULT NULL,
100 x_rank IN NUMBER DEFAULT NULL,
101 x_creation_date IN DATE DEFAULT NULL,
102 x_created_by IN NUMBER DEFAULT NULL,
103 x_last_update_date IN DATE DEFAULT NULL,
104 x_last_updated_by IN NUMBER DEFAULT NULL,
105 x_last_update_login IN NUMBER DEFAULT NULL
106 );
107 PROCEDURE GET_FK_IGS_PS_OFR_UNIT_SET (
108 x_unit_set_cd IN VARCHAR2,
109 x_version_number IN NUMBER,
110 x_course_cd VARCHAR2,
111 x_crv_version_number NUMBER,
112 x_acad_cal_type VARCHAR2
113 );
114 FUNCTION Validate_Unit_Set(p_version_number igs_ad_unit_sets.version_number%TYPE
115 ,p_unit_set_cd igs_ad_unit_sets.unit_set_cd%TYPE
116 ,p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
117 ,p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE
118 ,p_admission_cat igs_ad_appl_all.admission_cat%TYPE
119 ,p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE
120 ,p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE
121 ,p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE
122 ,p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE
123 ) RETURN BOOLEAN;
124
125 END igs_ad_unit_sets_pkg;