DBA Data[Home] [Help]

APPS.IEX_TRX_GRID_PVT dependencies on IEX_DELINQUENCIES_ALL

Line 54: l_sql_stmt := 'UPDATE iex_delinquencies_all SET unpaid_reason_code = :b_unpaid_reason ' ||

50: END IF;
51:
52: x_return_status := 'S';
53:
54: l_sql_stmt := 'UPDATE iex_delinquencies_all SET unpaid_reason_code = :b_unpaid_reason ' ||
55: ',last_update_date = SYSDATE ' ||
56: ',last_updated_by = :b_last_updated_by ' ||
57: ',last_update_login = :b_last_update_login ' ||
58: 'WHERE delinquency_id IN (' || p_del_ids || ')';

Line 136: UPDATE iex_delinquencies_all

132: END IF;
133:
134: x_return_status := 'S';
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