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.ARP_CTLS_PKG dependencies on DBMS_SQL

Line 200: | dbms_sql.bind_variable |

196: | |
197: | SCOPE - PRIVATE |
198: | |
199: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
200: | dbms_sql.bind_variable |
201: | arp_util.debug |
202: | |
203: | ARGUMENTS : IN: |
204: | p_update_cursor - ID of the update cursor |

Line 231: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',

227: /*------------------+
228: | Dummy constants |
229: +------------------*/
230:
231: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
232: AR_TEXT_DUMMY);
233:
234: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
235: AR_NUMBER_DUMMY);

Line 234: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',

230:
231: dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
232: AR_TEXT_DUMMY);
233:
234: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
235: AR_NUMBER_DUMMY);
236:
237: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
238: AR_DATE_DUMMY);

Line 237: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',

233:
234: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
235: AR_NUMBER_DUMMY);
236:
237: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
238: AR_DATE_DUMMY);
239:
240: /*------------------+
241: | WHO variables |

Line 244: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',

240: /*------------------+
241: | WHO variables |
242: +------------------*/
243:
244: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
245: pg_user_id);
246:
247: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
248: pg_login_id);

Line 247: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',

243:
244: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
245: pg_user_id);
246:
247: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
248: pg_login_id);
249:
250: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
251: pg_conc_login_id);

Line 250: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',

246:
247: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
248: pg_login_id);
249:
250: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
251: pg_conc_login_id);
252:
253:
254: /*----------------------------------------------+

Line 259: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',

255: | Bind variables for all columns in the table |
256: +----------------------------------------------*/
257:
258:
259: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',
260: p_srep_rec.cust_trx_line_salesrep_id);
261:
262: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
263: p_srep_rec.customer_trx_id);

Line 262: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',

258:
259: dbms_sql.bind_variable(p_update_cursor, ':cust_trx_line_salesrep_id',
260: p_srep_rec.cust_trx_line_salesrep_id);
261:
262: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
263: p_srep_rec.customer_trx_id);
264:
265: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
266: p_srep_rec.customer_trx_line_id);

Line 265: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',

261:
262: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
263: p_srep_rec.customer_trx_id);
264:
265: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
266: p_srep_rec.customer_trx_line_id);
267:
268: dbms_sql.bind_variable(p_update_cursor, ':salesrep_id',
269: p_srep_rec.salesrep_id);

Line 268: dbms_sql.bind_variable(p_update_cursor, ':salesrep_id',

264:
265: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
266: p_srep_rec.customer_trx_line_id);
267:
268: dbms_sql.bind_variable(p_update_cursor, ':salesrep_id',
269: p_srep_rec.salesrep_id);
270:
271: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount_split',
272: p_srep_rec.revenue_amount_split);

Line 271: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount_split',

267:
268: dbms_sql.bind_variable(p_update_cursor, ':salesrep_id',
269: p_srep_rec.salesrep_id);
270:
271: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount_split',
272: p_srep_rec.revenue_amount_split);
273:
274: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_amount_split',
275: p_srep_rec.non_revenue_amount_split);

Line 274: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_amount_split',

270:
271: dbms_sql.bind_variable(p_update_cursor, ':revenue_amount_split',
272: p_srep_rec.revenue_amount_split);
273:
274: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_amount_split',
275: p_srep_rec.non_revenue_amount_split);
276:
277: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_percent_split',
278: p_srep_rec.non_revenue_percent_split);

Line 277: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_percent_split',

273:
274: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_amount_split',
275: p_srep_rec.non_revenue_amount_split);
276:
277: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_percent_split',
278: p_srep_rec.non_revenue_percent_split);
279:
280: dbms_sql.bind_variable(p_update_cursor, ':revenue_percent_split',
281: p_srep_rec.revenue_percent_split);

Line 280: dbms_sql.bind_variable(p_update_cursor, ':revenue_percent_split',

276:
277: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_percent_split',
278: p_srep_rec.non_revenue_percent_split);
279:
280: dbms_sql.bind_variable(p_update_cursor, ':revenue_percent_split',
281: p_srep_rec.revenue_percent_split);
282:
283: dbms_sql.bind_variable(p_update_cursor, ':prev_cust_trx_line_salesrep_id',
284: p_srep_rec.prev_cust_trx_line_salesrep_id);

Line 283: dbms_sql.bind_variable(p_update_cursor, ':prev_cust_trx_line_salesrep_id',

279:
280: dbms_sql.bind_variable(p_update_cursor, ':revenue_percent_split',
281: p_srep_rec.revenue_percent_split);
282:
283: dbms_sql.bind_variable(p_update_cursor, ':prev_cust_trx_line_salesrep_id',
284: p_srep_rec.prev_cust_trx_line_salesrep_id);
285:
286: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
287: p_srep_rec.attribute_category);

Line 286: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',

282:
283: dbms_sql.bind_variable(p_update_cursor, ':prev_cust_trx_line_salesrep_id',
284: p_srep_rec.prev_cust_trx_line_salesrep_id);
285:
286: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
287: p_srep_rec.attribute_category);
288:
289: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
290: p_srep_rec.attribute1);

Line 289: dbms_sql.bind_variable(p_update_cursor, ':attribute1',

285:
286: dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
287: p_srep_rec.attribute_category);
288:
289: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
290: p_srep_rec.attribute1);
291:
292: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
293: p_srep_rec.attribute2);

Line 292: dbms_sql.bind_variable(p_update_cursor, ':attribute2',

288:
289: dbms_sql.bind_variable(p_update_cursor, ':attribute1',
290: p_srep_rec.attribute1);
291:
292: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
293: p_srep_rec.attribute2);
294:
295: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
296: p_srep_rec.attribute3);

Line 295: dbms_sql.bind_variable(p_update_cursor, ':attribute3',

291:
292: dbms_sql.bind_variable(p_update_cursor, ':attribute2',
293: p_srep_rec.attribute2);
294:
295: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
296: p_srep_rec.attribute3);
297:
298: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
299: p_srep_rec.attribute4);

Line 298: dbms_sql.bind_variable(p_update_cursor, ':attribute4',

294:
295: dbms_sql.bind_variable(p_update_cursor, ':attribute3',
296: p_srep_rec.attribute3);
297:
298: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
299: p_srep_rec.attribute4);
300:
301: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
302: p_srep_rec.attribute5);

Line 301: dbms_sql.bind_variable(p_update_cursor, ':attribute5',

297:
298: dbms_sql.bind_variable(p_update_cursor, ':attribute4',
299: p_srep_rec.attribute4);
300:
301: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
302: p_srep_rec.attribute5);
303:
304: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
305: p_srep_rec.attribute6);

Line 304: dbms_sql.bind_variable(p_update_cursor, ':attribute6',

300:
301: dbms_sql.bind_variable(p_update_cursor, ':attribute5',
302: p_srep_rec.attribute5);
303:
304: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
305: p_srep_rec.attribute6);
306:
307: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
308: p_srep_rec.attribute7);

Line 307: dbms_sql.bind_variable(p_update_cursor, ':attribute7',

303:
304: dbms_sql.bind_variable(p_update_cursor, ':attribute6',
305: p_srep_rec.attribute6);
306:
307: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
308: p_srep_rec.attribute7);
309:
310: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
311: p_srep_rec.attribute8);

Line 310: dbms_sql.bind_variable(p_update_cursor, ':attribute8',

306:
307: dbms_sql.bind_variable(p_update_cursor, ':attribute7',
308: p_srep_rec.attribute7);
309:
310: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
311: p_srep_rec.attribute8);
312:
313: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
314: p_srep_rec.attribute9);

Line 313: dbms_sql.bind_variable(p_update_cursor, ':attribute9',

309:
310: dbms_sql.bind_variable(p_update_cursor, ':attribute8',
311: p_srep_rec.attribute8);
312:
313: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
314: p_srep_rec.attribute9);
315:
316: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
317: p_srep_rec.attribute10);

Line 316: dbms_sql.bind_variable(p_update_cursor, ':attribute10',

312:
313: dbms_sql.bind_variable(p_update_cursor, ':attribute9',
314: p_srep_rec.attribute9);
315:
316: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
317: p_srep_rec.attribute10);
318:
319: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
320: p_srep_rec.attribute11);

Line 319: dbms_sql.bind_variable(p_update_cursor, ':attribute11',

315:
316: dbms_sql.bind_variable(p_update_cursor, ':attribute10',
317: p_srep_rec.attribute10);
318:
319: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
320: p_srep_rec.attribute11);
321:
322: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
323: p_srep_rec.attribute12);

Line 322: dbms_sql.bind_variable(p_update_cursor, ':attribute12',

318:
319: dbms_sql.bind_variable(p_update_cursor, ':attribute11',
320: p_srep_rec.attribute11);
321:
322: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
323: p_srep_rec.attribute12);
324:
325: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
326: p_srep_rec.attribute13);

Line 325: dbms_sql.bind_variable(p_update_cursor, ':attribute13',

321:
322: dbms_sql.bind_variable(p_update_cursor, ':attribute12',
323: p_srep_rec.attribute12);
324:
325: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
326: p_srep_rec.attribute13);
327:
328: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
329: p_srep_rec.attribute14);

Line 328: dbms_sql.bind_variable(p_update_cursor, ':attribute14',

324:
325: dbms_sql.bind_variable(p_update_cursor, ':attribute13',
326: p_srep_rec.attribute13);
327:
328: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
329: p_srep_rec.attribute14);
330:
331: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
332: p_srep_rec.attribute15);

Line 331: dbms_sql.bind_variable(p_update_cursor, ':attribute15',

327:
328: dbms_sql.bind_variable(p_update_cursor, ':attribute14',
329: p_srep_rec.attribute14);
330:
331: dbms_sql.bind_variable(p_update_cursor, ':attribute15',
332: p_srep_rec.attribute15);
333:
334: /* BEGIN bug 3067675 */
335:

Line 336: dbms_sql.bind_variable(p_update_cursor, ':revenue_salesgroup_id',

332: p_srep_rec.attribute15);
333:
334: /* BEGIN bug 3067675 */
335:
336: dbms_sql.bind_variable(p_update_cursor, ':revenue_salesgroup_id',
337: p_srep_rec.revenue_salesgroup_id);
338:
339: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_salesgroup_id',
340: p_srep_rec.non_revenue_salesgroup_id);

Line 339: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_salesgroup_id',

335:
336: dbms_sql.bind_variable(p_update_cursor, ':revenue_salesgroup_id',
337: p_srep_rec.revenue_salesgroup_id);
338:
339: dbms_sql.bind_variable(p_update_cursor, ':non_revenue_salesgroup_id',
340: p_srep_rec.non_revenue_salesgroup_id);
341:
342: /* END bug 3067675 */
343:

Line 344: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',

340: p_srep_rec.non_revenue_salesgroup_id);
341:
342: /* END bug 3067675 */
343:
344: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
345: p_srep_rec.last_update_date);
346:
347: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
348: p_srep_rec.last_updated_by);

Line 347: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',

343:
344: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
345: p_srep_rec.last_update_date);
346:
347: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
348: p_srep_rec.last_updated_by);
349:
350: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
351: p_srep_rec.creation_date);

Line 350: dbms_sql.bind_variable(p_update_cursor, ':creation_date',

346:
347: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
348: p_srep_rec.last_updated_by);
349:
350: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
351: p_srep_rec.creation_date);
352:
353: dbms_sql.bind_variable(p_update_cursor, ':created_by',
354: p_srep_rec.created_by);

Line 353: dbms_sql.bind_variable(p_update_cursor, ':created_by',

349:
350: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
351: p_srep_rec.creation_date);
352:
353: dbms_sql.bind_variable(p_update_cursor, ':created_by',
354: p_srep_rec.created_by);
355:
356: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
357: p_srep_rec.last_update_login);

Line 356: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',

352:
353: dbms_sql.bind_variable(p_update_cursor, ':created_by',
354: p_srep_rec.created_by);
355:
356: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
357: p_srep_rec.last_update_login);
358:
359: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
360: p_srep_rec.program_application_id);

Line 359: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',

355:
356: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
357: p_srep_rec.last_update_login);
358:
359: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
360: p_srep_rec.program_application_id);
361:
362: dbms_sql.bind_variable(p_update_cursor, ':program_id',
363: p_srep_rec.program_id);

Line 362: dbms_sql.bind_variable(p_update_cursor, ':program_id',

358:
359: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
360: p_srep_rec.program_application_id);
361:
362: dbms_sql.bind_variable(p_update_cursor, ':program_id',
363: p_srep_rec.program_id);
364:
365: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
366: p_srep_rec.program_update_date);

Line 365: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',

361:
362: dbms_sql.bind_variable(p_update_cursor, ':program_id',
363: p_srep_rec.program_id);
364:
365: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
366: p_srep_rec.program_update_date);
367:
368:
369: arp_util.debug('arp_ctls_pkg.bind_srep_variables()-');

Line 583: | dbms_sql.open_cursor |

579: | SCOPE - PRIVATE |
580: | |
581: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
582: | arp_util.debug |
583: | dbms_sql.open_cursor |
584: | dbms_sql.parse |
585: | dbms_sql.execute |
586: | dbms_sql.close_cursor |
587: | |

Line 584: | dbms_sql.parse |

580: | |
581: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
582: | arp_util.debug |
583: | dbms_sql.open_cursor |
584: | dbms_sql.parse |
585: | dbms_sql.execute |
586: | dbms_sql.close_cursor |
587: | |
588: | ARGUMENTS : IN: |

Line 585: | dbms_sql.execute |

581: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
582: | arp_util.debug |
583: | dbms_sql.open_cursor |
584: | dbms_sql.parse |
585: | dbms_sql.execute |
586: | dbms_sql.close_cursor |
587: | |
588: | ARGUMENTS : IN: |
589: | p_update_cursor - identifies the cursor to use |

Line 586: | dbms_sql.close_cursor |

582: | arp_util.debug |
583: | dbms_sql.open_cursor |
584: | dbms_sql.parse |
585: | dbms_sql.execute |
586: | dbms_sql.close_cursor |
587: | |
588: | ARGUMENTS : IN: |
589: | p_update_cursor - identifies the cursor to use |
590: | p_where_clause - identifies which rows to update |

Line 627: p_update_cursor := dbms_sql.open_cursor;

623:
624: IF (p_update_cursor IS NULL)
625: THEN
626:
627: p_update_cursor := dbms_sql.open_cursor;
628:
629: /*---------------------------------+
630: | Construct the update statement |
631: +---------------------------------*/

Line 641: dbms_sql.parse(p_update_cursor,

637: /*-----------------------------------------------+
638: | Parse, bind, execute and close the statement |
639: +-----------------------------------------------*/
640:
641: dbms_sql.parse(p_update_cursor,
642: l_update_statement,
643: dbms_sql.v7);
644:
645: END IF;

Line 643: dbms_sql.v7);

639: +-----------------------------------------------*/
640:
641: dbms_sql.parse(p_update_cursor,
642: l_update_statement,
643: dbms_sql.v7);
644:
645: END IF;
646:
647: arp_ctls_pkg.bind_srep_variables(p_update_cursor, p_srep_rec);

Line 653: dbms_sql.bind_variable(p_update_cursor, ':where_1',

649: /*-----------------------------------------+
650: | Bind the variables in the where clause |
651: +-----------------------------------------*/
652:
653: dbms_sql.bind_variable(p_update_cursor, ':where_1',
654: p_where1);
655:
656: l_count := dbms_sql.execute(p_update_cursor);
657:

Line 656: l_count := dbms_sql.execute(p_update_cursor);

652:
653: dbms_sql.bind_variable(p_update_cursor, ':where_1',
654: p_where1);
655:
656: l_count := dbms_sql.execute(p_update_cursor);
657:
658: arp_util.debug( to_char(l_count) || ' rows updated');
659:
660:

Line 669: dbms_sql.close_cursor(p_update_cursor);

665: IF (l_count = 0)
666: THEN RAISE NO_DATA_FOUND;
667: END IF;
668:
669: dbms_sql.close_cursor(p_update_cursor);
670:
671: arp_util.debug('arp_ctls_pkg.generic_update()-');
672:
673: EXCEPTION

Line 678: to_char(dbms_sql.last_error_position));

674: WHEN OTHERS THEN
675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');
676: arp_util.debug(l_update_statement);
677: arp_util.debug('Error at character: ' ||
678: to_char(dbms_sql.last_error_position));
679: IF dbms_sql.is_open( p_update_cursor ) THEN
680: dbms_sql.close_cursor( p_update_cursor );
681: END IF;
682:

Line 679: IF dbms_sql.is_open( p_update_cursor ) THEN

675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');
676: arp_util.debug(l_update_statement);
677: arp_util.debug('Error at character: ' ||
678: to_char(dbms_sql.last_error_position));
679: IF dbms_sql.is_open( p_update_cursor ) THEN
680: dbms_sql.close_cursor( p_update_cursor );
681: END IF;
682:
683: RAISE;

Line 680: dbms_sql.close_cursor( p_update_cursor );

676: arp_util.debug(l_update_statement);
677: arp_util.debug('Error at character: ' ||
678: to_char(dbms_sql.last_error_position));
679: IF dbms_sql.is_open( p_update_cursor ) THEN
680: dbms_sql.close_cursor( p_update_cursor );
681: END IF;
682:
683: RAISE;
684: END;