APPS.AMW_VIOLATIONS_PKG dependencies on AMW_VIOLATIONS

Line 1: PACKAGE BODY AMW_VIOLATIONS_PKG AS

1: PACKAGE BODY AMW_VIOLATIONS_PKG AS
2: /* $Header: amwtvlab.pls 120.1 2005/06/23 11:39:23 appldev noship $ */
3:
4: -- ===============================================================
5: -- Package name

Line 6: -- AMW_VIOLATIONS_PKG

2: /* $Header: amwtvlab.pls 120.1 2005/06/23 11:39:23 appldev noship $ */
3:
4: -- ===============================================================
5: -- Package name
6: -- AMW_VIOLATIONS_PKG
7: -- Purpose
8: --
9: -- History
10: -- 11/11/2003 tsho Creates

Line 21: -- in AMW_VIOLATIONS

17: -- Procedure name
18: -- INSERT_ROW
19: -- Purpose
20: -- create new violation
21: -- in AMW_VIOLATIONS
22: -- History
23: -- 05.20.2005 tsho: AMW.E add reval_request_id,reval_request_date, reval_requested_by_id
24: -- ===============================================================
25: procedure INSERT_ROW (

Line 61: cursor C is select ROWID from AMW_VIOLATIONS

57: X_REVAL_REQUEST_ID in NUMBER := NULL,
58: X_REVAL_REQUEST_DATE in DATE := NULL,
59: X_REVAL_REQUESTED_BY_ID in NUMBER := NULL
60: ) is
61: cursor C is select ROWID from AMW_VIOLATIONS
62: where VIOLATION_ID = X_VIOLATION_ID
63: ;
64: begin
65: insert into AMW_VIOLATIONS (

Line 65: insert into AMW_VIOLATIONS (

61: cursor C is select ROWID from AMW_VIOLATIONS
62: where VIOLATION_ID = X_VIOLATION_ID
63: ;
64: begin
65: insert into AMW_VIOLATIONS (
66: VIOLATION_ID,
67: CONSTRAINT_REV_ID,
68: REQUEST_ID,
69: REQUEST_DATE,

Line 211: from AMW_VIOLATIONS

207: ATTRIBUTE15,
208: REVAL_REQUEST_ID,
209: REVAL_REQUEST_DATE,
210: REVAL_REQUESTED_BY_ID
211: from AMW_VIOLATIONS
212: where VIOLATION_ID = X_VIOLATION_ID
213: for update of VIOLATION_ID nowait;
214: recinfo c%rowtype;
215:

Line 296: -- update AMW_VIOLATIONS

292: -- ===============================================================
293: -- Procedure name
294: -- UPDATE_ROW
295: -- Purpose
296: -- update AMW_VIOLATIONS
297: -- History
298: -- 05.20.2005 tsho: AMW.E add reval_request_id,reval_request_date, reval_requested_by_id
299: -- ===============================================================
300: procedure UPDATE_ROW (

Line 331: update AMW_VIOLATIONS set

327: X_REVAL_REQUEST_DATE in DATE := NULL,
328: X_REVAL_REQUESTED_BY_ID in NUMBER := NULL
329: ) is
330: begin
331: update AMW_VIOLATIONS set
332: CONSTRAINT_REV_ID = X_CONSTRAINT_REV_ID,
333: VIOLATOR_NUM = X_VIOLATOR_NUM,
334: STATUS_CODE = X_STATUS_CODE,
335: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 379: delete from AMW_VIOLATIONS

375: procedure DELETE_ROW (
376: X_VIOLATION_ID in NUMBER
377: ) is
378: begin
379: delete from AMW_VIOLATIONS
380: where VIOLATION_ID = X_VIOLATION_ID;
381:
382: if (sql%notfound) then
383: raise no_data_found;

Line 392: end AMW_VIOLATIONS_PKG;

388:
389:
390:
391: -- ----------------------------------------------------------------------
392: end AMW_VIOLATIONS_PKG;
393: