eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARRX_BSS dependencies on DBMS_SQL

Line 175: v_CursorID_main := DBMS_SQL.OPEN_CURSOR;

171: | Parse the main cursor |
172: +------------------------------------------------------------------*/
173:
174: -- Open the cursor for dynamic processing.
175: v_CursorID_main := DBMS_SQL.OPEN_CURSOR;
176:
177: -- Parse the main query.
178: DBMS_SQL.PARSE(v_CursorID_main, l_status, DBMS_SQL.native);
179:

Line 178: DBMS_SQL.PARSE(v_CursorID_main, l_status, DBMS_SQL.native);

174: -- Open the cursor for dynamic processing.
175: v_CursorID_main := DBMS_SQL.OPEN_CURSOR;
176:
177: -- Parse the main query.
178: DBMS_SQL.PARSE(v_CursorID_main, l_status, DBMS_SQL.native);
179:
180:
181: -- Bind variables for main cursor
182: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_status_date', p_as_of_date);

Line 182: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_status_date', p_as_of_date);

178: DBMS_SQL.PARSE(v_CursorID_main, l_status, DBMS_SQL.native);
179:
180:
181: -- Bind variables for main cursor
182: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_status_date', p_as_of_date);
183: -- If the MO Reporting Get Predicate function returns a bind variable then
184: -- we need to bind it.
185: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
186: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':p_reporting_entity_id', p_reporting_entity_id);

Line 186: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':p_reporting_entity_id', p_reporting_entity_id);

182: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':b_status_date', p_as_of_date);
183: -- If the MO Reporting Get Predicate function returns a bind variable then
184: -- we need to bind it.
185: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
186: DBMS_SQL.BIND_VARIABLE(v_CursorID_main, ':p_reporting_entity_id', p_reporting_entity_id);
187: END IF;
188:
189:
190: -- Define the output variables

Line 191: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_currency_code, 15);

187: END IF;
188:
189:
190: -- Define the output variables
191: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_currency_code, 15);
192: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_type, 20);
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_transaction_type_id);
194: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_status_code, 30);
195: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_status, 80);

Line 192: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_type, 20);

188:
189:
190: -- Define the output variables
191: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_currency_code, 15);
192: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_type, 20);
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_transaction_type_id);
194: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_status_code, 30);
195: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_status, 80);
196:

Line 193: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_transaction_type_id);

189:
190: -- Define the output variables
191: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_currency_code, 15);
192: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_type, 20);
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_transaction_type_id);
194: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_status_code, 30);
195: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_status, 80);
196:
197: -- Execute the statement. We're not concerned about the return

Line 194: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_status_code, 30);

190: -- Define the output variables
191: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_currency_code, 15);
192: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_type, 20);
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_transaction_type_id);
194: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_status_code, 30);
195: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_status, 80);
196:
197: -- Execute the statement. We're not concerned about the return
198: -- value, but we do need to declare a variable for it.

Line 195: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_status, 80);

191: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 1, v_currency_code, 15);
192: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 2, v_transaction_type, 20);
193: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 3, v_transaction_type_id);
194: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 4, v_status_code, 30);
195: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_status, 80);
196:
197: -- Execute the statement. We're not concerned about the return
198: -- value, but we do need to declare a variable for it.
199: v_Dummy_main := DBMS_SQL.EXECUTE(v_CursorID_main);

Line 199: v_Dummy_main := DBMS_SQL.EXECUTE(v_CursorID_main);

195: DBMS_SQL.DEFINE_COLUMN(v_CursorID_main, 5, v_status, 80);
196:
197: -- Execute the statement. We're not concerned about the return
198: -- value, but we do need to declare a variable for it.
199: v_Dummy_main := DBMS_SQL.EXECUTE(v_CursorID_main);
200:
201: -- This is the fetch loop.
202: LOOP
203:

Line 206: IF DBMS_SQL.FETCH_ROWS(v_CursorID_main) = 0 THEN

202: LOOP
203:
204: -- Fetch the rows into the buffer, and also check for the exit
205: -- condition from the loop.
206: IF DBMS_SQL.FETCH_ROWS(v_CursorID_main) = 0 THEN
207: EXIT;
208: END IF;
209:
210: -- Retrieve the rows from the buffer into PL/SQL variables.

Line 211: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_currency_code);

207: EXIT;
208: END IF;
209:
210: -- Retrieve the rows from the buffer into PL/SQL variables.
211: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_currency_code);
212: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_type);
213: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_transaction_type_id);
214: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_status_code);
215: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_status);

Line 212: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_type);

208: END IF;
209:
210: -- Retrieve the rows from the buffer into PL/SQL variables.
211: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_currency_code);
212: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_type);
213: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_transaction_type_id);
214: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_status_code);
215: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_status);
216:

Line 213: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_transaction_type_id);

209:
210: -- Retrieve the rows from the buffer into PL/SQL variables.
211: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_currency_code);
212: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_type);
213: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_transaction_type_id);
214: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_status_code);
215: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_status);
216:
217: /*------------------------------------------------------------------+

Line 214: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_status_code);

210: -- Retrieve the rows from the buffer into PL/SQL variables.
211: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_currency_code);
212: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_type);
213: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_transaction_type_id);
214: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_status_code);
215: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_status);
216:
217: /*------------------------------------------------------------------+
218: | Amount cursor |

Line 215: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_status);

211: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 1, v_currency_code);
212: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 2, v_transaction_type);
213: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 3, v_transaction_type_id);
214: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 4, v_status_code);
215: DBMS_SQL.COLUMN_VALUE(v_CursorID_main, 5, v_status);
216:
217: /*------------------------------------------------------------------+
218: | Amount cursor |
219: +------------------------------------------------------------------*/

Line 222: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;

218: | Amount cursor |
219: +------------------------------------------------------------------*/
220:
221: -- Open the cursor for dynamic processing.
222: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;
223:
224: -- Parse the amt query.
225: DBMS_SQL.PARSE(v_CursorID_amt, l_amount, DBMS_SQL.native);
226:

Line 225: DBMS_SQL.PARSE(v_CursorID_amt, l_amount, DBMS_SQL.native);

221: -- Open the cursor for dynamic processing.
222: v_CursorID_amt := DBMS_SQL.OPEN_CURSOR;
223:
224: -- Parse the amt query.
225: DBMS_SQL.PARSE(v_CursorID_amt, l_amount, DBMS_SQL.native);
226:
227: -- Bind variables for amt cursor
228: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_date', p_as_of_date);
229: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_currency_code', v_currency_code);

Line 228: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_date', p_as_of_date);

224: -- Parse the amt query.
225: DBMS_SQL.PARSE(v_CursorID_amt, l_amount, DBMS_SQL.native);
226:
227: -- Bind variables for amt cursor
228: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_date', p_as_of_date);
229: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_currency_code', v_currency_code);
230: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_code', v_status_code);
231: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_transaction_type_id', v_transaction_type_id);
232:

Line 229: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_currency_code', v_currency_code);

225: DBMS_SQL.PARSE(v_CursorID_amt, l_amount, DBMS_SQL.native);
226:
227: -- Bind variables for amt cursor
228: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_date', p_as_of_date);
229: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_currency_code', v_currency_code);
230: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_code', v_status_code);
231: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_transaction_type_id', v_transaction_type_id);
232:
233: -- If the MO Reporting Get Predicate function returns a bind variable then

Line 230: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_code', v_status_code);

226:
227: -- Bind variables for amt cursor
228: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_date', p_as_of_date);
229: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_currency_code', v_currency_code);
230: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_code', v_status_code);
231: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_transaction_type_id', v_transaction_type_id);
232:
233: -- If the MO Reporting Get Predicate function returns a bind variable then
234: -- we need to bind it.

Line 231: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_transaction_type_id', v_transaction_type_id);

227: -- Bind variables for amt cursor
228: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_date', p_as_of_date);
229: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_currency_code', v_currency_code);
230: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_status_code', v_status_code);
231: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':b_transaction_type_id', v_transaction_type_id);
232:
233: -- If the MO Reporting Get Predicate function returns a bind variable then
234: -- we need to bind it.
235: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN

Line 236: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':p_reporting_entity_id', p_reporting_entity_id);

232:
233: -- If the MO Reporting Get Predicate function returns a bind variable then
234: -- we need to bind it.
235: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
236: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':p_reporting_entity_id', p_reporting_entity_id);
237: END IF;
238:
239: -- Define the output variables
240: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_balance_due);

Line 240: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_balance_due);

236: DBMS_SQL.BIND_VARIABLE(v_CursorID_amt, ':p_reporting_entity_id', p_reporting_entity_id);
237: END IF;
238:
239: -- Define the output variables
240: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_balance_due);
241: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 2, v_functional_balance_due);
242: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 3, v_customer_trx_id);
243: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 4, v_ps_exchange_rate);
244:

Line 241: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 2, v_functional_balance_due);

237: END IF;
238:
239: -- Define the output variables
240: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_balance_due);
241: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 2, v_functional_balance_due);
242: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 3, v_customer_trx_id);
243: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 4, v_ps_exchange_rate);
244:
245: -- Execute the statement.

Line 242: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 3, v_customer_trx_id);

238:
239: -- Define the output variables
240: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_balance_due);
241: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 2, v_functional_balance_due);
242: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 3, v_customer_trx_id);
243: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 4, v_ps_exchange_rate);
244:
245: -- Execute the statement.
246: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);

Line 243: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 4, v_ps_exchange_rate);

239: -- Define the output variables
240: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 1, v_balance_due);
241: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 2, v_functional_balance_due);
242: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 3, v_customer_trx_id);
243: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 4, v_ps_exchange_rate);
244:
245: -- Execute the statement.
246: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
247:

Line 246: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);

242: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 3, v_customer_trx_id);
243: DBMS_SQL.DEFINE_COLUMN(v_CursorID_amt, 4, v_ps_exchange_rate);
244:
245: -- Execute the statement.
246: v_Dummy_amt := DBMS_SQL.EXECUTE(v_CursorID_amt);
247:
248: -- Initalise variables
249: l_balance_due := 0;
250: l_functional_balance_due := 0;

Line 258: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) = 0 THEN

254: LOOP
255:
256: -- Fetch the rows into the buffer, and also check for the exit
257: -- condition from the loop.
258: IF DBMS_SQL.FETCH_ROWS(v_CursorID_amt) = 0 THEN
259: EXIT;
260: END IF;
261:
262: -- Retrieve the rows from the buffer into PL/SQL variables.

Line 263: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_balance_due);

259: EXIT;
260: END IF;
261:
262: -- Retrieve the rows from the buffer into PL/SQL variables.
263: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_balance_due);
264: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 2, v_functional_balance_due);
265: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 3, v_customer_trx_id);
266: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 4, v_ps_exchange_rate);
267:

Line 264: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 2, v_functional_balance_due);

260: END IF;
261:
262: -- Retrieve the rows from the buffer into PL/SQL variables.
263: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_balance_due);
264: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 2, v_functional_balance_due);
265: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 3, v_customer_trx_id);
266: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 4, v_ps_exchange_rate);
267:
268: l_balance_due := l_balance_due + v_balance_due;

Line 265: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 3, v_customer_trx_id);

261:
262: -- Retrieve the rows from the buffer into PL/SQL variables.
263: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_balance_due);
264: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 2, v_functional_balance_due);
265: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 3, v_customer_trx_id);
266: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 4, v_ps_exchange_rate);
267:
268: l_balance_due := l_balance_due + v_balance_due;
269: l_functional_balance_due := l_functional_balance_due + v_functional_balance_due;

Line 266: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 4, v_ps_exchange_rate);

262: -- Retrieve the rows from the buffer into PL/SQL variables.
263: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 1, v_balance_due);
264: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 2, v_functional_balance_due);
265: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 3, v_customer_trx_id);
266: DBMS_SQL.COLUMN_VALUE(v_CursorID_amt, 4, v_ps_exchange_rate);
267:
268: l_balance_due := l_balance_due + v_balance_due;
269: l_functional_balance_due := l_functional_balance_due + v_functional_balance_due;
270: l_count := l_count +1;

Line 285: v_CursorID_app := DBMS_SQL.OPEN_CURSOR;

281: l_applied_amount := null;
282: l_functional_applied_amount := null;
283:
284: -- Open the cursor for dynamic processing.
285: v_CursorID_app := DBMS_SQL.OPEN_CURSOR;
286:
287: -- Parse the amt query.
288: DBMS_SQL.PARSE(v_CursorID_app, l_applied, DBMS_SQL.native);
289:

Line 288: DBMS_SQL.PARSE(v_CursorID_app, l_applied, DBMS_SQL.native);

284: -- Open the cursor for dynamic processing.
285: v_CursorID_app := DBMS_SQL.OPEN_CURSOR;
286:
287: -- Parse the amt query.
288: DBMS_SQL.PARSE(v_CursorID_app, l_applied, DBMS_SQL.native);
289:
290: -- Bind variables for applied cursor
291: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':b_as_of_date', p_as_of_date);
292: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':b_trx_id', v_customer_trx_id);

Line 291: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':b_as_of_date', p_as_of_date);

287: -- Parse the amt query.
288: DBMS_SQL.PARSE(v_CursorID_app, l_applied, DBMS_SQL.native);
289:
290: -- Bind variables for applied cursor
291: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':b_as_of_date', p_as_of_date);
292: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':b_trx_id', v_customer_trx_id);
293:
294: -- If the MO Reporting Get Predicate function returns a bind variable then
295: -- we need to bind it.

Line 292: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':b_trx_id', v_customer_trx_id);

288: DBMS_SQL.PARSE(v_CursorID_app, l_applied, DBMS_SQL.native);
289:
290: -- Bind variables for applied cursor
291: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':b_as_of_date', p_as_of_date);
292: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':b_trx_id', v_customer_trx_id);
293:
294: -- If the MO Reporting Get Predicate function returns a bind variable then
295: -- we need to bind it.
296: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN

Line 297: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':p_reporting_entity_id', p_reporting_entity_id);

293:
294: -- If the MO Reporting Get Predicate function returns a bind variable then
295: -- we need to bind it.
296: IF l_org_where_trx like '%:p_reporting_entity_id%' THEN
297: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':p_reporting_entity_id', p_reporting_entity_id);
298: END IF;
299:
300: -- Define the output variables
301: DBMS_SQL.DEFINE_COLUMN(v_CursorID_app, 1, l_applied_amount);

Line 301: DBMS_SQL.DEFINE_COLUMN(v_CursorID_app, 1, l_applied_amount);

297: DBMS_SQL.BIND_VARIABLE(v_CursorID_app, ':p_reporting_entity_id', p_reporting_entity_id);
298: END IF;
299:
300: -- Define the output variables
301: DBMS_SQL.DEFINE_COLUMN(v_CursorID_app, 1, l_applied_amount);
302:
303: -- Execute the statement.
304: v_Dummy_app := DBMS_SQL.EXECUTE(v_CursorID_app);
305:

Line 304: v_Dummy_app := DBMS_SQL.EXECUTE(v_CursorID_app);

300: -- Define the output variables
301: DBMS_SQL.DEFINE_COLUMN(v_CursorID_app, 1, l_applied_amount);
302:
303: -- Execute the statement.
304: v_Dummy_app := DBMS_SQL.EXECUTE(v_CursorID_app);
305:
306: -- This is the fetch loop.
307: LOOP
308:

Line 311: IF DBMS_SQL.FETCH_ROWS(v_CursorID_app) = 0 THEN

307: LOOP
308:
309: -- Fetch the rows into the buffer, and also check for the exit
310: -- condition from the loop.
311: IF DBMS_SQL.FETCH_ROWS(v_CursorID_app) = 0 THEN
312: EXIT;
313: END IF;
314:
315: -- Retrieve the rows from the buffer into PL/SQL variables.

Line 316: DBMS_SQL.COLUMN_VALUE(v_CursorID_app, 1, l_applied_amount);

312: EXIT;
313: END IF;
314:
315: -- Retrieve the rows from the buffer into PL/SQL variables.
316: DBMS_SQL.COLUMN_VALUE(v_CursorID_app, 1, l_applied_amount);
317:
318: -- Add to open amounts
319: IF l_applied_amount IS NOT NULL THEN
320: l_balance_due := l_balance_due + l_applied_amount;

Line 345: IF DBMS_SQL.IS_OPEN(v_CursorID_app) THEN

341:
342: -- End loop for Applied Amounts
343: END LOOP;
344:
345: IF DBMS_SQL.IS_OPEN(v_CursorID_app) THEN
346: DBMS_SQL.CLOSE_CURSOR(v_CursorID_app);
347: END IF;
348:
349: -- End loop for Amounts

Line 346: DBMS_SQL.CLOSE_CURSOR(v_CursorID_app);

342: -- End loop for Applied Amounts
343: END LOOP;
344:
345: IF DBMS_SQL.IS_OPEN(v_CursorID_app) THEN
346: DBMS_SQL.CLOSE_CURSOR(v_CursorID_app);
347: END IF;
348:
349: -- End loop for Amounts
350: END LOOP;

Line 352: IF DBMS_SQL.IS_OPEN(v_CursorID_amt) THEN

348:
349: -- End loop for Amounts
350: END LOOP;
351:
352: IF DBMS_SQL.IS_OPEN(v_CursorID_amt) THEN
353: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
354: END IF;
355:
356: /*------------------------------------------------------------------+

Line 353: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);

349: -- End loop for Amounts
350: END LOOP;
351:
352: IF DBMS_SQL.IS_OPEN(v_CursorID_amt) THEN
353: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
354: END IF;
355:
356: /*------------------------------------------------------------------+
357: | Insert Data into Interface Table |

Line 402: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

398:
399: END LOOP;
400:
401: -- Close the cursor.
402: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
403:
404: -- Update status variables to successful completion
405: retcode := 0;
406: errbuf := '';

Line 414: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN

410:
411: EXCEPTION
412: WHEN OTHERS THEN
413: -- Close the cursors, then raise the error again.
414: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
415: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
416: END IF;
417:
418: IF DBMS_SQL.IS_OPEN (v_CursorID_app) THEN

Line 415: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);

411: EXCEPTION
412: WHEN OTHERS THEN
413: -- Close the cursors, then raise the error again.
414: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
415: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
416: END IF;
417:
418: IF DBMS_SQL.IS_OPEN (v_CursorID_app) THEN
419: DBMS_SQL.CLOSE_CURSOR(v_CursorID_app);

Line 418: IF DBMS_SQL.IS_OPEN (v_CursorID_app) THEN

414: IF DBMS_SQL.IS_OPEN (v_CursorID_amt) THEN
415: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
416: END IF;
417:
418: IF DBMS_SQL.IS_OPEN (v_CursorID_app) THEN
419: DBMS_SQL.CLOSE_CURSOR(v_CursorID_app);
420: END IF;
421:
422: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

Line 419: DBMS_SQL.CLOSE_CURSOR(v_CursorID_app);

415: DBMS_SQL.CLOSE_CURSOR(v_CursorID_amt);
416: END IF;
417:
418: IF DBMS_SQL.IS_OPEN (v_CursorID_app) THEN
419: DBMS_SQL.CLOSE_CURSOR(v_CursorID_app);
420: END IF;
421:
422: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
423: RAISE;

Line 422: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);

418: IF DBMS_SQL.IS_OPEN (v_CursorID_app) THEN
419: DBMS_SQL.CLOSE_CURSOR(v_CursorID_app);
420: END IF;
421:
422: DBMS_SQL.CLOSE_CURSOR(v_CursorID_main);
423: RAISE;
424: END arrxbss_report;
425:
426: END arrx_bss;