DBA Data[Home] [Help]

APPS.IEX_TRX_GRID_PUB dependencies on FND_PROFILE

Line 66: l_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),0);

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'
70: and lookup_code = c_unpaid_reason_code

Line 184: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

180: END IF;
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;