1 package IGS_AD_AUS_SEC_EDU_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI39S.pls 115.4 2002/11/28 22:04:43 nsidana ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_PERSON_ID in NUMBER,
7 X_SEQUENCE_NUMBER in NUMBER,
8 X_STATE_CD in VARCHAR2,
9 X_RESULT_OBTAINED_YR in NUMBER,
10 X_SCORE in NUMBER,
11 X_AUS_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
12 X_CANDIDATE_NUMBER in NUMBER,
13 X_SECONDARY_SCHOOL_CD 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_STATE_CD in VARCHAR2,
21 X_RESULT_OBTAINED_YR in NUMBER,
22 X_SCORE in NUMBER,
23 X_AUS_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
24 X_CANDIDATE_NUMBER in NUMBER,
25 X_SECONDARY_SCHOOL_CD in VARCHAR2
26 );
27 procedure UPDATE_ROW (
28 X_ROWID in VARCHAR2,
29 X_PERSON_ID in NUMBER,
30 X_SEQUENCE_NUMBER in NUMBER,
31 X_STATE_CD in VARCHAR2,
32 X_RESULT_OBTAINED_YR in NUMBER,
33 X_SCORE in NUMBER,
34 X_AUS_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
35 X_CANDIDATE_NUMBER in NUMBER,
36 X_SECONDARY_SCHOOL_CD in VARCHAR2,
37 X_MODE in VARCHAR2 default 'R'
38 );
39 procedure ADD_ROW (
40 X_ROWID in out NOCOPY VARCHAR2,
41 X_PERSON_ID in NUMBER,
42 X_SEQUENCE_NUMBER in NUMBER,
43 X_STATE_CD in VARCHAR2,
44 X_RESULT_OBTAINED_YR in NUMBER,
45 X_SCORE in NUMBER,
46 X_AUS_SCNDRY_EDU_ASS_TYPE in VARCHAR2,
47 X_CANDIDATE_NUMBER in NUMBER,
48 X_SECONDARY_SCHOOL_CD in VARCHAR2,
49 X_MODE in VARCHAR2 default 'R'
50 );
51 procedure DELETE_ROW (
52 X_ROWID in VARCHAR2
53 );
54
55 Function Get_PK_For_Validation (
56 x_person_id IN NUMBER,
57 x_sequence_number IN NUMBER)
58 RETURN BOOLEAN;
59
60 PROCEDURE Before_DML (
61 p_action IN VARCHAR2,
62 x_rowid IN VARCHAR2 DEFAULT NULL,
63 x_person_id IN NUMBER DEFAULT NULL,
64 x_sequence_number IN NUMBER DEFAULT NULL,
65 x_state_cd IN VARCHAR2 DEFAULT NULL,
66 x_result_obtained_yr IN NUMBER DEFAULT NULL,
67 x_score IN NUMBER DEFAULT NULL,
68 x_aus_scndry_edu_ass_type IN VARCHAR2 DEFAULT NULL,
69 x_candidate_number IN NUMBER DEFAULT NULL,
70 x_secondary_school_cd IN VARCHAR2 DEFAULT NULL,
71 x_creation_date IN DATE DEFAULT NULL,
72 x_created_by IN NUMBER DEFAULT NULL,
73 x_last_update_date IN DATE DEFAULT NULL,
74 x_last_updated_by IN NUMBER DEFAULT NULL,
75 x_last_update_login IN NUMBER DEFAULT NULL
76 );
77
78 PROCEDURE Check_Constraints (
79 Column_Name IN VARCHAR2 DEFAULT NULL,
80 Column_Value IN VARCHAR2 DEFAULT NULL
81 );
82
83
84 PROCEDURE GET_FK_IGS_AD_AUSE_ED_AS_TY (
85 x_aus_scndry_edu_ass_type IN VARCHAR2
86 );
87
88 PROCEDURE GET_FK_IGS_AD_AUS_SEC_ED_SC (
89 x_secondary_school_cd IN VARCHAR2
90 );
91
92 PROCEDURE GET_FK_IGS_PE_PERSON (
93 x_person_id IN NUMBER
94 );
95
96 end IGS_AD_AUS_SEC_EDU_PKG;