1 package IGS_AD_OS_SEC_EDU_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI42S.pls 115.3 2002/11/28 22:05:36 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PERSON_ID in NUMBER,
6 X_SEQUENCE_NUMBER in NUMBER,
7 X_RESULT_OBTAINED_YR in NUMBER,
8 X_OS_SCNDRY_EDU_QUALIFICATION in VARCHAR2,
9 X_RESULT in VARCHAR2,
10 X_CANDIDATE_NUMBER in NUMBER,
11 X_SCHOOL_NAME in VARCHAR2,
12 X_COUNTRY_CD in VARCHAR2,
13 X_COMMENTS in VARCHAR2,
14 X_MODE in VARCHAR2 default 'R'
15 );
16 procedure LOCK_ROW (
17 X_ROWID in VARCHAR2,
18 X_PERSON_ID in NUMBER,
19 X_SEQUENCE_NUMBER in NUMBER,
20 X_RESULT_OBTAINED_YR in NUMBER,
21 X_OS_SCNDRY_EDU_QUALIFICATION in VARCHAR2,
22 X_RESULT in VARCHAR2,
23 X_CANDIDATE_NUMBER in NUMBER,
24 X_SCHOOL_NAME in VARCHAR2,
25 X_COUNTRY_CD in VARCHAR2,
26 X_COMMENTS in VARCHAR2
27 );
28 procedure UPDATE_ROW (
29 X_ROWID in VARCHAR2,
30 X_PERSON_ID in NUMBER,
31 X_SEQUENCE_NUMBER in NUMBER,
32 X_RESULT_OBTAINED_YR in NUMBER,
33 X_OS_SCNDRY_EDU_QUALIFICATION in VARCHAR2,
34 X_RESULT in VARCHAR2,
35 X_CANDIDATE_NUMBER in NUMBER,
36 X_SCHOOL_NAME in VARCHAR2,
37 X_COUNTRY_CD in VARCHAR2,
38 X_COMMENTS in VARCHAR2,
39 X_MODE in VARCHAR2 default 'R'
40 );
41 procedure ADD_ROW (
42 X_ROWID in out NOCOPY VARCHAR2,
43 X_PERSON_ID in NUMBER,
44 X_SEQUENCE_NUMBER in NUMBER,
45 X_RESULT_OBTAINED_YR in NUMBER,
46 X_OS_SCNDRY_EDU_QUALIFICATION in VARCHAR2,
47 X_RESULT in VARCHAR2,
48 X_CANDIDATE_NUMBER in NUMBER,
49 X_SCHOOL_NAME in VARCHAR2,
50 X_COUNTRY_CD in VARCHAR2,
51 X_COMMENTS in VARCHAR2,
52 X_MODE in VARCHAR2 default 'R'
53 );
54 procedure DELETE_ROW (
55 X_ROWID in VARCHAR2
56 );
57 FUNCTION Get_PK_For_Validation (
58 x_person_id IN NUMBER,
59 x_sequence_number IN NUMBER
60 )
61 RETURN BOOLEAN ;
62
63 PROCEDURE GET_FK_IGS_PE_COUNTRY_CD (
64 x_country_cd IN VARCHAR2
65 );
66
67 PROCEDURE GET_FK_IGS_AD_OS_SEC_EDU_QF (
68 x_os_scndry_edu_qualification IN VARCHAR2
69 );
70
71 PROCEDURE GET_FK_IGS_PE_PERSON (
72 x_person_id IN NUMBER
73 );
74
75 PROCEDURE Check_Constraints (
76 Column_Name IN VARCHAR2 DEFAULT NULL,
77 Column_Value IN VARCHAR2 DEFAULT NULL
78 );
79
80 PROCEDURE Before_DML (
81 p_action IN VARCHAR2,
82 x_rowid IN VARCHAR2 DEFAULT NULL,
83 x_person_id IN NUMBER DEFAULT NULL,
84 x_sequence_number IN NUMBER DEFAULT NULL,
85 x_result_obtained_yr IN NUMBER DEFAULT NULL,
86 x_os_scndry_edu_qualification IN VARCHAR2 DEFAULT NULL,
87 x_result IN VARCHAR2 DEFAULT NULL,
88 x_candidate_number IN NUMBER DEFAULT NULL,
89 x_school_name IN VARCHAR2 DEFAULT NULL,
90 x_country_cd IN VARCHAR2 DEFAULT NULL,
91 x_comments IN VARCHAR2 DEFAULT NULL,
92 x_creation_date IN DATE DEFAULT NULL,
93 x_created_by IN NUMBER DEFAULT NULL,
94 x_last_update_date IN DATE DEFAULT NULL,
95 x_last_updated_by IN NUMBER DEFAULT NULL,
96 x_last_update_login IN NUMBER DEFAULT NULL
97 ) ;
98
99
100
101 end IGS_AD_OS_SEC_EDU_PKG;