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