PACKAGE: APPS.IGS_EN_INST_WLST_OPT_PKG

Source

1 PACKAGE igs_en_inst_wlst_opt_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSEI16S.pls 115.8 2003/09/02 08:37:58 svanukur ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5       X_ORG_ID in NUMBER,
6        x_INST_WAITLIST_ID IN OUT NOCOPY NUMBER,
7        x_CAL_TYPE IN VARCHAR2,
8        x_WAITLIST_ALWD IN VARCHAR2,
9        x_SMLNES_WAITLIST_ALWD IN VARCHAR2,
10       X_MODE in VARCHAR2 default 'R'
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_INST_WAITLIST_ID IN NUMBER,
16        x_CAL_TYPE IN VARCHAR2,
17        x_WAITLIST_ALWD IN VARCHAR2,
18        x_SMLNES_WAITLIST_ALWD IN VARCHAR2  );
19  procedure UPDATE_ROW (
20       X_ROWID in  VARCHAR2,
21        x_INST_WAITLIST_ID IN NUMBER,
22        x_CAL_TYPE IN VARCHAR2,
23        x_WAITLIST_ALWD IN VARCHAR2,
24        x_SMLNES_WAITLIST_ALWD IN VARCHAR2,
25       X_MODE in VARCHAR2 default 'R'
26   );
27 
28  procedure ADD_ROW (
29       X_ROWID in out NOCOPY VARCHAR2,
30       X_ORG_ID in NUMBER,
31        x_INST_WAITLIST_ID IN OUT NOCOPY NUMBER,
32        x_CAL_TYPE IN VARCHAR2,
33        x_WAITLIST_ALWD IN VARCHAR2,
34        x_SMLNES_WAITLIST_ALWD IN VARCHAR2,
35       X_MODE in VARCHAR2 default 'R'
36   ) ;
37 
38 procedure DELETE_ROW (
39   X_ROWID in VARCHAR2
40 ) ;
41   FUNCTION Get_PK_For_Validation (
42     x_inst_waitlist_id IN NUMBER
43     ) RETURN BOOLEAN ;
44 
45   FUNCTION Get_UK_For_Validation (
46     x_cal_type IN VARCHAR2
47 
48     ) RETURN BOOLEAN;
49 
50   PROCEDURE Get_FK_Igs_Ca_Type (
51     x_cal_type IN VARCHAR2
52     );
53 
54   PROCEDURE Get_FK_Igs_Ca_Inst (
55     x_cal_type IN VARCHAR2,
56     x_sequence_number IN NUMBER
57     );
58 
59   PROCEDURE Check_Constraints (
60 		 Column_Name IN VARCHAR2  DEFAULT NULL,
61 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
62   PROCEDURE Before_DML (
63     p_action IN VARCHAR2,
64     x_rowid IN VARCHAR2 DEFAULT NULL,
65     X_ORG_ID in NUMBER DEFAULT NULL,
66     x_inst_waitlist_id IN NUMBER DEFAULT NULL,
67     x_cal_type IN VARCHAR2 DEFAULT NULL,
68     x_waitlist_alwd IN VARCHAR2 DEFAULT NULL,
69     x_smlnes_waitlist_alwd IN VARCHAR2 DEFAULT NULL,
70     x_creation_date IN DATE DEFAULT NULL,
71     x_created_by IN NUMBER DEFAULT NULL,
72     x_last_update_date IN DATE DEFAULT NULL,
73     x_last_updated_by IN NUMBER DEFAULT NULL,
74     x_last_update_login IN NUMBER DEFAULT NULL
75  );
76 END igs_en_inst_wlst_opt_pkg;