DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_PVT dependencies on FND_GLOBAL

Line 153: G_USER_ID := FND_GLOBAL.user_id;

149: G_PKG_NAME := NVL(G_PKG_NAME,'EGO_ITEM_AML_PVT');
150: --
151: -- user values
152: --
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;

Line 154: G_LOGIN_ID := FND_GLOBAL.login_id;

150: --
151: -- user values
152: --
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
158: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);

Line 155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);

151: -- user values
152: --
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
158: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
159: G_SESSION_LANG := USERENV('LANG');

Line 156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;

152: --
153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
158: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
159: G_SESSION_LANG := USERENV('LANG');
160: BEGIN

Line 157: G_PROG_ID := FND_GLOBAL.conc_program_id;

153: G_USER_ID := FND_GLOBAL.user_id;
154: G_LOGIN_ID := FND_GLOBAL.login_id;
155: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
156: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
157: G_PROG_ID := FND_GLOBAL.conc_program_id;
158: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
159: G_SESSION_LANG := USERENV('LANG');
160: BEGIN
161: SELECT party_id, party_name

Line 171: WHERE USER_NAME = FND_GLOBAL.USER_NAME;

167: -- 3600938 sometimes user_id is not being retrieved
168: SELECT party_id, party_name, user_id
169: INTO G_PARTY_ID, G_PARTY_NAME, G_USER_ID
170: FROM ego_user_v
171: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
172: END;
173: --
174: -- error handler parameters
175: --