1 package IGS_RE_THS_PNL_MBR_PKG as
2 /* $Header: IGSRI21S.pls 120.0 2005/06/01 15:26:01 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_CA_PERSON_ID in NUMBER,
6 X_CA_SEQUENCE_NUMBER in NUMBER,
7 X_THE_SEQUENCE_NUMBER in NUMBER,
8 X_CREATION_DT in DATE,
9 X_PERSON_ID in NUMBER,
10 X_PANEL_MEMBER_TYPE in VARCHAR2,
11 X_CONFIRMED_DT in DATE,
12 X_DECLINED_DT in DATE,
13 X_ANONYMITY_IND in VARCHAR2,
14 X_THESIS_RESULT_CD in VARCHAR2,
15 X_PAID_DT in DATE,
16 X_TRACKING_ID in NUMBER,
17 X_RECOMMENDATION_SUMMARY in VARCHAR2,
18 X_MODE in VARCHAR2 default 'R'
19 );
20 procedure LOCK_ROW (
21 X_ROWID in VARCHAR2,
22 X_CA_PERSON_ID in NUMBER,
23 X_CA_SEQUENCE_NUMBER in NUMBER,
24 X_THE_SEQUENCE_NUMBER in NUMBER,
25 X_CREATION_DT in DATE,
26 X_PERSON_ID in NUMBER,
27 X_PANEL_MEMBER_TYPE in VARCHAR2,
28 X_CONFIRMED_DT in DATE,
29 X_DECLINED_DT in DATE,
30 X_ANONYMITY_IND in VARCHAR2,
31 X_THESIS_RESULT_CD in VARCHAR2,
32 X_PAID_DT in DATE,
33 X_TRACKING_ID in NUMBER,
34 X_RECOMMENDATION_SUMMARY in VARCHAR2
35 );
36 procedure UPDATE_ROW (
37 X_ROWID in VARCHAR2,
38 X_CA_PERSON_ID in NUMBER,
39 X_CA_SEQUENCE_NUMBER in NUMBER,
40 X_THE_SEQUENCE_NUMBER in NUMBER,
41 X_CREATION_DT in DATE,
42 X_PERSON_ID in NUMBER,
43 X_PANEL_MEMBER_TYPE in VARCHAR2,
44 X_CONFIRMED_DT in DATE,
45 X_DECLINED_DT in DATE,
46 X_ANONYMITY_IND in VARCHAR2,
47 X_THESIS_RESULT_CD in VARCHAR2,
48 X_PAID_DT in DATE,
49 X_TRACKING_ID in NUMBER,
50 X_RECOMMENDATION_SUMMARY in VARCHAR2,
51 X_MODE in VARCHAR2 default 'R'
52 );
53 procedure ADD_ROW (
54 X_ROWID in out NOCOPY VARCHAR2,
55 X_CA_PERSON_ID in NUMBER,
56 X_CA_SEQUENCE_NUMBER in NUMBER,
57 X_THE_SEQUENCE_NUMBER in NUMBER,
58 X_CREATION_DT in DATE,
59 X_PERSON_ID in NUMBER,
60 X_PANEL_MEMBER_TYPE in VARCHAR2,
61 X_CONFIRMED_DT in DATE,
62 X_DECLINED_DT in DATE,
63 X_ANONYMITY_IND in VARCHAR2,
64 X_THESIS_RESULT_CD in VARCHAR2,
65 X_PAID_DT in DATE,
66 X_TRACKING_ID in NUMBER,
67 X_RECOMMENDATION_SUMMARY in VARCHAR2,
68 X_MODE in VARCHAR2 default 'R'
69 );
70 procedure DELETE_ROW (
71 X_ROWID in VARCHAR2,
72 x_mode IN VARCHAR2 DEFAULT 'R'
73 );
74
75 FUNCTION Get_PK_For_Validation (
76 x_ca_person_id IN NUMBER,
77 x_ca_sequence_number IN NUMBER,
78 x_the_sequence_number IN NUMBER,
79 x_creation_dt IN DATE,
80 x_person_id IN NUMBER
81 )RETURN BOOLEAN ;
82
83 PROCEDURE Check_Constraints(
84 Column_Name IN VARCHAR2 DEFAULT NULL,
85 Column_Value IN VARCHAR2 DEFAULT NULL
86 );
87
88 PROCEDURE Before_DML (
89 p_action IN VARCHAR2,
90 x_rowid IN VARCHAR2 DEFAULT NULL,
91 x_ca_person_id IN NUMBER DEFAULT NULL,
92 x_ca_sequence_number IN NUMBER DEFAULT NULL,
93 x_the_sequence_number IN NUMBER DEFAULT NULL,
94 x_creation_dt IN DATE DEFAULT NULL,
95 x_person_id IN NUMBER DEFAULT NULL,
96 x_panel_member_type IN VARCHAR2 DEFAULT NULL,
97 x_confirmed_dt IN DATE DEFAULT NULL,
98 x_declined_dt IN DATE DEFAULT NULL,
99 x_anonymity_ind IN VARCHAR2 DEFAULT NULL,
100 x_thesis_result_cd IN VARCHAR2 DEFAULT NULL,
101 x_paid_dt IN DATE DEFAULT NULL,
102 x_tracking_id IN NUMBER DEFAULT NULL,
103 x_recommendation_summary IN VARCHAR2 DEFAULT NULL,
104 x_creation_date IN DATE DEFAULT NULL,
105 x_created_by IN NUMBER DEFAULT NULL,
106 x_last_update_date IN DATE DEFAULT NULL,
107 x_last_updated_by IN NUMBER DEFAULT NULL,
108 x_last_update_login IN NUMBER DEFAULT NULL
109 ) ;
110
111 PROCEDURE GET_FK_IGS_PE_PERSON (
112 x_person_id IN NUMBER
113 );
114
115 PROCEDURE GET_FK_IGS_RE_THESIS_EXAM (
116 x_person_id IN NUMBER,
117 x_ca_sequence_number IN NUMBER,
118 x_the_sequence_number IN NUMBER,
119 x_creation_dt IN DATE
120 );
121
122 PROCEDURE GET_FK_IGS_RE_THESIS_RESULT (
123 x_thesis_result_cd IN VARCHAR2
124 );
125
126 PROCEDURE GET_FK_IGS_RE_THS_PNL_MR_TP (
127 x_panel_member_type IN VARCHAR2
128 );
129
130
131 end IGS_RE_THS_PNL_MBR_PKG;