APPS.OKE_CHG_REQUESTS_PKG dependencies on OKE_CHG_REQUESTS

Line 1: package body OKE_CHG_REQUESTS_PKG as

1: package body OKE_CHG_REQUESTS_PKG as
2: /* $Header: OKEOCRXB.pls 120.0 2005/05/25 17:57:25 appldev noship $ */
3:
4: PROCEDURE Start_WF_Process
5: ( X_LAST_CHG_LOG_ID IN NUMBER

Line 79: SELECT oke_chg_requests_s.nextval

75: , X_ATTRIBUTE15 in VARCHAR2
76: ) is
77:
78: cursor C1 is
79: SELECT oke_chg_requests_s.nextval
80: FROM dual;
81:
82: cursor C2 is
83: SELECT ROWID

Line 87: FROM oke_chg_requests

83: SELECT ROWID
84: , LAST_CHG_LOG_ID
85: , APPROVE_DATE
86: , IMPLEMENT_DATE
87: FROM oke_chg_requests
88: WHERE chg_request_id = X_CHG_REQUEST_ID
89: ;
90:
91: Auto_ChgReq_Number BOOLEAN := FALSE;

Line 107: SAVEPOINT OKE_CHG_REQUESTS_INSERT;

103: Auto_ChgReq_Number := TRUE;
104: X_Chg_Request_Num := 'TEMP:' || rpad(X_Chg_Request_ID , 25 , '*');
105: END IF;
106:
107: SAVEPOINT OKE_CHG_REQUESTS_INSERT;
108:
109: insert into OKE_CHG_REQUESTS (
110: CHG_REQUEST_ID
111: , CREATION_DATE

Line 109: insert into OKE_CHG_REQUESTS (

105: END IF;
106:
107: SAVEPOINT OKE_CHG_REQUESTS_INSERT;
108:
109: insert into OKE_CHG_REQUESTS (
110: CHG_REQUEST_ID
111: , CREATION_DATE
112: , CREATED_BY
113: , LAST_UPDATE_DATE

Line 207: UPDATE oke_chg_requests

203: IF ( Auto_ChgReq_Number ) THEN
204: X_Chg_Request_Num := OKE_NUMBER_SEQUENCES_PKG.Next_ChgReq_Number
205: ( X_CHG_TYPE_CODE , X_K_HEADER_ID );
206:
207: UPDATE oke_chg_requests
208: SET Chg_Request_Num = X_Chg_Request_Num
209: WHERE Chg_Request_ID = X_Chg_Request_ID;
210:
211: END IF;

Line 217: ROLLBACK TO SAVEPOINT OKE_CHG_REQUESTS_INSERT;

213: Start_WF_Process( X_Last_Chg_Log_ID );
214:
215: EXCEPTION
216: WHEN OTHERS THEN
217: ROLLBACK TO SAVEPOINT OKE_CHG_REQUESTS_INSERT;
218: RAISE;
219:
220: end INSERT_ROW;
221:

Line 291: from OKE_CHG_REQUESTS

287: , ATTRIBUTE12
288: , ATTRIBUTE13
289: , ATTRIBUTE14
290: , ATTRIBUTE15
291: from OKE_CHG_REQUESTS
292: where CHG_REQUEST_ID = X_CHG_REQUEST_ID
293: for update of CHG_REQUEST_ID nowait;
294: recinfo c%rowtype;
295:

Line 425: FROM oke_chg_requests

421: cursor C is
422: SELECT LAST_CHG_LOG_ID
423: , APPROVE_DATE
424: , IMPLEMENT_DATE
425: FROM oke_chg_requests
426: WHERE chg_request_id = X_CHG_REQUEST_ID
427: ;
428:
429: cursor C2 is

Line 431: FROM oke_chg_requests

427: ;
428:
429: cursor C2 is
430: SELECT LAST_CHG_LOG_ID
431: FROM oke_chg_requests
432: WHERE chg_request_id = X_CHG_REQUEST_ID
433: ;
434:
435: Prev_Chg_Log_ID NUMBER;

Line 443: update OKE_CHG_REQUESTS set

439: open c2;
440: fetch c2 into Prev_Chg_Log_ID;
441: close c2;
442:
443: update OKE_CHG_REQUESTS set
444: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
445: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
446: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
447: , K_HEADER_ID = X_K_HEADER_ID

Line 518: FROM oke_chg_requests

514: , C_Chg_Request_Num VARCHAR2
515: , C_Chg_Request_ID NUMBER
516: ) IS
517: SELECT count(1)
518: FROM oke_chg_requests
519: WHERE K_Header_ID = C_K_Header_ID
520: AND Chg_Request_Num = C_Chg_Request_Num
521: AND ( C_Chg_Request_ID IS NULL
522: OR Chg_Request_ID <> C_Chg_Request_ID );

Line 609: end OKE_CHG_REQUESTS_PKG;

605:
606: return Num_Mode;
607: END Chg_Req_Num_Mode;
608:
609: end OKE_CHG_REQUESTS_PKG;