DBA Data[Home] [Help]

APPS.JTF_PERZ_DATA_PVT dependencies on FND_GLOBAL

Line 33: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

29: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_DATA_PVT';
30: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvpzdb.pls';
31:
32:
33: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
34: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
35:
36:
37:

Line 34: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

30: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvpzdb.pls';
31:
32:
33: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
34: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
35:
36:
37:
38: -- *****************************************************************************

Line 150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

146: PERZ_DATA_DESC = decode( p_PERZ_DATA_DESC, FND_API.G_MISS_CHAR, PERZ_DATA_DESC, p_PERZ_DATA_DESC),
147: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
151: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
152: where PERZ_DATA_ID = p_PERZ_DATA_ID
153: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
154:

Line 151: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

147: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
148: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
149: LAST_UPDATE_DATE = SYSDATE,
150: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
151: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
152: where PERZ_DATA_ID = p_PERZ_DATA_ID
153: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
154:
155: If (SQL%NOTFOUND) then