1 package IGS_EN_CAT_PRC_STEP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSEI25S.pls 115.6 2003/06/11 06:28:14 rnirwani ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_ENROLMENT_CAT in VARCHAR2,
6 X_S_STUDENT_COMM_TYPE in VARCHAR2,
7 X_ENR_METHOD_TYPE in VARCHAR2,
8 X_S_ENROLMENT_STEP_TYPE in VARCHAR2,
9 X_STEP_ORDER_NUM in NUMBER,
10 X_MODE in VARCHAR2 default 'R',
11 x_org_id IN NUMBER
12 );
13 procedure LOCK_ROW (
14 X_ROWID in VARCHAR2,
15 X_ENROLMENT_CAT in VARCHAR2,
16 X_S_STUDENT_COMM_TYPE in VARCHAR2,
17 X_ENR_METHOD_TYPE in VARCHAR2,
18 X_S_ENROLMENT_STEP_TYPE in VARCHAR2,
19 X_STEP_ORDER_NUM in NUMBER
20 );
21 procedure UPDATE_ROW (
22 X_ROWID in VARCHAR2,
23 X_ENROLMENT_CAT in VARCHAR2,
24 X_S_STUDENT_COMM_TYPE in VARCHAR2,
25 X_ENR_METHOD_TYPE in VARCHAR2,
26 X_S_ENROLMENT_STEP_TYPE in VARCHAR2,
27 X_STEP_ORDER_NUM in NUMBER,
28 X_MODE in VARCHAR2 default 'R'
29 );
30 procedure ADD_ROW (
31 X_ROWID in out NOCOPY VARCHAR2,
32 X_ENROLMENT_CAT in VARCHAR2,
33 X_S_STUDENT_COMM_TYPE in VARCHAR2,
34 X_ENR_METHOD_TYPE in VARCHAR2,
35 X_S_ENROLMENT_STEP_TYPE in VARCHAR2,
36 X_STEP_ORDER_NUM in NUMBER,
37 X_MODE in VARCHAR2 default 'R',
38 x_org_id IN NUMBER
39 );
40 procedure DELETE_ROW (
41 X_ROWID in VARCHAR2
42 );
43 FUNCTION Get_PK_For_Validation (
44 x_enrolment_cat IN VARCHAR2,
45 x_s_student_comm_type IN VARCHAR2,
46 x_enr_method_type IN VARCHAR2,
47 x_s_enrolment_step_type IN VARCHAR2
48 )
49 RETURN BOOLEAN ;
50
51 PROCEDURE GET_FK_IGS_EN_CAT_PRC_DTL (
52 x_enrolment_cat IN VARCHAR2,
53 x_s_student_comm_type IN VARCHAR2,
54 x_enr_method_type IN VARCHAR2
55 );
56
57 PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
58 x_s_enrolment_step_type IN VARCHAR2
59 );
60 procedure Check_constraints(
61 column_name IN VARCHAR2 DEFAULT NULL,
62 column_value IN VARCHAR2 DEFAULT NULL
63 );
64 PROCEDURE Before_DML (
65 p_action IN VARCHAR2,
66 x_rowid IN VARCHAR2 DEFAULT NULL,
67 x_enrolment_cat IN VARCHAR2 DEFAULT NULL,
68 x_s_student_comm_type IN VARCHAR2 DEFAULT NULL,
69 x_enr_method_type IN VARCHAR2 DEFAULT NULL,
70 x_s_enrolment_step_type IN VARCHAR2 DEFAULT NULL,
71 x_step_order_num IN NUMBER DEFAULT NULL,
72 x_creation_date IN DATE DEFAULT NULL,
73 x_created_by IN NUMBER DEFAULT NULL,
74 x_last_update_date IN DATE DEFAULT NULL,
75 x_last_updated_by IN NUMBER DEFAULT NULL,
76 x_last_update_login IN NUMBER DEFAULT NULL,
77 x_org_id IN NUMBER DEFAULT NULL
78 );
79 end IGS_EN_CAT_PRC_STEP_PKG;