[Home] [Help]
PACKAGE: APPS.IGS_PS_GRP_MBR_PKG
Source
1 package IGS_PS_GRP_MBR_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSPI17S.pls 115.4 2003/02/20 10:31:28 shtatiko ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_COURSE_CD in VARCHAR2,
6 X_COURSE_GROUP_CD in VARCHAR2,
7 X_VERSION_NUMBER in NUMBER,
8 X_MODE in VARCHAR2 default 'R'
9 );
10 procedure LOCK_ROW (
11 X_ROWID IN VARCHAR2,
12 X_COURSE_CD in VARCHAR2,
13 X_COURSE_GROUP_CD in VARCHAR2,
14 X_VERSION_NUMBER in NUMBER
15 );
16 procedure DELETE_ROW (
17 X_ROWID IN VARCHAR2
18 );
19
20 FUNCTION Get_PK_For_Validation (
21 x_course_cd IN VARCHAR2,
22 x_version_number IN NUMBER,
23 x_course_group_cd IN VARCHAR2
24 )
25 RETURN BOOLEAN;
26
27 PROCEDURE GET_FK_IGS_PS_VER (
28 x_course_cd IN VARCHAR2,
29 x_version_number IN NUMBER
30 );
31
32 PROCEDURE Check_Constraints (
33 Column_Name IN VARCHAR2 DEFAULT NULL,
34 Column_Value IN VARCHAR2 DEFAULT NULL
35 );
36
37 PROCEDURE Before_DML (
38 p_action IN VARCHAR2,
39 x_rowid IN VARCHAR2 DEFAULT NULL,
40 x_course_cd IN VARCHAR2 DEFAULT NULL,
41 x_version_number IN NUMBER DEFAULT NULL,
42 x_course_group_cd IN VARCHAR2 DEFAULT NULL,
43 x_creation_date IN DATE DEFAULT NULL,
44 x_created_by IN NUMBER DEFAULT NULL,
45 x_last_update_date IN DATE DEFAULT NULL,
46 x_last_updated_by IN NUMBER DEFAULT NULL,
47 x_last_update_login IN NUMBER DEFAULT NULL
48 ) ;
49
50 end IGS_PS_GRP_MBR_PKG;