PACKAGE: APPS.IGS_PS_COURSE_PKG

Source

1 package IGS_PS_COURSE_PKG AUTHID CURRENT_USER AS
2   /* $Header: IGSPI03S.pls 115.3 2002/11/29 01:53:05 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_COURSE_CD in VARCHAR2,
7   X_MODE in VARCHAR2 default 'R'
8   );
9 
10 procedure LOCK_ROW (
11   X_ROWID IN VARCHAR2,
12   X_COURSE_CD in VARCHAR2
13 );
14 
15 procedure DELETE_ROW (
16   X_ROWID in VARCHAR2
17 );
18 
19   FUNCTION Get_PK_For_Validation (
20     x_course_cd IN VARCHAR2)
21   RETURN BOOLEAN;
22 
23 PROCEDURE Check_Constraints (
24     Column_Name	IN VARCHAR2	DEFAULT NULL,
25     Column_Value 	IN VARCHAR2	DEFAULT NULL
26 );
27 
28 PROCEDURE Before_DML (
29     p_action IN VARCHAR2,
30     x_rowid IN VARCHAR2 DEFAULT NULL,
31     x_course_cd IN VARCHAR2 DEFAULT NULL,
32     x_creation_date IN DATE DEFAULT NULL,
33     x_created_by IN NUMBER DEFAULT NULL,
34     x_last_update_date IN DATE DEFAULT NULL,
35     x_last_updated_by IN NUMBER DEFAULT NULL,
36     x_last_update_login IN NUMBER DEFAULT NULL
37   ) ;
38 
39 end IGS_PS_COURSE_PKG;