PACKAGE: APPS.IGS_EN_ORUN_WLST_PRI_PKG

Source

1 PACKAGE igs_en_orun_wlst_pri_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSEI34S.pls 115.7 2003/05/30 10:44:41 ptandon ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_ORG_UNIT_WLST_PRI_ID IN OUT NOCOPY NUMBER,
6        x_ORG_UNIT_WLST_ID IN NUMBER,
7        x_PRIORITY_NUMBER IN NUMBER,
8        x_PRIORITY_VALUE IN VARCHAR2,
9       X_MODE in VARCHAR2 default 'R'
10   );
11 
12  procedure LOCK_ROW (
13       X_ROWID in  VARCHAR2,
14        x_ORG_UNIT_WLST_PRI_ID IN NUMBER,
15        x_ORG_UNIT_WLST_ID IN NUMBER,
16        x_PRIORITY_NUMBER IN NUMBER,
17        x_PRIORITY_VALUE IN VARCHAR2  );
18  procedure UPDATE_ROW (
19       X_ROWID in  VARCHAR2,
20        x_ORG_UNIT_WLST_PRI_ID IN NUMBER,
21        x_ORG_UNIT_WLST_ID IN NUMBER,
22        x_PRIORITY_NUMBER IN NUMBER,
23        x_PRIORITY_VALUE IN VARCHAR2,
24       X_MODE in VARCHAR2 default 'R'
25   );
26 
27  procedure ADD_ROW (
28       X_ROWID in out NOCOPY VARCHAR2,
29        x_ORG_UNIT_WLST_PRI_ID IN OUT NOCOPY NUMBER,
30        x_ORG_UNIT_WLST_ID IN NUMBER,
31        x_PRIORITY_NUMBER IN NUMBER,
32        x_PRIORITY_VALUE IN VARCHAR2,
33       X_MODE in VARCHAR2 default 'R'
34   ) ;
35 
36 procedure DELETE_ROW (
37   X_ROWID in VARCHAR2
38 ) ;
39   FUNCTION Get_PK_For_Validation (
40     x_org_unit_wlst_pri_id IN NUMBER
41     ) RETURN BOOLEAN ;
42 
43   PROCEDURE Get_FK_Igs_En_Or_Unit_Wlst (
44     x_org_unit_wlst_id IN NUMBER
45     );
46 
47   PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
48     x_priority_value IN VARCHAR2
49     );
50 
51   PROCEDURE Check_Constraints (
52 		 Column_Name IN VARCHAR2  DEFAULT NULL,
53 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
54   PROCEDURE Before_DML (
55     p_action IN VARCHAR2,
56     x_rowid IN VARCHAR2 DEFAULT NULL,
57     x_org_unit_wlst_pri_id IN NUMBER DEFAULT NULL,
58     x_org_unit_wlst_id IN NUMBER DEFAULT NULL,
59     x_priority_number IN NUMBER DEFAULT NULL,
60     x_priority_value IN VARCHAR2 DEFAULT NULL,
61     x_creation_date IN DATE DEFAULT NULL,
62     x_created_by IN NUMBER DEFAULT NULL,
63     x_last_update_date IN DATE DEFAULT NULL,
64     x_last_updated_by IN NUMBER DEFAULT NULL,
65     x_last_update_login IN NUMBER DEFAULT NULL
66  );
67 END igs_en_orun_wlst_pri_pkg;