1 package IGS_RE_CANDIDATURE_PKG as
2 /* $Header: IGSRI01S.pls 120.0 2005/06/01 15:59:37 appldev noship $ */
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_SCA_COURSE_CD in VARCHAR2,
8 X_ACAI_ADMISSION_APPL_NUMBER in NUMBER,
9 X_ACAI_NOMINATED_COURSE_CD in VARCHAR2,
10 X_ACAI_SEQUENCE_NUMBER in NUMBER,
11 X_ATTENDANCE_PERCENTAGE in NUMBER,
12 X_GOVT_TYPE_OF_ACTIVITY_CD in VARCHAR2,
13 X_MAX_SUBMISSION_DT in DATE,
14 X_MIN_SUBMISSION_DT in DATE,
15 X_RESEARCH_TOPIC in VARCHAR2,
16 X_INDUSTRY_LINKS in VARCHAR2,
17 X_MODE in VARCHAR2 default 'R' ,
18 X_ORG_ID in NUMBER
19 );
20 procedure LOCK_ROW (
21 X_ROWID in VARCHAR2,
22 X_PERSON_ID in NUMBER,
23 X_SEQUENCE_NUMBER in NUMBER,
24 X_SCA_COURSE_CD in VARCHAR2,
25 X_ACAI_ADMISSION_APPL_NUMBER in NUMBER,
26 X_ACAI_NOMINATED_COURSE_CD in VARCHAR2,
27 X_ACAI_SEQUENCE_NUMBER in NUMBER,
28 X_ATTENDANCE_PERCENTAGE in NUMBER,
29 X_GOVT_TYPE_OF_ACTIVITY_CD in VARCHAR2,
30 X_MAX_SUBMISSION_DT in DATE,
31 X_MIN_SUBMISSION_DT in DATE,
32 X_RESEARCH_TOPIC in VARCHAR2,
33 X_INDUSTRY_LINKS in VARCHAR2
34 );
35 procedure UPDATE_ROW (
36 X_ROWID in VARCHAR2,
37 X_PERSON_ID in NUMBER,
38 X_SEQUENCE_NUMBER in NUMBER,
39 X_SCA_COURSE_CD in VARCHAR2,
40 X_ACAI_ADMISSION_APPL_NUMBER in NUMBER,
41 X_ACAI_NOMINATED_COURSE_CD in VARCHAR2,
42 X_ACAI_SEQUENCE_NUMBER in NUMBER,
43 X_ATTENDANCE_PERCENTAGE in NUMBER,
44 X_GOVT_TYPE_OF_ACTIVITY_CD in VARCHAR2,
45 X_MAX_SUBMISSION_DT in DATE,
46 X_MIN_SUBMISSION_DT in DATE,
47 X_RESEARCH_TOPIC in VARCHAR2,
48 X_INDUSTRY_LINKS in VARCHAR2,
49 X_MODE in VARCHAR2 default 'R'
50 );
51 procedure ADD_ROW (
52 X_ROWID in out NOCOPY VARCHAR2,
53 X_PERSON_ID in NUMBER,
54 X_SEQUENCE_NUMBER in NUMBER,
55 X_SCA_COURSE_CD in VARCHAR2,
56 X_ACAI_ADMISSION_APPL_NUMBER in NUMBER,
57 X_ACAI_NOMINATED_COURSE_CD in VARCHAR2,
58 X_ACAI_SEQUENCE_NUMBER in NUMBER,
59 X_ATTENDANCE_PERCENTAGE in NUMBER,
60 X_GOVT_TYPE_OF_ACTIVITY_CD in VARCHAR2,
61 X_MAX_SUBMISSION_DT in DATE,
62 X_MIN_SUBMISSION_DT in DATE,
63 X_RESEARCH_TOPIC in VARCHAR2,
64 X_INDUSTRY_LINKS in VARCHAR2,
65 X_MODE in VARCHAR2 default 'R',
66 X_ORG_ID in NUMBER
67 );
68 procedure DELETE_ROW (
69 X_ROWID in VARCHAR2,
70 x_mode IN VARCHAR2 DEFAULT 'R'
71 );
72
73 FUNCTION Get_PK_For_Validation (
74 x_person_id IN NUMBER,
75 x_sequence_number IN NUMBER
76 )
77 RETURN BOOLEAN ;
78
79 PROCEDURE GET_FK_IGS_AD_PS_APPL_INST (
80 x_person_id IN NUMBER,
81 x_admission_appl_number IN NUMBER,
82 x_nominated_course_cd IN VARCHAR2,
83 x_sequence_number IN NUMBER
84 );
85
86 PROCEDURE GET_FK_IGS_RE_GV_TOA_CLS_CD (
87 x_govt_toa_class_cd IN VARCHAR2
88 );
89
90 PROCEDURE GET_FK_IGS_PE_PERSON (
91 x_person_id IN NUMBER
92 );
93
94 PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
95 x_person_id IN NUMBER,
96 x_course_cd IN VARCHAR2
97 );
98
99 PROCEDURE Check_Constraints (
100 Column_Name in VARCHAR2 DEFAULT NULL ,
101 Column_Value in VARCHAR2 DEFAULT NULL
102 );
103
104 PROCEDURE Before_DML (
105 p_action IN VARCHAR2,
106 x_rowid IN VARCHAR2 DEFAULT NULL,
107 x_industry_links IN VARCHAR2 DEFAULT NULL,
108 x_person_id IN NUMBER DEFAULT NULL,
109 x_sequence_number IN NUMBER DEFAULT NULL,
110 x_sca_course_cd IN VARCHAR2 DEFAULT NULL,
111 x_acai_admission_appl_number IN NUMBER DEFAULT NULL,
112 x_acai_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
113 x_acai_sequence_number IN NUMBER DEFAULT NULL,
114 x_attendance_percentage IN NUMBER DEFAULT NULL,
115 x_govt_type_of_activity_cd IN VARCHAR2 DEFAULT NULL,
116 x_max_submission_dt IN DATE DEFAULT NULL,
117 x_min_submission_dt IN DATE DEFAULT NULL,
118 x_research_topic IN VARCHAR2 DEFAULT NULL,
119 x_creation_date IN DATE DEFAULT NULL,
120 x_created_by IN NUMBER DEFAULT NULL,
121 x_last_update_date IN DATE DEFAULT NULL,
122 x_last_updated_by IN NUMBER DEFAULT NULL,
123 x_last_update_login IN NUMBER DEFAULT NULL,
124 X_ORG_ID in NUMBER DEFAULT NULL
125 );
126
127
128 end IGS_RE_CANDIDATURE_PKG;