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_CMA_PKG dependencies on DBMS_SQL

Line 168: | dbms_sql.bind_variable |

164: | |
165: | SCOPE - PRIVATE |
166: | |
167: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
168: | dbms_sql.bind_variable |
169: | arp_util.debug |
170: | |
171: | ARGUMENTS : IN: |
172: | p_update_cursor - ID of the update cursor |

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

195: /*------------------+
196: | Dummy constants |
197: +------------------*/
198:
199: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
200: AR_NUMBER_DUMMY);
201:
202: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
203: AR_DATE_DUMMY);

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

198:
199: dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
200: AR_NUMBER_DUMMY);
201:
202: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
203: AR_DATE_DUMMY);
204:
205: /*------------------+
206: | WHO variables |

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

205: /*------------------+
206: | WHO variables |
207: +------------------*/
208:
209: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
210: pg_user_id);
211:
212: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
213: pg_login_id);

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

208:
209: dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
210: pg_user_id);
211:
212: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
213: pg_login_id);
214:
215: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
216: pg_conc_login_id);

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

211:
212: dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
213: pg_login_id);
214:
215: dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
216: pg_conc_login_id);
217:
218:
219: /*----------------------------------------------+

Line 224: dbms_sql.bind_variable(p_update_cursor, ':credit_memo_amount_id',

220: | Bind variables for all columns in the table |
221: +----------------------------------------------*/
222:
223:
224: dbms_sql.bind_variable(p_update_cursor, ':credit_memo_amount_id',
225: p_cma_rec.credit_memo_amount_id);
226:
227: dbms_sql.bind_variable(p_update_cursor, ':credit_memo_amount_id',
228: p_cma_rec.credit_memo_amount_id);

Line 227: dbms_sql.bind_variable(p_update_cursor, ':credit_memo_amount_id',

223:
224: dbms_sql.bind_variable(p_update_cursor, ':credit_memo_amount_id',
225: p_cma_rec.credit_memo_amount_id);
226:
227: dbms_sql.bind_variable(p_update_cursor, ':credit_memo_amount_id',
228: p_cma_rec.credit_memo_amount_id);
229:
230: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
231: p_cma_rec.last_updated_by);

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

226:
227: dbms_sql.bind_variable(p_update_cursor, ':credit_memo_amount_id',
228: p_cma_rec.credit_memo_amount_id);
229:
230: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
231: p_cma_rec.last_updated_by);
232:
233: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
234: p_cma_rec.last_update_date);

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

229:
230: dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
231: p_cma_rec.last_updated_by);
232:
233: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
234: p_cma_rec.last_update_date);
235:
236: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
237: p_cma_rec.last_update_login);

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

232:
233: dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
234: p_cma_rec.last_update_date);
235:
236: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
237: p_cma_rec.last_update_login);
238:
239: dbms_sql.bind_variable(p_update_cursor, ':created_by',
240: p_cma_rec.created_by);

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

235:
236: dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
237: p_cma_rec.last_update_login);
238:
239: dbms_sql.bind_variable(p_update_cursor, ':created_by',
240: p_cma_rec.created_by);
241:
242: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
243: p_cma_rec.creation_date);

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

238:
239: dbms_sql.bind_variable(p_update_cursor, ':created_by',
240: p_cma_rec.created_by);
241:
242: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
243: p_cma_rec.creation_date);
244:
245: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
246: p_cma_rec.customer_trx_line_id);

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

241:
242: dbms_sql.bind_variable(p_update_cursor, ':creation_date',
243: p_cma_rec.creation_date);
244:
245: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
246: p_cma_rec.customer_trx_line_id);
247:
248: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
249: p_cma_rec.gl_date);

Line 248: dbms_sql.bind_variable(p_update_cursor, ':gl_date',

244:
245: dbms_sql.bind_variable(p_update_cursor, ':customer_trx_line_id',
246: p_cma_rec.customer_trx_line_id);
247:
248: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
249: p_cma_rec.gl_date);
250:
251: dbms_sql.bind_variable(p_update_cursor, ':amount',
252: p_cma_rec.amount);

Line 251: dbms_sql.bind_variable(p_update_cursor, ':amount',

247:
248: dbms_sql.bind_variable(p_update_cursor, ':gl_date',
249: p_cma_rec.gl_date);
250:
251: dbms_sql.bind_variable(p_update_cursor, ':amount',
252: p_cma_rec.amount);
253:
254: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
255: p_cma_rec.program_application_id);

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

250:
251: dbms_sql.bind_variable(p_update_cursor, ':amount',
252: p_cma_rec.amount);
253:
254: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
255: p_cma_rec.program_application_id);
256:
257: dbms_sql.bind_variable(p_update_cursor, ':program_id',
258: p_cma_rec.program_id);

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

253:
254: dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
255: p_cma_rec.program_application_id);
256:
257: dbms_sql.bind_variable(p_update_cursor, ':program_id',
258: p_cma_rec.program_id);
259:
260: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
261: p_cma_rec.program_update_date);

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

256:
257: dbms_sql.bind_variable(p_update_cursor, ':program_id',
258: p_cma_rec.program_id);
259:
260: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
261: p_cma_rec.program_update_date);
262:
263: dbms_sql.bind_variable(p_update_cursor, ':request_id',
264: p_cma_rec.request_id);

Line 263: dbms_sql.bind_variable(p_update_cursor, ':request_id',

259:
260: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
261: p_cma_rec.program_update_date);
262:
263: dbms_sql.bind_variable(p_update_cursor, ':request_id',
264: p_cma_rec.request_id);
265:
266:
267: arp_util.debug('arp_cma_pkg.bind_cma_variables()-');

Line 391: | dbms_sql.open_cursor |

387: | SCOPE - PRIVATE |
388: | |
389: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
390: | arp_util.debug |
391: | dbms_sql.open_cursor |
392: | dbms_sql.parse |
393: | dbms_sql.execute |
394: | dbms_sql.close_cursor |
395: | |

Line 392: | dbms_sql.parse |

388: | |
389: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
390: | arp_util.debug |
391: | dbms_sql.open_cursor |
392: | dbms_sql.parse |
393: | dbms_sql.execute |
394: | dbms_sql.close_cursor |
395: | |
396: | ARGUMENTS : IN: |

Line 393: | dbms_sql.execute |

389: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
390: | arp_util.debug |
391: | dbms_sql.open_cursor |
392: | dbms_sql.parse |
393: | dbms_sql.execute |
394: | dbms_sql.close_cursor |
395: | |
396: | ARGUMENTS : IN: |
397: | p_update_cursor - identifies the cursor to use |

Line 394: | dbms_sql.close_cursor |

390: | arp_util.debug |
391: | dbms_sql.open_cursor |
392: | dbms_sql.parse |
393: | dbms_sql.execute |
394: | dbms_sql.close_cursor |
395: | |
396: | ARGUMENTS : IN: |
397: | p_update_cursor - identifies the cursor to use |
398: | p_where_clause - identifies which rows to update |

Line 434: p_update_cursor := dbms_sql.open_cursor;

430:
431: IF (p_update_cursor IS NULL)
432: THEN
433:
434: p_update_cursor := dbms_sql.open_cursor;
435:
436: /*---------------------------------+
437: | Construct the update statement |
438: +---------------------------------*/

Line 448: dbms_sql.parse(p_update_cursor,

444: /*-----------------------------------------------+
445: | Parse, bind, execute and close the statement |
446: +-----------------------------------------------*/
447:
448: dbms_sql.parse(p_update_cursor,
449: l_update_statement,
450: dbms_sql.v7);
451:
452: END IF;

Line 450: dbms_sql.v7);

446: +-----------------------------------------------*/
447:
448: dbms_sql.parse(p_update_cursor,
449: l_update_statement,
450: dbms_sql.v7);
451:
452: END IF;
453:
454: arp_cma_pkg.bind_cma_variables(p_update_cursor, p_cma_rec);

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

456: /*-----------------------------------------+
457: | Bind the variables in the where clause |
458: +-----------------------------------------*/
459:
460: dbms_sql.bind_variable(p_update_cursor, ':where_1',
461: p_where1);
462:
463: l_count := dbms_sql.execute(p_update_cursor);
464:

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

459:
460: dbms_sql.bind_variable(p_update_cursor, ':where_1',
461: p_where1);
462:
463: l_count := dbms_sql.execute(p_update_cursor);
464:
465: arp_util.debug( to_char(l_count) || ' rows updated');
466:
467:

Line 484: to_char(dbms_sql.last_error_position));

480: WHEN OTHERS THEN
481: arp_util.debug('EXCEPTION: arp_cma_pkg.generic_update()');
482: arp_util.debug(l_update_statement);
483: arp_util.debug('Error at character: ' ||
484: to_char(dbms_sql.last_error_position));
485: RAISE;
486: END;
487:
488: /*===========================================================================+