APPS.JTF_PERZ_LF_PVT dependencies on FND_GLOBAL

Line 42: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

38: -- End of Comments
39:
40: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_LF_PVT';
41: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvplfb.pls';
42: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
43: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
44: --
45:
46: -- ****************************************************************************

Line 43: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

39:
40: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PERZ_LF_PVT';
41: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfvplfb.pls';
42: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
43: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
44: --
45:
46: -- ****************************************************************************
47: -- TABLE HANDLERS

Line 82: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

78: object_description, NULL, object_description, x_object_description),
79: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
80: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
81: LAST_UPDATE_DATE = SYSDATE,
82: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
83: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
84: WHERE object_id = x_object_id
85: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
86:

Line 83: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

79: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
80: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
81: LAST_UPDATE_DATE = SYSDATE,
82: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
83: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
84: WHERE object_id = x_object_id
85: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
86:
87: If (SQL%NOTFOUND) then

Line 118: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

114: OBJECT_TYPE_DESC,x_object_type_desc),
115: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
116: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
117: LAST_UPDATE_DATE = SYSDATE,
118: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
119: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
120: where object_type_id = x_object_type_id
121: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
122:

Line 119: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

115: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
116: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
117: LAST_UPDATE_DATE = SYSDATE,
118: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
119: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
120: where object_type_id = x_object_type_id
121: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
122:
123: If (SQL%NOTFOUND) then

Line 161: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

157: PRIORITY = decode( x_PRIORITY, FND_API.G_MISS_NUM,PRIORITY,x_PRIORITY),
158: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
159: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
160: LAST_UPDATE_DATE = SYSDATE,
161: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
162: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
163: where PERZ_LF_VALUE_ID = x_value_id;
164:
165: If (SQL%NOTFOUND) then

Line 162: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

158: OBJECT_VERSION_NUMBER = decode (p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
159: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
160: LAST_UPDATE_DATE = SYSDATE,
161: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
162: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
163: where PERZ_LF_VALUE_ID = x_value_id;
164:
165: If (SQL%NOTFOUND) then
166: RAISE NO_DATA_FOUND;