PACKAGE: APPS.AMW_VIOLATION_USERS_PKG

Source

1 PACKAGE AMW_VIOLATION_USERS_PKG AS
2 /* $Header: amwtvlus.pls 120.1.12000000.1 2007/01/16 20:43:32 appldev ship $ */
3 
4 -- ===============================================================
5 -- Package name
6 --          AMW_VIOLATION_USERS_PKG
7 -- Purpose
8 --
9 -- History
10 -- 		  	11/11/2003    tsho     Creates
11 --          01/06/2005    tsho     for new column WAIVED_FLAG
12 --          05/23/2005    tsho     AMW.E add corrected_flag
13 -- ===============================================================
14 
15 
16 -- ===============================================================
17 -- Procedure name
18 --          INSERT_ROW
19 -- Purpose
20 -- 		  	create new violation
21 -- History
22 --          05/23/2005    tsho     AMW.E add corrected_flag
23 -- ===============================================================
24 procedure INSERT_ROW (
25   X_ROWID in out nocopy VARCHAR2,
26   X_USER_VIOLATION_ID in NUMBER,
27   X_VIOLATION_ID in NUMBER,
28   X_VIOLATED_BY_ID in NUMBER,
29   X_LAST_UPDATED_BY in NUMBER,
30   X_LAST_UPDATE_DATE in DATE,
31   X_CREATED_BY in NUMBER,
32   X_CREATION_DATE in DATE,
33   X_LAST_UPDATE_LOGIN in NUMBER,
34   X_SECURITY_GROUP_ID in NUMBER,
35   X_WAIVED_FLAG in VARCHAR2 := NULL,
36   X_CORRECTED_FLAG in VARCHAR2 := NULL
37 );
38 
39 
40 
41 -- ===============================================================
42 -- Procedure name
43 --          LOCK_ROW
44 -- Purpose
45 --
46 -- History
47 --          05/23/2005    tsho     AMW.E add corrected_flag
48 -- ===============================================================
49 procedure LOCK_ROW (
50   X_USER_VIOLATION_ID in NUMBER,
51   X_VIOLATION_ID in NUMBER,
52   X_VIOLATED_BY_ID in NUMBER,
53   X_SECURITY_GROUP_ID in NUMBER,
54   X_WAIVED_FLAG in VARCHAR2 := NULL,
55   X_CORRECTED_FLAG in VARCHAR2 := NULL
56 );
57 
58 
59 
60 -- ===============================================================
61 -- Procedure name
62 --          UPDATE_ROW
63 -- Purpose
64 -- 		  	update AMW_VIOLATION_USERS
65 -- History
66 --          05/23/2005    tsho     AMW.E add corrected_flag
67 -- ===============================================================
68 procedure UPDATE_ROW (
69   X_USER_VIOLATION_ID in NUMBER,
70   X_VIOLATION_ID in NUMBER,
71   X_VIOLATED_BY_ID in NUMBER,
72   X_LAST_UPDATED_BY in NUMBER,
73   X_LAST_UPDATE_DATE in DATE,
74   X_LAST_UPDATE_LOGIN in NUMBER,
75   X_SECURITY_GROUP_ID in NUMBER,
76   X_WAIVED_FLAG in VARCHAR2 := NULL,
77   X_CORRECTED_FLAG in VARCHAR2 := NULL
78 );
79 
80 
81 -- ===============================================================
82 -- Procedure name
83 --          DELETE_ROW
84 -- Purpose
85 --
86 -- ===============================================================
87 procedure DELETE_ROW (
88   X_USER_VIOLATION_ID in NUMBER
89 );
90 
91 
92 
93 
94 -- ----------------------------------------------------------------------
95 end AMW_VIOLATION_USERS_PKG;