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: -- ****************************************************************************
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
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:
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
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:
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
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
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;