DBA Data[Home] [Help]

APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on FND_GLOBAL

Line 68: G_USER_ID := FND_GLOBAL.user_id;

64: G_PKG_NAME := NVL(G_PKG_NAME,'EGO_ITEM_ASSOCIATIONS_PUB');
65: --
66: -- user values
67: --
68: G_USER_ID := FND_GLOBAL.user_id;
69: G_LOGIN_ID := FND_GLOBAL.login_id;
70: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
71: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
72: G_PROG_ID := FND_GLOBAL.conc_program_id;

Line 69: G_LOGIN_ID := FND_GLOBAL.login_id;

65: --
66: -- user values
67: --
68: G_USER_ID := FND_GLOBAL.user_id;
69: G_LOGIN_ID := FND_GLOBAL.login_id;
70: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
71: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
72: G_PROG_ID := FND_GLOBAL.conc_program_id;
73: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);

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

66: -- user values
67: --
68: G_USER_ID := FND_GLOBAL.user_id;
69: G_LOGIN_ID := FND_GLOBAL.login_id;
70: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
71: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
72: G_PROG_ID := FND_GLOBAL.conc_program_id;
73: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
74: G_SESSION_LANG := USERENV('LANG');

Line 71: G_PROG_APPID := FND_GLOBAL.prog_appl_id;

67: --
68: G_USER_ID := FND_GLOBAL.user_id;
69: G_LOGIN_ID := FND_GLOBAL.login_id;
70: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
71: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
72: G_PROG_ID := FND_GLOBAL.conc_program_id;
73: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
74: G_SESSION_LANG := USERENV('LANG');
75: G_PARTY_ID := -1;

Line 72: G_PROG_ID := FND_GLOBAL.conc_program_id;

68: G_USER_ID := FND_GLOBAL.user_id;
69: G_LOGIN_ID := FND_GLOBAL.login_id;
70: G_REQUEST_ID := NVL(FND_GLOBAL.conc_request_id, -1);
71: G_PROG_APPID := FND_GLOBAL.prog_appl_id;
72: G_PROG_ID := FND_GLOBAL.conc_program_id;
73: G_SYSDATE := NVL(G_SYSDATE,SYSDATE);
74: G_SESSION_LANG := USERENV('LANG');
75: G_PARTY_ID := -1;
76: G_DATA_LEVEL_NAMES(1) := G_ITEM_SUP_LEVEL_NAME;

Line 90: WHERE USER_NAME = FND_GLOBAL.USER_NAME;

86: WHEN NO_DATA_FOUND THEN
87: SELECT party_id, user_id
88: INTO G_PARTY_ID, G_USER_ID
89: FROM ego_user_v
90: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
91: END;
92: EXCEPTION
93: WHEN OTHERS THEN
94: write_log_message(' After setting globals end' || SQLERRM);