DBA Data[Home] [Help]

APPS.IEX_TRX_GRID_PVT dependencies on FND_GLOBAL

Line 65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);

61:
62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
69:

Line 66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);

62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
69:
70: -- Standard check of p_commit

Line 139: ,last_updated_by = FND_GLOBAL.USER_ID

135:
136: UPDATE iex_delinquencies_all
137: SET staged_dunning_level = p_stg_dunn_level
138: ,last_update_date = SYSDATE
139: ,last_updated_by = FND_GLOBAL.USER_ID
140: ,last_update_login = FND_GLOBAL.CONC_LOGIN_ID
141: ,dunning_level_override_date = SYSDATE
142: WHERE delinquency_id = p_delinquency_id;
143:

Line 140: ,last_update_login = FND_GLOBAL.CONC_LOGIN_ID

136: UPDATE iex_delinquencies_all
137: SET staged_dunning_level = p_stg_dunn_level
138: ,last_update_date = SYSDATE
139: ,last_updated_by = FND_GLOBAL.USER_ID
140: ,last_update_login = FND_GLOBAL.CONC_LOGIN_ID
141: ,dunning_level_override_date = SYSDATE
142: WHERE delinquency_id = p_delinquency_id;
143:
144: -- Standard check of p_commit

Line 176: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;

172: END SET_STAGED_DUNNING_LEVEL;
173:
174: BEGIN
175: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
176: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
177: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
178: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
179: G_USER_ID := FND_GLOBAL.User_Id;
180: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

Line 177: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;

173:
174: BEGIN
175: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
176: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
177: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
178: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
179: G_USER_ID := FND_GLOBAL.User_Id;
180: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
181: END IEX_TRX_GRID_PVT;

Line 178: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;

174: BEGIN
175: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
176: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
177: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
178: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
179: G_USER_ID := FND_GLOBAL.User_Id;
180: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
181: END IEX_TRX_GRID_PVT;

Line 179: G_USER_ID := FND_GLOBAL.User_Id;

175: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
176: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
177: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
178: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
179: G_USER_ID := FND_GLOBAL.User_Id;
180: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
181: END IEX_TRX_GRID_PVT;

Line 180: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

176: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
177: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
178: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
179: G_USER_ID := FND_GLOBAL.User_Id;
180: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
181: END IEX_TRX_GRID_PVT;