1 PACKAGE igs_pe_typ_instances_pkg AS
2 /* $Header: IGSNI46S.pls 120.0 2005/06/01 19:24:26 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 x_PERSON_ID IN NUMBER,
6 x_COURSE_CD IN VARCHAR2,
7 x_TYPE_INSTANCE_ID IN OUT NOCOPY NUMBER,
8 x_PERSON_TYPE_CODE IN VARCHAR2,
9 x_CC_VERSION_NUMBER IN NUMBER,
10 x_FUNNEL_STATUS IN VARCHAR2,
11 x_ADMISSION_APPL_NUMBER IN NUMBER,
12 x_NOMINATED_COURSE_CD IN VARCHAR2,
13 x_NCC_VERSION_NUMBER IN NUMBER,
14 x_SEQUENCE_NUMBER IN NUMBER,
15 x_START_DATE IN DATE,
16 x_END_DATE IN DATE,
17 x_CREATE_METHOD IN VARCHAR2,
18 x_ENDED_BY IN NUMBER,
19 x_END_METHOD IN VARCHAR2,
20 X_MODE in VARCHAR2 default 'R',
21 X_ORG_ID in NUMBER,
22 X_EMPLMNT_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL
23 );
24
25 procedure LOCK_ROW (
26 X_ROWID in VARCHAR2,
27 x_PERSON_ID IN NUMBER,
28 x_COURSE_CD IN VARCHAR2,
29 x_TYPE_INSTANCE_ID IN NUMBER,
30 x_PERSON_TYPE_CODE IN VARCHAR2,
31 x_CC_VERSION_NUMBER IN NUMBER,
32 x_FUNNEL_STATUS IN VARCHAR2,
33 x_ADMISSION_APPL_NUMBER IN NUMBER,
34 x_NOMINATED_COURSE_CD IN VARCHAR2,
35 x_NCC_VERSION_NUMBER IN NUMBER,
36 x_SEQUENCE_NUMBER IN NUMBER,
37 x_START_DATE IN DATE,
38 x_END_DATE IN DATE,
39 x_CREATE_METHOD IN VARCHAR2,
40 x_ENDED_BY IN NUMBER,
41 x_END_METHOD IN VARCHAR2,
42 X_EMPLMNT_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL
43 );
44
45 procedure UPDATE_ROW (
46 X_ROWID in VARCHAR2,
47 x_PERSON_ID IN NUMBER,
48 x_COURSE_CD IN VARCHAR2,
49 x_TYPE_INSTANCE_ID IN NUMBER,
50 x_PERSON_TYPE_CODE IN VARCHAR2,
51 x_CC_VERSION_NUMBER IN NUMBER,
52 x_FUNNEL_STATUS IN VARCHAR2,
53 x_ADMISSION_APPL_NUMBER IN NUMBER,
54 x_NOMINATED_COURSE_CD IN VARCHAR2,
55 x_NCC_VERSION_NUMBER IN NUMBER,
56 x_SEQUENCE_NUMBER IN NUMBER,
57 x_START_DATE IN DATE,
58 x_END_DATE IN DATE,
59 x_CREATE_METHOD IN VARCHAR2,
60 x_ENDED_BY IN NUMBER,
61 x_END_METHOD IN VARCHAR2,
62 X_MODE in VARCHAR2 default 'R',
63 X_EMPLMNT_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL
64 );
65
66
67 procedure ADD_ROW (
68 X_ROWID in out NOCOPY VARCHAR2,
69 x_PERSON_ID IN NUMBER,
70 x_COURSE_CD IN VARCHAR2,
71 x_TYPE_INSTANCE_ID IN OUT NOCOPY NUMBER,
72 x_PERSON_TYPE_CODE IN VARCHAR2,
73 x_CC_VERSION_NUMBER IN NUMBER,
74 x_FUNNEL_STATUS IN VARCHAR2,
75 x_ADMISSION_APPL_NUMBER IN NUMBER,
76 x_NOMINATED_COURSE_CD IN VARCHAR2,
77 x_NCC_VERSION_NUMBER IN NUMBER,
78 x_SEQUENCE_NUMBER IN NUMBER,
79 x_START_DATE IN DATE,
80 x_END_DATE IN DATE,
81 x_CREATE_METHOD IN VARCHAR2,
82 x_ENDED_BY IN NUMBER,
83 x_END_METHOD IN VARCHAR2,
84 X_MODE in VARCHAR2 default 'R',
85 X_ORG_ID in NUMBER,
86 X_EMPLMNT_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL
87 ) ;
88
89 procedure DELETE_ROW (
90 X_ROWID in VARCHAR2,
91 x_mode IN VARCHAR2 DEFAULT 'R'
92 ) ;
93 FUNCTION Get_PK_For_Validation (
94 x_type_instance_id IN NUMBER
95 ) RETURN BOOLEAN ;
96
97 PROCEDURE Get_FK_Igs_Ad_Ps_Appl_Inst (
98 x_person_id IN NUMBER,
99 x_admission_appl_number IN NUMBER,
100 x_nominated_course_cd IN VARCHAR2,
101 x_sequence_number IN NUMBER
102 );
103
104 PROCEDURE Get_FK_Igs_Pe_Person_Types (
105 x_person_type_code IN VARCHAR2
106 );
107
108 PROCEDURE Get_FK_Igs_Ps_Ver (
109 x_course_cd IN VARCHAR2,
110 x_version_number IN NUMBER
111 );
112
113 PROCEDURE Get_FK_Igs_Pe_Person (
114 x_person_id IN NUMBER
115 );
116
117 PROCEDURE Check_Constraints (
118 Column_Name IN VARCHAR2 DEFAULT NULL,
119 Column_Value IN VARCHAR2 DEFAULT NULL ) ;
120
121
122 PROCEDURE Check_Mand_Person_Type
123 (
124 p_person_type_code IN IGS_PE_PERSON_TYPES.person_type_code%TYPE,
125 p_person_id IN HZ_PARTIES.party_id%TYPE
126 );
127
128 PROCEDURE Before_DML (
129 p_action IN VARCHAR2,
130 x_rowid IN VARCHAR2 DEFAULT NULL,
131 x_person_id IN NUMBER DEFAULT NULL,
132 x_course_cd IN VARCHAR2 DEFAULT NULL,
133 x_type_instance_id IN NUMBER DEFAULT NULL,
134 x_person_type_code IN VARCHAR2 DEFAULT NULL,
135 x_cc_version_number IN NUMBER DEFAULT NULL,
136 x_funnel_status IN VARCHAR2 DEFAULT NULL,
137 x_admission_appl_number IN NUMBER DEFAULT NULL,
138 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
139 x_ncc_version_number IN NUMBER DEFAULT NULL,
140 x_sequence_number IN NUMBER DEFAULT NULL,
141 x_start_date IN DATE DEFAULT NULL,
142 x_end_date IN DATE DEFAULT NULL,
143 x_create_method IN VARCHAR2 DEFAULT NULL,
144 x_ended_by IN NUMBER DEFAULT NULL,
145 x_end_method IN VARCHAR2 DEFAULT NULL,
146 x_creation_date IN DATE DEFAULT NULL,
147 x_created_by IN NUMBER DEFAULT NULL,
148 x_last_update_date IN DATE DEFAULT NULL,
149 x_last_updated_by IN NUMBER DEFAULT NULL,
150 x_last_update_login IN NUMBER DEFAULT NULL,
151 x_org_id IN NUMBER DEFAULT NULL,
152 X_EMPLMNT_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL
153 );
154 END igs_pe_typ_instances_pkg;