[Home] [Help]
PACKAGE: APPS.IGS_AD_CAT_PS_TYPE_PKG
Source
1 package IGS_AD_CAT_PS_TYPE_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI13S.pls 115.5 2003/06/05 12:54:28 sarakshi ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_ADMISSION_CAT in VARCHAR2,
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_ADMISSION_CAT in VARCHAR2,
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_admission_cat IN VARCHAR2,
21 x_course_type IN VARCHAR2)
22 RETURN BOOLEAN;
23
24 PROCEDURE Check_Constraints (
25 Column_Name IN VARCHAR2 DEFAULT NULL,
26 Column_Value IN VARCHAR2 DEFAULT NULL
27 );
28
29 PROCEDURE Before_DML (
30 p_action IN VARCHAR2,
31 x_rowid IN VARCHAR2 DEFAULT NULL,
32 x_admission_cat IN VARCHAR2 DEFAULT NULL,
33 x_course_type IN VARCHAR2 DEFAULT NULL,
34 x_creation_date IN DATE DEFAULT NULL,
35 x_created_by IN NUMBER DEFAULT NULL,
36 x_last_update_date IN DATE DEFAULT NULL,
37 x_last_updated_by IN NUMBER DEFAULT NULL,
38 x_last_update_login IN NUMBER DEFAULT NULL
39 );
40
41 PROCEDURE GET_FK_IGS_AD_CAT (
42 x_admission_cat IN VARCHAR2
43 );
44
45 end IGS_AD_CAT_PS_TYPE_PKG;