1 package IGS_RE_THESIS_HIST_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSRI17S.pls 115.4 2002/11/29 03:36:19 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PERSON_ID in NUMBER,
6 X_CA_SEQUENCE_NUMBER in NUMBER,
7 X_SEQUENCE_NUMBER in NUMBER,
8 X_HIST_START_DT in DATE,
9 X_HIST_END_DT in DATE,
10 X_HIST_WHO in NUMBER,
11 X_TITLE in VARCHAR2,
12 X_FINAL_TITLE_IND in VARCHAR2,
13 X_SHORT_TITLE in VARCHAR2,
14 X_ABBREVIATED_TITLE in VARCHAR2,
15 X_THESIS_RESULT_CD in VARCHAR2,
16 X_EXPECTED_SUBMISSION_DT in DATE,
17 X_DATE_OF_LIBRARY_LODGEMENT in DATE,
18 X_LIBRARY_CATALOGUE_NUMBER in VARCHAR2,
19 X_EMBARGO_EXPIRY_DT in DATE,
20 X_THESIS_FORMAT in VARCHAR2,
21 X_LOGICAL_DELETE_DT in DATE,
22 X_EMBARGO_DETAILS in VARCHAR2,
23 X_THESIS_TOPIC in VARCHAR2,
24 X_CITATION in VARCHAR2,
25 X_COMMENTS in VARCHAR2,
26 X_MODE in VARCHAR2 default 'R' ,
27 X_ORG_ID in NUMBER
28 );
29 procedure LOCK_ROW (
30 X_ROWID in VARCHAR2,
31 X_PERSON_ID in NUMBER,
32 X_CA_SEQUENCE_NUMBER in NUMBER,
33 X_SEQUENCE_NUMBER in NUMBER,
34 X_HIST_START_DT in DATE,
35 X_HIST_END_DT in DATE,
36 X_HIST_WHO in NUMBER,
37 X_TITLE in VARCHAR2,
38 X_FINAL_TITLE_IND in VARCHAR2,
39 X_SHORT_TITLE in VARCHAR2,
40 X_ABBREVIATED_TITLE in VARCHAR2,
41 X_THESIS_RESULT_CD in VARCHAR2,
42 X_EXPECTED_SUBMISSION_DT in DATE,
43 X_DATE_OF_LIBRARY_LODGEMENT in DATE,
44 X_LIBRARY_CATALOGUE_NUMBER in VARCHAR2,
45 X_EMBARGO_EXPIRY_DT in DATE,
46 X_THESIS_FORMAT in VARCHAR2,
47 X_LOGICAL_DELETE_DT in DATE,
48 X_EMBARGO_DETAILS in VARCHAR2,
49 X_THESIS_TOPIC in VARCHAR2,
50 X_CITATION in VARCHAR2,
51 X_COMMENTS in VARCHAR2
52 );
53 procedure UPDATE_ROW (
54 X_ROWID in VARCHAR2,
55 X_PERSON_ID in NUMBER,
56 X_CA_SEQUENCE_NUMBER in NUMBER,
57 X_SEQUENCE_NUMBER in NUMBER,
58 X_HIST_START_DT in DATE,
59 X_HIST_END_DT in DATE,
60 X_HIST_WHO in NUMBER,
61 X_TITLE in VARCHAR2,
62 X_FINAL_TITLE_IND in VARCHAR2,
63 X_SHORT_TITLE in VARCHAR2,
64 X_ABBREVIATED_TITLE in VARCHAR2,
65 X_THESIS_RESULT_CD in VARCHAR2,
66 X_EXPECTED_SUBMISSION_DT in DATE,
67 X_DATE_OF_LIBRARY_LODGEMENT in DATE,
68 X_LIBRARY_CATALOGUE_NUMBER in VARCHAR2,
69 X_EMBARGO_EXPIRY_DT in DATE,
70 X_THESIS_FORMAT in VARCHAR2,
71 X_LOGICAL_DELETE_DT in DATE,
72 X_EMBARGO_DETAILS in VARCHAR2,
73 X_THESIS_TOPIC in VARCHAR2,
74 X_CITATION in VARCHAR2,
75 X_COMMENTS in VARCHAR2,
76 X_MODE in VARCHAR2 default 'R'
77 );
78 procedure ADD_ROW (
79 X_ROWID in out NOCOPY VARCHAR2,
80 X_PERSON_ID in NUMBER,
81 X_CA_SEQUENCE_NUMBER in NUMBER,
82 X_SEQUENCE_NUMBER in NUMBER,
83 X_HIST_START_DT in DATE,
84 X_HIST_END_DT in DATE,
85 X_HIST_WHO in NUMBER,
86 X_TITLE in VARCHAR2,
87 X_FINAL_TITLE_IND in VARCHAR2,
88 X_SHORT_TITLE in VARCHAR2,
89 X_ABBREVIATED_TITLE in VARCHAR2,
90 X_THESIS_RESULT_CD in VARCHAR2,
91 X_EXPECTED_SUBMISSION_DT in DATE,
92 X_DATE_OF_LIBRARY_LODGEMENT in DATE,
93 X_LIBRARY_CATALOGUE_NUMBER in VARCHAR2,
94 X_EMBARGO_EXPIRY_DT in DATE,
95 X_THESIS_FORMAT in VARCHAR2,
96 X_LOGICAL_DELETE_DT in DATE,
97 X_EMBARGO_DETAILS in VARCHAR2,
98 X_THESIS_TOPIC in VARCHAR2,
99 X_CITATION in VARCHAR2,
100 X_COMMENTS in VARCHAR2,
101 X_MODE in VARCHAR2 default 'R',
102 X_ORG_ID in NUMBER
103 );
104 procedure DELETE_ROW (
105 X_ROWID in VARCHAR2
106 );
107
108 FUNCTION Get_PK_For_Validation (
109 x_person_id IN NUMBER,
110 x_ca_sequence_number IN NUMBER,
111 x_sequence_number IN NUMBER,
112 x_hist_start_dt IN DATE
113 )
114 RETURN BOOLEAN;
115
116 PROCEDURE Check_Constraints (
117 Column_Name in VARCHAR2 DEFAULT NULL ,
118 Column_Value in VARCHAR2 DEFAULT NULL
119 ) ;
120
121 PROCEDURE Before_DML (
122 p_action IN VARCHAR2,
123 x_rowid IN VARCHAR2 DEFAULT NULL,
124 x_person_id IN NUMBER DEFAULT NULL,
125 x_ca_sequence_number IN NUMBER DEFAULT NULL,
126 x_sequence_number IN NUMBER DEFAULT NULL,
127 x_hist_start_dt IN DATE DEFAULT NULL,
128 x_hist_end_dt IN DATE DEFAULT NULL,
129 x_hist_who IN NUMBER DEFAULT NULL,
130 x_title IN VARCHAR2 DEFAULT NULL,
131 x_final_title_ind IN VARCHAR2 DEFAULT NULL,
132 x_short_title IN VARCHAR2 DEFAULT NULL,
133 x_abbreviated_title IN VARCHAR2 DEFAULT NULL,
134 x_thesis_result_cd IN VARCHAR2 DEFAULT NULL,
135 x_expected_submission_dt IN DATE DEFAULT NULL,
136 x_date_of_library_lodgement IN DATE DEFAULT NULL,
137 x_library_catalogue_number IN VARCHAR2 DEFAULT NULL,
138 x_embargo_expiry_dt IN DATE DEFAULT NULL,
139 x_thesis_format IN VARCHAR2 DEFAULT NULL,
140 x_logical_delete_dt IN DATE DEFAULT NULL,
141 x_embargo_details IN VARCHAR2 DEFAULT NULL,
142 x_thesis_topic IN VARCHAR2 DEFAULT NULL,
143 x_citation IN VARCHAR2 DEFAULT NULL,
144 x_comments IN VARCHAR2 DEFAULT NULL,
145 x_creation_date IN DATE DEFAULT NULL,
146 x_created_by IN NUMBER DEFAULT NULL,
147 x_last_update_date IN DATE DEFAULT NULL,
148 x_last_updated_by IN NUMBER DEFAULT NULL,
149 x_last_update_login IN NUMBER DEFAULT NULL,
150 X_ORG_ID in NUMBER DEFAULT NULL
151 );
152
153
154 end IGS_RE_THESIS_HIST_PKG;