1 package IGS_PS_ENT_PT_REF_CD_PKG AS
2 /* $Header: IGSPI10S.pls 120.1 2006/05/29 07:29:08 sarakshi noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_COURSE_CD in VARCHAR2,
7 X_SEQUENCE_NUMBER in NUMBER,
8 X_REFERENCE_CD_TYPE in VARCHAR2,
9 X_ATTENDANCE_TYPE in VARCHAR2,
10 X_CAL_TYPE in VARCHAR2,
11 X_LOCATION_CD in VARCHAR2,
12 X_VERSION_NUMBER in NUMBER,
13 X_ATTENDANCE_MODE in VARCHAR2,
14 X_COO_ID in NUMBER,
15 X_UNIT_SET_CD in VARCHAR2,
16 X_US_VERSION_NUMBER in NUMBER,
17 X_REFERENCE_CD in VARCHAR2,
18 X_DESCRIPTION in VARCHAR2,
19 X_MODE in VARCHAR2 default 'R'
20 );
21 procedure LOCK_ROW (
22 X_ROWID IN VARCHAR2,
23 X_COURSE_CD in VARCHAR2,
24 X_SEQUENCE_NUMBER in NUMBER,
25 X_REFERENCE_CD_TYPE in VARCHAR2,
26 X_ATTENDANCE_TYPE in VARCHAR2,
27 X_CAL_TYPE in VARCHAR2,
28 X_LOCATION_CD in VARCHAR2,
29 X_VERSION_NUMBER in NUMBER,
30 X_ATTENDANCE_MODE in VARCHAR2,
31 X_COO_ID in NUMBER,
32 X_UNIT_SET_CD in VARCHAR2,
33 X_US_VERSION_NUMBER in NUMBER,
34 X_REFERENCE_CD in VARCHAR2,
35 X_DESCRIPTION in VARCHAR2
36 );
37 procedure UPDATE_ROW (
38 X_ROWID IN VARCHAR2,
39 X_COURSE_CD in VARCHAR2,
40 X_SEQUENCE_NUMBER in NUMBER,
41 X_REFERENCE_CD_TYPE in VARCHAR2,
42 X_ATTENDANCE_TYPE in VARCHAR2,
43 X_CAL_TYPE in VARCHAR2,
44 X_LOCATION_CD in VARCHAR2,
45 X_VERSION_NUMBER in NUMBER,
46 X_ATTENDANCE_MODE in VARCHAR2,
47 X_COO_ID in NUMBER,
48 X_UNIT_SET_CD in VARCHAR2,
49 X_US_VERSION_NUMBER in NUMBER,
50 X_REFERENCE_CD in VARCHAR2,
51 X_DESCRIPTION in VARCHAR2,
52 X_MODE in VARCHAR2 default 'R'
53 );
54 procedure ADD_ROW (
55 X_ROWID in out NOCOPY VARCHAR2,
56 X_COURSE_CD in VARCHAR2,
57 X_SEQUENCE_NUMBER in NUMBER,
58 X_REFERENCE_CD_TYPE in VARCHAR2,
59 X_ATTENDANCE_TYPE in VARCHAR2,
60 X_CAL_TYPE in VARCHAR2,
61 X_LOCATION_CD in VARCHAR2,
62 X_VERSION_NUMBER in NUMBER,
63 X_ATTENDANCE_MODE in VARCHAR2,
64 X_COO_ID in NUMBER,
65 X_UNIT_SET_CD in VARCHAR2,
66 X_US_VERSION_NUMBER in NUMBER,
67 X_REFERENCE_CD in VARCHAR2,
68 X_DESCRIPTION in VARCHAR2,
69 X_MODE in VARCHAR2 default 'R'
70 );
71 procedure DELETE_ROW (
72 X_ROWID in VARCHAR2
73 );
74
75 FUNCTION Get_PK_For_Validation (
76 x_course_cd IN VARCHAR2,
77 x_version_number IN NUMBER,
78 x_cal_type IN VARCHAR2,
79 x_location_cd IN VARCHAR2,
80 x_attendance_mode IN VARCHAR2,
81 x_attendance_type IN VARCHAR2,
82 x_reference_cd_type IN VARCHAR2,
83 x_sequence_number IN NUMBER )
84 RETURN BOOLEAN;
85
86 PROCEDURE GET_FK_IGS_PS_OFR_OPT (
87 x_course_cd IN VARCHAR2,
88 x_version_number IN NUMBER,
89 x_cal_type IN VARCHAR2,
90 x_location_cd IN VARCHAR2,
91 x_attendance_mode IN VARCHAR2,
92 x_attendance_type IN VARCHAR2
93 );
94
95 PROCEDURE GET_UFK_IGS_PS_OFR_OPT (
96 x_coo_id IN NUMBER
97 );
98
99 PROCEDURE GET_FK_IGS_GE_REF_CD_TYPE (
100 x_reference_cd_type IN VARCHAR2
101 );
102
103 PROCEDURE GET_FK_IGS_EN_UNIT_SET (
104 x_unit_set_cd IN VARCHAR2,
105 x_version_number IN NUMBER
106 );
107
108 PROCEDURE GET_FK_IGS_PS_OFR_UNIT_SET (
109 x_course_cd IN VARCHAR2,
110 x_version_number IN NUMBER,
111 x_cal_type IN VARCHAR2,
112 x_unit_set_cd IN VARCHAR2,
113 x_us_version_number IN NUMBER
114 );
115
116 PROCEDURE GET_UFK_IGS_GE_REF_CD (
117 x_reference_cd_type IN VARCHAR2,
118 x_reference_cd IN VARCHAR2);
119
120 PROCEDURE Check_Constraints (
121 Column_Name IN VARCHAR2 DEFAULT NULL,
122 Column_Value IN VARCHAR2 DEFAULT NULL
123 );
124
125 PROCEDURE Before_DML (
126 p_action IN VARCHAR2,
127 x_rowid IN VARCHAR2 DEFAULT NULL,
128 x_course_cd IN VARCHAR2 DEFAULT NULL,
129 x_version_number IN NUMBER DEFAULT NULL,
130 x_cal_type IN VARCHAR2 DEFAULT NULL,
131 x_location_cd IN VARCHAR2 DEFAULT NULL,
132 x_attendance_mode IN VARCHAR2 DEFAULT NULL,
133 x_attendance_type IN VARCHAR2 DEFAULT NULL,
134 x_reference_cd_type IN VARCHAR2 DEFAULT NULL,
135 x_sequence_number IN NUMBER DEFAULT NULL,
136 x_coo_id IN NUMBER DEFAULT NULL,
137 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
138 x_us_version_number IN NUMBER DEFAULT NULL,
139 x_reference_cd IN VARCHAR2 DEFAULT NULL,
140 x_description IN VARCHAR2 DEFAULT NULL,
141 x_creation_date IN DATE DEFAULT NULL,
142 x_created_by IN NUMBER DEFAULT NULL,
143 x_last_update_date IN DATE DEFAULT NULL,
144 x_last_updated_by IN NUMBER DEFAULT NULL,
145 x_last_update_login IN NUMBER DEFAULT NULL
146 ) ;
147
148 end IGS_PS_ENT_PT_REF_CD_PKG;