APPS.OKE_APPROVAL_STEPS_PKG dependencies on OKE_APPROVAL_STEPS

Line 1: PACKAGE BODY OKE_APPROVAL_STEPS_PKG AS

1: PACKAGE BODY OKE_APPROVAL_STEPS_PKG AS
2: /* $Header: OKEAPVEB.pls 120.1 2005/06/02 12:03:51 appldev $ */
3:
4: PROCEDURE INSERT_ROW
5: ( X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 20: FROM OKE_APPROVAL_STEPS

16: ) IS
17:
18: CURSOR c IS
19: SELECT ROWID
20: FROM OKE_APPROVAL_STEPS
21: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
22: AND APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE;
23:
24: BEGIN

Line 28: INSERT INTO OKE_APPROVAL_STEPS

24: BEGIN
25:
26: X_RECORD_VERSION_NUMBER := 1;
27:
28: INSERT INTO OKE_APPROVAL_STEPS
29: ( APPROVAL_PATH_ID
30: , APPROVAL_SEQUENCE
31: , APPROVER_ROLE_ID
32: , REQUIRED_FLAG

Line 70: FROM OKE_APPROVAL_STEPS

66: ) IS
67:
68: CURSOR c IS
69: SELECT RECORD_VERSION_NUMBER
70: FROM OKE_APPROVAL_STEPS
71: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
72: AND APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE
73: FOR UPDATE OF APPROVAL_PATH_ID NOWAIT;
74: RecInfo c%rowtype;

Line 109: FROM OKE_APPROVAL_STEPS

105: ) IS
106:
107: CURSOR c IS
108: SELECT RECORD_VERSION_NUMBER
109: FROM OKE_APPROVAL_STEPS
110: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
111: AND APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE;
112:
113: BEGIN

Line 114: UPDATE OKE_APPROVAL_STEPS

110: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
111: AND APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE;
112:
113: BEGIN
114: UPDATE OKE_APPROVAL_STEPS
115: SET APPROVER_ROLE_ID = X_APPROVER_ROLE_ID
116: , REQUIRED_FLAG = X_REQUIRED_FLAG
117: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
118: , LAST_UPDATED_BY = X_LAST_UPDATED_BY

Line 136: DELETE FROM OKE_APPROVAL_STEPS

132: , X_APPROVAL_SEQUENCE IN NUMBER
133: ) IS
134: BEGIN
135:
136: DELETE FROM OKE_APPROVAL_STEPS
137: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
138: AND APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE;
139:
140: IF (sql%notfound) THEN

Line 156: INSERT INTO OKE_APPROVAL_STEPS

152: , X_LAST_UPDATED_BY IN NUMBER
153: ) IS
154: BEGIN
155:
156: INSERT INTO OKE_APPROVAL_STEPS
157: ( APPROVAL_PATH_ID
158: , APPROVAL_SEQUENCE
159: , APPROVER_ROLE_ID
160: , REQUIRED_FLAG

Line 181: FROM OKE_APPROVAL_STEPS

177: , NULL
178: FROM DUAL
179: WHERE NOT EXISTS (
180: SELECT NULL
181: FROM OKE_APPROVAL_STEPS
182: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
183: AND ( APPROVAL_SEQUENCE = X_APPROVAL_SEQUENCE
184: OR APPROVER_ROLE_ID = X_APPROVER_ROLE_ID )
185: );

Line 189: END OKE_APPROVAL_STEPS_PKG;

185: );
186:
187: END LOAD_ROW;
188:
189: END OKE_APPROVAL_STEPS_PKG;