1 package IGS_OR_INST_HIST_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSOI04S.pls 115.8 2002/11/29 01:39:22 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_INSTITUTION_CD in VARCHAR2,
6 X_HIST_START_DT in DATE,
7 X_HIST_END_DT in DATE,
8 X_HIST_WHO in NUMBER,
9 X_NAME in VARCHAR2,
10
11 X_INST_PHONE_COUNTRY_CODE in VARCHAR2 ,
12 X_INST_PHONE_AREA_CODE in VARCHAR2 ,
13 X_INST_PHONE_NUMBER in VARCHAR2 ,
14 X_inst_priority_cd in VARCHAR2,
15 X_EPS_CODE in VARCHAR2 ,
16
17 X_INSTITUTION_STATUS in VARCHAR2,
18 X_LOCAL_INSTITUTION_IND in VARCHAR2,
19 X_OS_IND in VARCHAR2,
20 X_GOVT_INSTITUTION_CD in VARCHAR2,
21 X_INSTITUTION_TYPE in VARCHAR2,
22 X_DESCRIPTION in VARCHAR2,
23 X_INST_CONTROL_TYPE in VARCHAR2,
24 X_MODE in VARCHAR2 default 'R' ,
25 X_ORG_ID in NUMBER
26 );
27 procedure LOCK_ROW (
28 X_ROWID in VARCHAR2,
29 X_INSTITUTION_CD in VARCHAR2,
30 X_HIST_START_DT in DATE,
31 X_HIST_END_DT in DATE,
32 X_HIST_WHO in NUMBER,
33 X_NAME in VARCHAR2,
34
35 X_INST_PHONE_COUNTRY_CODE in VARCHAR2 ,
36 X_INST_PHONE_AREA_CODE in VARCHAR2 ,
37 X_INST_PHONE_NUMBER in VARCHAR2 ,
38 X_inst_priority_cd in VARCHAR2,
39 X_EPS_CODE in VARCHAR2 ,
40
41
42 X_INSTITUTION_STATUS in VARCHAR2,
43 X_LOCAL_INSTITUTION_IND in VARCHAR2,
44 X_OS_IND in VARCHAR2,
45 X_GOVT_INSTITUTION_CD in VARCHAR2,
46 X_INSTITUTION_TYPE in VARCHAR2,
47 X_DESCRIPTION in VARCHAR2,
48 X_INST_CONTROL_TYPE in VARCHAR2
49 );
50 procedure UPDATE_ROW (
51 X_ROWID in VARCHAR2,
52 X_INSTITUTION_CD in VARCHAR2,
53 X_HIST_START_DT in DATE,
54 X_HIST_END_DT in DATE,
55 X_HIST_WHO in NUMBER,
56 X_NAME in VARCHAR2,
57
58 X_INST_PHONE_COUNTRY_CODE in VARCHAR2 ,
59 X_INST_PHONE_AREA_CODE in VARCHAR2 ,
60 X_INST_PHONE_NUMBER in VARCHAR2 ,
61 X_inst_priority_cd in VARCHAR2,
62 X_EPS_CODE in VARCHAR2 ,
63
64 X_INSTITUTION_STATUS in VARCHAR2,
65 X_LOCAL_INSTITUTION_IND in VARCHAR2,
66 X_OS_IND in VARCHAR2,
67 X_GOVT_INSTITUTION_CD in VARCHAR2,
68 X_INSTITUTION_TYPE in VARCHAR2,
69 X_DESCRIPTION in VARCHAR2,
70 X_INST_CONTROL_TYPE in VARCHAR2,
71 X_MODE in VARCHAR2 default 'R'
72 );
73 procedure ADD_ROW (
74 X_ROWID in out NOCOPY VARCHAR2,
75 X_INSTITUTION_CD in VARCHAR2,
76 X_HIST_START_DT in DATE,
77 X_HIST_END_DT in DATE,
78 X_HIST_WHO in NUMBER,
79 X_NAME in VARCHAR2,
80
81 X_INST_PHONE_COUNTRY_CODE in VARCHAR2 ,
82 X_INST_PHONE_AREA_CODE in VARCHAR2 ,
83 X_INST_PHONE_NUMBER in VARCHAR2 ,
84 X_inst_priority_cd in VARCHAR2,
85 X_EPS_CODE in VARCHAR2 ,
86
87
88 X_INSTITUTION_STATUS in VARCHAR2,
89 X_LOCAL_INSTITUTION_IND in VARCHAR2,
90 X_OS_IND in VARCHAR2,
91 X_GOVT_INSTITUTION_CD in VARCHAR2,
92 X_INSTITUTION_TYPE in VARCHAR2,
93 X_DESCRIPTION in VARCHAR2,
94 X_INST_CONTROL_TYPE in VARCHAR2,
95 X_MODE in VARCHAR2 default 'R',
96 X_ORG_ID in NUMBER
97 );
98 procedure DELETE_ROW (
99 X_ROWID in VARCHAR2
100 );
101
102 FUNCTION Get_PK_For_Validation (
103 x_institution_cd IN VARCHAR2,
104 x_hist_start_dt IN DATE
105 ) RETURN BOOLEAN ;
106
107 PROCEDURE Before_DML (
108 p_action IN VARCHAR2,
109 x_rowid IN VARCHAR2 DEFAULT NULL,
110 x_institution_cd IN VARCHAR2 DEFAULT NULL,
111 x_hist_start_dt IN DATE DEFAULT NULL,
112 x_hist_end_dt IN DATE DEFAULT NULL,
113 x_hist_who IN VARCHAR2 DEFAULT NULL,
114 x_name IN VARCHAR2 DEFAULT NULL,
115
116
117 x_inst_phone_country_code IN VARCHAR2 DEFAULT NULL,
118 x_inst_phone_area_code IN VARCHAR2 DEFAULT NULL,
119 x_inst_phone_number IN VARCHAR2 DEFAULT NULL,
120 x_inst_priority_cd in VARCHAR2 DEFAULT NULL,
121 x_eps_code IN VARCHAR2 DEFAULT NULL,
122
123
124 x_institution_status IN VARCHAR2 DEFAULT NULL,
125 x_local_institution_ind IN VARCHAR2 DEFAULT NULL,
126 x_os_ind IN VARCHAR2 DEFAULT NULL,
127 x_govt_institution_cd IN VARCHAR2 DEFAULT NULL,
128 x_institution_type IN VARCHAR2 DEFAULT NULL,
129 x_description IN VARCHAR2 DEFAULT NULL,
130 x_inst_control_type IN VARCHAR2 DEFAULT NULL,
131 x_creation_date IN DATE DEFAULT NULL,
132 x_created_by IN NUMBER DEFAULT NULL,
133 x_last_update_date IN DATE DEFAULT NULL,
134 x_last_updated_by IN NUMBER DEFAULT NULL,
135 x_last_update_login IN NUMBER DEFAULT NULL,
136 X_ORG_ID in NUMBER DEFAULT NULL
137 ) ;
138 procedure Check_Constraints (
139 Column_Name in VARCHAR2 DEFAULT NULL ,
140 Column_Value in VARCHAR2 DEFAULT NULL
141 ) ;
142 end IGS_OR_INST_HIST_PKG;