DBA Data[Home] [Help]

APPS.JTF_PERZ_QUERY_PVT dependencies on FND_GLOBAL

Line 27: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;

23: -- *****************************************************************************
24:
25: G_PKG_NAME CONSTANT VARCHAR2(30):='Jtf_Perz_Query_Pvt';
26: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfzvpqb.pls';
27: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
28: G_USER_ID NUMBER := Fnd_Global.USER_ID;
29:
30:
31: -- *****************************************************************************

Line 28: G_USER_ID NUMBER := Fnd_Global.USER_ID;

24:
25: G_PKG_NAME CONSTANT VARCHAR2(30):='Jtf_Perz_Query_Pvt';
26: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfzvpqb.pls';
27: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
28: G_USER_ID NUMBER := Fnd_Global.USER_ID;
29:
30:
31: -- *****************************************************************************
32: -- *****************************************************************************

Line 70: LAST_UPDATED_BY = Fnd_Global.USER_ID,

66: OBJECT_VERSION_NUMBER =
67: DECODE (p_OBJECT_VERSION_NUMBER, Fnd_Api.G_MISS_NUM,
68: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
69: LAST_UPDATE_DATE = SYSDATE,
70: LAST_UPDATED_BY = Fnd_Global.USER_ID,
71: LAST_UPDATE_LOGIN = Fnd_Global.CONC_LOGIN_ID
72: WHERE QUERY_ID = p_QUERY_ID
73: AND OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
74:

Line 71: LAST_UPDATE_LOGIN = Fnd_Global.CONC_LOGIN_ID

67: DECODE (p_OBJECT_VERSION_NUMBER, Fnd_Api.G_MISS_NUM,
68: OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1),
69: LAST_UPDATE_DATE = SYSDATE,
70: LAST_UPDATED_BY = Fnd_Global.USER_ID,
71: LAST_UPDATE_LOGIN = Fnd_Global.CONC_LOGIN_ID
72: WHERE QUERY_ID = p_QUERY_ID
73: AND OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
74:
75: IF (SQL%NOTFOUND) THEN