APPS.JTF_PERZ_PROFILE_PVT dependencies on FND_GLOBAL

Line 48: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

44: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_PROFILE_PVT';
45: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvzpfb.pls';
46:
47:
48: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
49: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
50:
51:
52: -- ****************************************************************************

Line 49: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

45: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvzpfb.pls';
46:
47:
48: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
49: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
50:
51:
52: -- ****************************************************************************
53: -- ****************************************************************************

Line 143: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

139: x_ACTIVE_FLAG ),
140: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
141: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
142: LAST_UPDATE_DATE = SYSDATE,
143: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
144: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
145: WHERE profile_id = x_PROFILE_ID
146: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
147:

Line 144: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

140: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
141: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
142: LAST_UPDATE_DATE = SYSDATE,
143: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
144: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
145: WHERE profile_id = x_PROFILE_ID
146: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
147:
148: IF (SQL%NOTFOUND) THEN

Line 221: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

217: ATTRIBUTE_TYPE, x_ATTRIBUTE_TYPE ),
218: ATTRIBUTE_VALUE = decode( x_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR,
219: ATTRIBUTE_VALUE, x_ATTRIBUTE_VALUE ),
220: LAST_UPDATE_DATE = SYSDATE,
221: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
222: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
223: WHERE profile_id = x_profile_id and
224: PROFILE_ATTRIBUTE = x_PROFILE_ATTRIBUTE;
225:

Line 222: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

218: ATTRIBUTE_VALUE = decode( x_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR,
219: ATTRIBUTE_VALUE, x_ATTRIBUTE_VALUE ),
220: LAST_UPDATE_DATE = SYSDATE,
221: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
222: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
223: WHERE profile_id = x_profile_id and
224: PROFILE_ATTRIBUTE = x_PROFILE_ATTRIBUTE;
225:
226: IF (SQL%NOTFOUND) THEN