PACKAGE: APPS.IGS_AS_COURSE_TYPE_PKG

Source

1 package IGS_AS_COURSE_TYPE_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSDI01S.pls 115.5 2003/06/05 12:56:35 sarakshi ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ORG_ID in NUMBER,
6   X_ASS_ID in NUMBER,
7   X_COURSE_TYPE in VARCHAR2,
8   X_MODE in VARCHAR2 default 'R'
9   );
10 procedure LOCK_ROW (
11   X_ROWID in VARCHAR2,
12   X_ASS_ID in NUMBER,
13   X_COURSE_TYPE in VARCHAR2
14 );
15 procedure DELETE_ROW (
16   X_ROWID in VARCHAR2
17 
18 );
19   FUNCTION Get_PK_For_Validation (
20     x_ass_id IN NUMBER ,
21     x_course_type IN VARCHAR2
22 ) RETURN BOOLEAN;
23   PROCEDURE GET_FK_IGS_AS_ASSESSMNT_ITM (
24     x_ass_id IN NUMBER
25     );
26 
27 PROCEDURE Check_Constraints (
28 	Column_Name	IN	VARCHAR2	DEFAULT NULL,
29 
30 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
31 
32 	);
33 
34 PROCEDURE Before_DML (
35 
36    p_action IN VARCHAR2,
37 
38     x_rowid IN VARCHAR2 DEFAULT NULL,
39     x_org_id IN NUMBER DEFAULT NULL,
40     x_ass_id IN NUMBER DEFAULT NULL,
41 
42     x_course_type IN VARCHAR2 DEFAULT NULL,
43 
44     x_creation_date IN DATE DEFAULT NULL,
45 
46     x_created_by IN NUMBER DEFAULT NULL,
47 
48     x_last_update_date IN DATE DEFAULT NULL,
49 
50     x_last_updated_by IN NUMBER DEFAULT NULL,
51 
52     x_last_update_login IN NUMBER DEFAULT NULL
53 
54   ) ;
55 end IGS_AS_COURSE_TYPE_PKG;