APPS.OKE_CHG_REQ_UTILS dependencies on OKE_CHG_LOGS

Line 90: SELECT oke_chg_logs_s.nextval

86:
87: --
88: -- Get the change log ID; this also serves as the WF Item Key
89: --
90: SELECT oke_chg_logs_s.nextval
91: INTO X_Chg_Log_ID
92: FROM dual;
93:
94: IF ( l_wf_item_type IS NOT NULL and l_wf_process IS NOT NULL) THEN

Line 225: INSERT INTO oke_chg_logs

221:
222: --
223: -- Write record into Change Status History
224: --
225: INSERT INTO oke_chg_logs
226: ( chg_log_id
227: , chg_request_id
228: , chg_status_code
229: , creation_date

Line 298: FROM OKE_Chg_Logs

294:
295: CURSOR c IS
296: SELECT WF_Item_Type
297: , WF_Item_Key
298: FROM OKE_Chg_Logs
299: WHERE Chg_Log_ID = P_Chg_Log_ID;
300: crec c%rowtype;
301:
302: BEGIN

Line 354: FROM oke_chg_logs

350:
351: CURSOR wf IS
352: SELECT wf_item_type
353: , wf_item_key
354: FROM oke_chg_logs
355: WHERE chg_log_id = P_Chg_Log_ID;
356: wfrec wf%rowtype;
357:
358: --