1 package IGS_PR_SDT_PR_UNT_ST_PKG AS
2 /* $Header: IGSQI19S.pls 120.0 2005/07/05 12:21:18 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_SPO_SEQUENCE_NUMBER in NUMBER,
8 X_UNIT_SET_CD in VARCHAR2,
9 X_VERSION_NUMBER in NUMBER,
10 X_MODE in VARCHAR2 default 'R'
11 );
12 procedure LOCK_ROW (
13 X_ROWID in VARCHAR2,
14 X_PERSON_ID in NUMBER,
15 X_COURSE_CD in VARCHAR2,
16 X_SPO_SEQUENCE_NUMBER in NUMBER,
17 X_UNIT_SET_CD in VARCHAR2,
18 X_VERSION_NUMBER in NUMBER
19 );
20 procedure DELETE_ROW (
21 X_ROWID in VARCHAR2,
22 x_mode IN VARCHAR2 DEFAULT 'R'
23 );
24
25 FUNCTION Get_PK_For_Validation (
26 x_person_id IN NUMBER,
27 x_course_cd IN VARCHAR2,
28 x_spo_sequence_number IN NUMBER,
29 x_unit_set_cd IN VARCHAR2,
30 x_version_number IN NUMBER
31 )RETURN BOOLEAN;
32
33 PROCEDURE GET_FK_IGS_PR_STDNT_PR_OU (
34 x_person_id IN NUMBER,
35 x_course_cd IN VARCHAR2,
36 x_sequence_number IN NUMBER
37 );
38
39 PROCEDURE GET_FK_IGS_EN_UNIT_SET (
40 x_unit_set_cd IN VARCHAR2,
41 x_version_number IN NUMBER
42 );
43 PROCEDURE Before_DML (
44 p_action IN VARCHAR2,
45 x_rowid IN VARCHAR2 DEFAULT NULL,
46 x_person_id IN NUMBER DEFAULT NULL,
47 x_course_cd IN VARCHAR2 DEFAULT NULL,
48 x_spo_sequence_number IN NUMBER DEFAULT NULL,
49 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
50 x_version_number IN NUMBER DEFAULT NULL,
51 x_creation_date IN DATE DEFAULT NULL,
52 x_created_by IN NUMBER DEFAULT NULL,
53 x_last_update_date IN DATE DEFAULT NULL,
54 x_last_updated_by IN NUMBER DEFAULT NULL,
55 x_last_update_login IN NUMBER DEFAULT NULL
56 );
57 PROCEDURE Check_Constraints(
58 Column_Name IN VARCHAR2 DEFAULT NULL,
59 Column_Value IN VARCHAR2 DEFAULT NULL
60 );
61
62 end IGS_PR_SDT_PR_UNT_ST_PKG;