APPS.OKE_NUMBER_OPTIONS_PKG dependencies on OKE_NUMBER_OPTIONS

Line 1: PACKAGE BODY OKE_NUMBER_OPTIONS_PKG AS

1: PACKAGE BODY OKE_NUMBER_OPTIONS_PKG AS
2: /* $Header: OKENMOPB.pls 115.5 2002/11/21 23:01:09 ybchen ship $ */
3: PROCEDURE INSERT_ROW
4: ( X_ROWID IN OUT NOCOPY VARCHAR2
5: , X_K_TYPE_CODE IN VARCHAR2

Line 51: FROM OKE_NUMBER_OPTIONS

47: ) IS
48:
49: CURSOR c IS
50: SELECT ROWID
51: FROM OKE_NUMBER_OPTIONS
52: WHERE K_TYPE_CODE = X_K_TYPE_CODE
53: AND BUY_OR_SELL = X_BUY_OR_SELL;
54:
55: BEGIN

Line 57: INSERT INTO OKE_NUMBER_OPTIONS

53: AND BUY_OR_SELL = X_BUY_OR_SELL;
54:
55: BEGIN
56:
57: INSERT INTO OKE_NUMBER_OPTIONS
58: ( K_TYPE_CODE
59: , BUY_OR_SELL
60: , CREATION_DATE
61: , CREATED_BY

Line 147: FROM OKE_NUMBER_OPTIONS

143: , X_ATTRIBUTE15
144: FROM DUAL
145: WHERE NOT EXISTS
146: (SELECT NULL
147: FROM OKE_NUMBER_OPTIONS
148: WHERE K_TYPE_CODE=X_K_TYPE_CODE
149: AND BUY_OR_SELL=X_BUY_OR_SELL);
150:
151: OPEN c;

Line 246: FROM OKE_NUMBER_OPTIONS

242: , ATTRIBUTE12
243: , ATTRIBUTE13
244: , ATTRIBUTE14
245: , ATTRIBUTE15
246: FROM OKE_NUMBER_OPTIONS
247: WHERE ROWID = X_ROWID
248: FOR UPDATE OF K_TYPE_CODE NOWAIT;
249: CREC c%rowtype;
250:

Line 391: UPDATE OKE_NUMBER_OPTIONS

387: ) IS
388:
389: BEGIN
390:
391: UPDATE OKE_NUMBER_OPTIONS
392: SET LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
393: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
394: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
395: , CONTRACT_NUM_MODE = X_CONTRACT_NUM_MODE

Line 439: END OKE_NUMBER_OPTIONS_PKG;

435: END IF;
436:
437: END UPDATE_ROW;
438:
439: END OKE_NUMBER_OPTIONS_PKG;