DBA Data[Home] [Help]

APPS.OZF_REASON_CODES_ALL_PKG dependencies on FND_API

Line 67: /* IF (px_ORG_ID IS NULL OR px_ORG_ID = FND_API.G_MISS_NUM) THEN

63: FROM OZF_REASON_CODES_ALL_B
64: WHERE REASON_CODE_ID = l_reason_code_id;
65:
66: BEGIN
67: /* IF (px_ORG_ID IS NULL OR px_ORG_ID = FND_API.G_MISS_NUM) THEN
68: select nvl(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
69: into px_ORG_ID
70: from dual;
71: END IF; */

Line 87: px_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN

83: END LOOP;
84: END IF;
85:
86: IF (px_OBJECT_VERSION_NUMBER IS NULL OR
87: px_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN
88: px_OBJECT_VERSION_NUMBER := 1;
89: END IF;
90:
91: INSERT INTO OZF_REASON_CODES_ALL_B(

Line 242: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

238: REASON_CODE_ID = p_REASON_CODE_ID,
239: OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER,
240: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
241: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
242: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
243: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
245: REASON_CODE = p_REASON_CODE,
246: START_DATE_ACTIVE = p_START_DATE_ACTIVE,

Line 243: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

239: OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER,
240: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
241: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
242: -- CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
243: -- CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
245: REASON_CODE = p_REASON_CODE,
246: START_DATE_ACTIVE = p_START_DATE_ACTIVE,
247: END_DATE_ACTIVE = p_END_DATE_ACTIVE,