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:
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
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:
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
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;
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;
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;
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;
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;