1 package IGS_EN_STDNTPSHECSOP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSEI17S.pls 115.3 2002/11/28 23:35:30 nsidana ship $ */
3 -- Added for mutation package
4
5 cst_error CONSTANT VARCHAR2(1) DEFAULT 'E';
6
7 procedure INSERT_ROW (
8 X_ROWID in out NOCOPY VARCHAR2,
9 X_PERSON_ID in NUMBER,
10 X_COURSE_CD in VARCHAR2,
11 X_START_DT in out NOCOPY DATE,
12 X_END_DT in DATE,
13 X_HECS_PAYMENT_OPTION in VARCHAR2,
14 X_DIFFERENTIAL_HECS_IND in VARCHAR2,
15 X_DIFF_HECS_IND_UPDATE_WHO in VARCHAR2,
16 X_DIFF_HECS_IND_UPDATE_ON in DATE,
17 X_OUTSIDE_AUS_RES_IND in VARCHAR2,
18 X_NZ_CITIZEN_IND in VARCHAR2,
19 X_NZ_CITIZEN_LESS2YR_IND in VARCHAR2,
20 X_NZ_CITIZEN_NOT_RES_IND in VARCHAR2,
21 X_SAFETY_NET_IND in VARCHAR2,
22 X_TAX_FILE_NUMBER in NUMBER,
23 X_TAX_FILE_NUMBER_COLLECTED_DT in DATE,
24 X_TAX_FILE_INVALID_DT in DATE,
25 X_TAX_FILE_CERTIFICATE_NUMBER in NUMBER,
26 X_DIFF_HECS_IND_UPDATE_COMMENT in VARCHAR2,
27 X_MODE in VARCHAR2 default 'R'
28 );
29 procedure LOCK_ROW (
30 X_ROWID in VARCHAR2,
31 X_PERSON_ID in NUMBER,
32 X_COURSE_CD in VARCHAR2,
33 X_START_DT in DATE,
34 X_END_DT in DATE,
35 X_HECS_PAYMENT_OPTION in VARCHAR2,
36 X_DIFFERENTIAL_HECS_IND in VARCHAR2,
37 X_DIFF_HECS_IND_UPDATE_WHO in VARCHAR2,
38 X_DIFF_HECS_IND_UPDATE_ON in DATE,
39 X_OUTSIDE_AUS_RES_IND in VARCHAR2,
40 X_NZ_CITIZEN_IND in VARCHAR2,
41 X_NZ_CITIZEN_LESS2YR_IND in VARCHAR2,
42 X_NZ_CITIZEN_NOT_RES_IND in VARCHAR2,
43 X_SAFETY_NET_IND in VARCHAR2,
44 X_TAX_FILE_NUMBER in NUMBER,
45 X_TAX_FILE_NUMBER_COLLECTED_DT in DATE,
46 X_TAX_FILE_INVALID_DT in DATE,
47 X_TAX_FILE_CERTIFICATE_NUMBER in NUMBER,
48 X_DIFF_HECS_IND_UPDATE_COMMENT in VARCHAR2
49 );
50 procedure UPDATE_ROW (
51 X_ROWID in VARCHAR2,
52 X_PERSON_ID in NUMBER,
53 X_COURSE_CD in VARCHAR2,
54 X_START_DT in DATE,
55 X_END_DT in DATE,
56 X_HECS_PAYMENT_OPTION in VARCHAR2,
57 X_DIFFERENTIAL_HECS_IND in VARCHAR2,
58 X_DIFF_HECS_IND_UPDATE_WHO in VARCHAR2,
59 X_DIFF_HECS_IND_UPDATE_ON in DATE,
60 X_OUTSIDE_AUS_RES_IND in VARCHAR2,
61 X_NZ_CITIZEN_IND in VARCHAR2,
62 X_NZ_CITIZEN_LESS2YR_IND in VARCHAR2,
63 X_NZ_CITIZEN_NOT_RES_IND in VARCHAR2,
64 X_SAFETY_NET_IND in VARCHAR2,
65 X_TAX_FILE_NUMBER in NUMBER,
66 X_TAX_FILE_NUMBER_COLLECTED_DT in DATE,
67 X_TAX_FILE_INVALID_DT in DATE,
68 X_TAX_FILE_CERTIFICATE_NUMBER in NUMBER,
69 X_DIFF_HECS_IND_UPDATE_COMMENT in VARCHAR2,
70 X_MODE in VARCHAR2 default 'R'
71 );
72 procedure ADD_ROW (
73 X_ROWID in out NOCOPY VARCHAR2,
74 X_PERSON_ID in NUMBER,
75 X_COURSE_CD in VARCHAR2,
76 X_START_DT in out NOCOPY DATE,
77 X_END_DT in DATE,
78 X_HECS_PAYMENT_OPTION in VARCHAR2,
79 X_DIFFERENTIAL_HECS_IND in VARCHAR2,
80 X_DIFF_HECS_IND_UPDATE_WHO in VARCHAR2,
81 X_DIFF_HECS_IND_UPDATE_ON in DATE,
82 X_OUTSIDE_AUS_RES_IND in VARCHAR2,
83 X_NZ_CITIZEN_IND in VARCHAR2,
84 X_NZ_CITIZEN_LESS2YR_IND in VARCHAR2,
85 X_NZ_CITIZEN_NOT_RES_IND in VARCHAR2,
86 X_SAFETY_NET_IND in VARCHAR2,
87 X_TAX_FILE_NUMBER in NUMBER,
88 X_TAX_FILE_NUMBER_COLLECTED_DT in DATE,
89 X_TAX_FILE_INVALID_DT in DATE,
90 X_TAX_FILE_CERTIFICATE_NUMBER in NUMBER,
91 X_DIFF_HECS_IND_UPDATE_COMMENT in VARCHAR2,
92 X_MODE in VARCHAR2 default 'R'
93 );
94 procedure DELETE_ROW (
95 X_ROWID in VARCHAR2
96 );
97 FUNCTION Get_PK_For_Validation (
98 x_person_id IN NUMBER,
99 x_course_cd IN VARCHAR2,
100 x_start_dt IN DATE
101 )
102 RETURN BOOLEAN;
103
104 PROCEDURE GET_FK_IGS_FI_HECS_PAY_OPTN (
105 x_hecs_payment_option IN VARCHAR2
106 );
107
108 PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
109 x_person_id IN NUMBER,
110 x_course_cd IN VARCHAR2
111 );
112
113 procedure Check_constraints(
114 column_name IN VARCHAR2 DEFAULT NULL,
115 column_value IN VARCHAR2 DEFAULT NULL
116 );
117 PROCEDURE Before_DML (
118 p_action IN VARCHAR2,
119 x_rowid IN VARCHAR2 DEFAULT NULL,
120 x_person_id IN NUMBER DEFAULT NULL,
121 x_course_cd IN VARCHAR2 DEFAULT NULL,
122 x_start_dt IN DATE DEFAULT NULL,
123 x_end_dt IN DATE DEFAULT NULL,
124 x_hecs_payment_option IN VARCHAR2 DEFAULT NULL,
125 x_differential_hecs_ind IN VARCHAR2 DEFAULT NULL,
126 x_diff_hecs_ind_update_who IN VARCHAR2 DEFAULT NULL,
127 x_diff_hecs_ind_update_on IN DATE DEFAULT NULL,
128 x_outside_aus_res_ind IN VARCHAR2 DEFAULT NULL,
129 x_nz_citizen_ind IN VARCHAR2 DEFAULT NULL,
130 x_nz_citizen_less2yr_ind IN VARCHAR2 DEFAULT NULL,
131 x_nz_citizen_not_res_ind IN VARCHAR2 DEFAULT NULL,
132 x_safety_net_ind IN VARCHAR2 DEFAULT NULL,
133 x_tax_file_number IN NUMBER DEFAULT NULL,
134 x_tax_file_number_collected_dt IN DATE DEFAULT NULL,
135 x_tax_file_invalid_dt IN DATE DEFAULT NULL,
136 x_tax_file_certificate_number IN NUMBER DEFAULT NULL,
137 x_diff_hecs_ind_update_comment IN VARCHAR2 DEFAULT NULL,
138 x_creation_date IN DATE DEFAULT NULL,
139 x_created_by IN NUMBER DEFAULT NULL,
140 x_last_update_date IN DATE DEFAULT NULL,
141 x_last_updated_by IN NUMBER DEFAULT NULL,
142 x_last_update_login IN NUMBER DEFAULT NULL
143 );
144 end IGS_EN_STDNTPSHECSOP_PKG;