APPS.OKE_K_ORGANIZER_PKG dependencies on OKE_K_FIFO_LOGS

Line 124: INSERT INTO oke_k_fifo_logs

120:
121: --
122: -- Step 1 : Create entry if not exists; use sequence 0
123: --
124: INSERT INTO oke_k_fifo_logs
125: ( user_log_id
126: , k_header_id
127: , sequence
128: , object_name

Line 134: SELECT oke_k_fifo_logs_s.nextval

130: , last_updated_by
131: , creation_date
132: , created_by
133: , last_update_login )
134: SELECT oke_k_fifo_logs_s.nextval
135: , X_K_Header_ID
136: , 0
137: , X_Object_Name
138: , sysdate

Line 146: FROM oke_k_fifo_logs

142: , null
143: FROM dual
144: WHERE NOT EXISTS (
145: SELECT null
146: FROM oke_k_fifo_logs
147: WHERE k_header_id = X_K_Header_ID
148: AND object_name = X_Object_Name
149: AND created_by = X_User_ID
150: );

Line 155: UPDATE oke_k_fifo_logs

151:
152: --
153: -- Step 2 : Update entry to sequence 0 if already exists
154: --
155: UPDATE oke_k_fifo_logs
156: SET last_update_date = sysdate
157: , last_updated_by = X_User_ID
158: , sequence = 0
159: WHERE k_header_id = X_K_Header_ID

Line 167: UPDATE oke_k_fifo_logs l1

163:
164: --
165: -- Step 3 : Renumber sequence from 1 while retaining order
166: --
167: UPDATE oke_k_fifo_logs l1
168: SET sequence = (
169: SELECT count(1)
170: FROM oke_k_fifo_logs l2
171: WHERE l2.object_name = l1.object_name

Line 170: FROM oke_k_fifo_logs l2

166: --
167: UPDATE oke_k_fifo_logs l1
168: SET sequence = (
169: SELECT count(1)
170: FROM oke_k_fifo_logs l2
171: WHERE l2.object_name = l1.object_name
172: AND l2.created_by = l1.created_by
173: AND l2.last_update_date >= l1.last_update_date )
174: WHERE object_name = X_Object_Name

Line 181: DELETE FROM oke_k_fifo_logs

177: IF ( sql%rowcount > nvl(log_size , 6) ) THEN
178: --
179: -- Step 4 : Prune entries older than profile setting
180: --
181: DELETE FROM oke_k_fifo_logs
182: WHERE object_name = X_Object_Name
183: AND created_by = X_User_ID
184: AND sequence > nvl(log_size , 6);
185: