APPS.AMW_VIOLATION_USERS_PKG dependencies on AMW_VIOLATION_USERS

Line 1: PACKAGE BODY AMW_VIOLATION_USERS_PKG AS

1: PACKAGE BODY AMW_VIOLATION_USERS_PKG AS
2: /* $Header: amwtvlub.pls 120.1.12000000.2 2007/04/02 16:54:25 dliao ship $ */
3:
4: -- ===============================================================
5: -- Package name

Line 6: -- AMW_VIOLATION_USERS_PKG

2: /* $Header: amwtvlub.pls 120.1.12000000.2 2007/04/02 16:54:25 dliao ship $ */
3:
4: -- ===============================================================
5: -- Package name
6: -- AMW_VIOLATION_USERS_PKG
7: -- Purpose
8: --
9: -- History
10: -- 11/11/2003 tsho Creates

Line 20: -- create new violated user into AMW_VIOLATION_USERS

16: -- ===============================================================
17: -- Procedure name
18: -- INSERT_ROW
19: -- Purpose
20: -- create new violated user into AMW_VIOLATION_USERS
21: -- History
22: -- 05/23/2005 tsho AMW.E add corrected_flag
23: -- ===============================================================
24: procedure INSERT_ROW (

Line 38: cursor C is select ROWID from AMW_VIOLATION_USERS

34: X_SECURITY_GROUP_ID in NUMBER,
35: X_WAIVED_FLAG in VARCHAR2 := NULL,
36: X_CORRECTED_FLAG in VARCHAR2 := NULL
37: ) is
38: cursor C is select ROWID from AMW_VIOLATION_USERS
39: where USER_VIOLATION_ID = X_USER_VIOLATION_ID
40: ;
41: begin
42: insert into AMW_VIOLATION_USERS (

Line 42: insert into AMW_VIOLATION_USERS (

38: cursor C is select ROWID from AMW_VIOLATION_USERS
39: where USER_VIOLATION_ID = X_USER_VIOLATION_ID
40: ;
41: begin
42: insert into AMW_VIOLATION_USERS (
43: USER_VIOLATION_ID,
44: VIOLATION_ID,
45: VIOLATED_BY_ID,
46: LAST_UPDATED_BY,

Line 102: from AMW_VIOLATION_USERS

98: VIOLATED_BY_ID,
99: SECURITY_GROUP_ID,
100: WAIVED_FLAG,
101: CORRECTED_FLAG
102: from AMW_VIOLATION_USERS
103: where USER_VIOLATION_ID = X_USER_VIOLATION_ID
104: for update of USER_VIOLATION_ID nowait;
105: recinfo c%rowtype;
106:

Line 143: -- update AMW_VIOLATION_USERS

139: -- ===============================================================
140: -- Procedure name
141: -- UPDATE_ROW
142: -- Purpose
143: -- update AMW_VIOLATION_USERS
144: -- History
145: -- 05/23/2005 tsho AMW.E add corrected_flag
146: -- ===============================================================
147: procedure UPDATE_ROW (

Line 161: update AMW_VIOLATION_USERS set

157: ) is
158: begin
159:
160: IF ( X_WAIVED_FLAG IS NULL OR X_WAIVED_FLAG = '') THEN
161: update AMW_VIOLATION_USERS set
162: VIOLATION_ID = X_VIOLATION_ID,
163: VIOLATED_BY_ID = X_VIOLATED_BY_ID,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
165: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 172: update AMW_VIOLATION_USERS set

168: -- WAIVED_FLAG = X_WAIVED_FLAG,
169: CORRECTED_FLAG = X_CORRECTED_FLAG
170: where USER_VIOLATION_ID = X_USER_VIOLATION_ID;
171: ELSE
172: update AMW_VIOLATION_USERS set
173: VIOLATION_ID = X_VIOLATION_ID,
174: VIOLATED_BY_ID = X_VIOLATED_BY_ID,
175: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
176: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 203: delete from AMW_VIOLATION_USERS

199: procedure DELETE_ROW (
200: X_USER_VIOLATION_ID in NUMBER
201: ) is
202: begin
203: delete from AMW_VIOLATION_USERS
204: where USER_VIOLATION_ID = X_USER_VIOLATION_ID;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 216: end AMW_VIOLATION_USERS_PKG;

212:
213:
214:
215: -- ----------------------------------------------------------------------
216: end AMW_VIOLATION_USERS_PKG;