DBA Data[Home] [Help]

APPS.IEX_TRX_GRID_PUB dependencies on FND_GLOBAL

Line 65: l_last_updated_by number := FND_GLOBAL.USER_ID;

61:
62: l_cnt NUMBER :=0 ;
63: l_sql_stmt VARCHAR2(32767);
64: l_cursor_id NUMBER;
65: l_last_updated_by number := FND_GLOBAL.USER_ID;
66: l_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),0);
67:
68: Cursor check_code(c_unpaid_reason_code varchar2) is
69: select count(*) from iex_lookups_v where lookup_type = 'IEX_UNPAID_REASON'

Line 185: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;

181: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
182: END Set_Unpaid_Reason;
183: BEGIN
184: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
185: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
186: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
187: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
188: G_USER_ID := FND_GLOBAL.User_Id;
189: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

Line 186: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;

182: END Set_Unpaid_Reason;
183: BEGIN
184: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
185: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
186: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
187: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
188: G_USER_ID := FND_GLOBAL.User_Id;
189: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
190: END IEX_TRX_GRID_PUB;

Line 187: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;

183: BEGIN
184: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
185: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
186: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
187: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
188: G_USER_ID := FND_GLOBAL.User_Id;
189: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
190: END IEX_TRX_GRID_PUB;

Line 188: G_USER_ID := FND_GLOBAL.User_Id;

184: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
185: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
186: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
187: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
188: G_USER_ID := FND_GLOBAL.User_Id;
189: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
190: END IEX_TRX_GRID_PUB;

Line 189: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

185: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
186: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
187: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
188: G_USER_ID := FND_GLOBAL.User_Id;
189: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
190: END IEX_TRX_GRID_PUB;