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_CORRECT_CCID dependencies on STANDARD

Line 64: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()+');

60:
61: BEGIN
62:
63: IF PG_DEBUG in ('Y', 'C') THEN
64: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()+');
65: arp_standard.debug(' p_distribution_id :' || to_char(p_distribution_id));
66: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
68: arp_standard.debug(' p_category_type :' || p_category_type);

Line 65: arp_standard.debug(' p_distribution_id :' || to_char(p_distribution_id));

61: BEGIN
62:
63: IF PG_DEBUG in ('Y', 'C') THEN
64: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()+');
65: arp_standard.debug(' p_distribution_id :' || to_char(p_distribution_id));
66: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
68: arp_standard.debug(' p_category_type :' || p_category_type);
69: arp_standard.debug(' p_dist_type:' || p_dist_type);

Line 66: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));

62:
63: IF PG_DEBUG in ('Y', 'C') THEN
64: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()+');
65: arp_standard.debug(' p_distribution_id :' || to_char(p_distribution_id));
66: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
68: arp_standard.debug(' p_category_type :' || p_category_type);
69: arp_standard.debug(' p_dist_type:' || p_dist_type);
70: arp_standard.debug(' p_parent_id:' || to_char(p_parent_id));

Line 67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));

63: IF PG_DEBUG in ('Y', 'C') THEN
64: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()+');
65: arp_standard.debug(' p_distribution_id :' || to_char(p_distribution_id));
66: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
68: arp_standard.debug(' p_category_type :' || p_category_type);
69: arp_standard.debug(' p_dist_type:' || p_dist_type);
70: arp_standard.debug(' p_parent_id:' || to_char(p_parent_id));
71: arp_standard.debug(' p_source_table: ' || p_source_table);

Line 68: arp_standard.debug(' p_category_type :' || p_category_type);

64: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()+');
65: arp_standard.debug(' p_distribution_id :' || to_char(p_distribution_id));
66: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
68: arp_standard.debug(' p_category_type :' || p_category_type);
69: arp_standard.debug(' p_dist_type:' || p_dist_type);
70: arp_standard.debug(' p_parent_id:' || to_char(p_parent_id));
71: arp_standard.debug(' p_source_table: ' || p_source_table);
72: END IF;

Line 69: arp_standard.debug(' p_dist_type:' || p_dist_type);

65: arp_standard.debug(' p_distribution_id :' || to_char(p_distribution_id));
66: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
68: arp_standard.debug(' p_category_type :' || p_category_type);
69: arp_standard.debug(' p_dist_type:' || p_dist_type);
70: arp_standard.debug(' p_parent_id:' || to_char(p_parent_id));
71: arp_standard.debug(' p_source_table: ' || p_source_table);
72: END IF;
73:

Line 70: arp_standard.debug(' p_parent_id:' || to_char(p_parent_id));

66: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
68: arp_standard.debug(' p_category_type :' || p_category_type);
69: arp_standard.debug(' p_dist_type:' || p_dist_type);
70: arp_standard.debug(' p_parent_id:' || to_char(p_parent_id));
71: arp_standard.debug(' p_source_table: ' || p_source_table);
72: END IF;
73:
74: /* should we initialize arp_global before use?? */

Line 71: arp_standard.debug(' p_source_table: ' || p_source_table);

67: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
68: arp_standard.debug(' p_category_type :' || p_category_type);
69: arp_standard.debug(' p_dist_type:' || p_dist_type);
70: arp_standard.debug(' p_parent_id:' || to_char(p_parent_id));
71: arp_standard.debug(' p_source_table: ' || p_source_table);
72: END IF;
73:
74: /* should we initialize arp_global before use?? */
75: -- arp_global.init;

Line 153: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()-');

149: AND source_table = p_source_table
150: AND submission_id IS NULL;
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()-');
154: END IF;
155:
156: EXCEPTION
157:

Line 160: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()');

156: EXCEPTION
157:
158: WHEN OTHERS THEN
159: IF PG_DEBUG in ('Y', 'C') THEN
160: arp_standard.debug('ARP_CORRECT_CCID.Correct_Lines_CCID()');
161: END IF;
162: RAISE;
163:
164: END Correct_Lines_CCID;

Line 201: arp_standard.debug(' ARP_CORRECT_CCID.lock_and_update()+');

197: l_status_code CONSTANT VARCHAR2(20) := 'IN_PROGRESS';
198:
199: BEGIN
200: IF PG_DEBUG in ('Y', 'C') THEN
201: arp_standard.debug(' ARP_CORRECT_CCID.lock_and_update()+');
202: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
203: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
204: arp_standard.debug(' p_category_type :' || p_category_type);
205: arp_standard.debug(' p_dist_type:' || p_dist_type);

Line 202: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));

198:
199: BEGIN
200: IF PG_DEBUG in ('Y', 'C') THEN
201: arp_standard.debug(' ARP_CORRECT_CCID.lock_and_update()+');
202: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
203: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
204: arp_standard.debug(' p_category_type :' || p_category_type);
205: arp_standard.debug(' p_dist_type:' || p_dist_type);
206: END IF;

Line 203: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));

199: BEGIN
200: IF PG_DEBUG in ('Y', 'C') THEN
201: arp_standard.debug(' ARP_CORRECT_CCID.lock_and_update()+');
202: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
203: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
204: arp_standard.debug(' p_category_type :' || p_category_type);
205: arp_standard.debug(' p_dist_type:' || p_dist_type);
206: END IF;
207:

Line 204: arp_standard.debug(' p_category_type :' || p_category_type);

200: IF PG_DEBUG in ('Y', 'C') THEN
201: arp_standard.debug(' ARP_CORRECT_CCID.lock_and_update()+');
202: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
203: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
204: arp_standard.debug(' p_category_type :' || p_category_type);
205: arp_standard.debug(' p_dist_type:' || p_dist_type);
206: END IF;
207:
208: /*---------------------------------------------------------------------+

Line 205: arp_standard.debug(' p_dist_type:' || p_dist_type);

201: arp_standard.debug(' ARP_CORRECT_CCID.lock_and_update()+');
202: arp_standard.debug(' p_old_ccid :' || to_char(p_old_ccid));
203: arp_standard.debug(' p_new_ccid :' || to_char(p_new_ccid));
204: arp_standard.debug(' p_category_type :' || p_category_type);
205: arp_standard.debug(' p_dist_type:' || p_dist_type);
206: END IF;
207:
208: /*---------------------------------------------------------------------+
209: | Undate rows with the new CCID based on the old ccid, trx code and |

Line 222: arp_standard.debug(' ARP_CORRECT_CCID.lock_and_update()-');

218: distribution_type = p_dist_type and
219: category_type = p_category_type;
220:
221: IF PG_DEBUG in ('Y', 'C') THEN
222: arp_standard.debug(' ARP_CORRECT_CCID.lock_and_update()-');
223: END IF;
224:
225: EXCEPTION
226:

Line 229: arp_standard.debug('EXCEPTION: ARP_CORRECT_CCID.lock_and_update()');

225: EXCEPTION
226:
227: WHEN OTHERS THEN
228: IF PG_DEBUG in ('Y', 'C') THEN
229: arp_standard.debug('EXCEPTION: ARP_CORRECT_CCID.lock_and_update()');
230: END IF;
231: RAISE;
232:
233: END lock_and_update;

Line 273: arp_standard.debug(' ARP_CORRECT_CCID.Correct_All_Invalid_CCID()+');

269: p_submission_id IN NUMBER) IS
270:
271: BEGIN
272: IF PG_DEBUG in ('Y', 'C') THEN
273: arp_standard.debug(' ARP_CORRECT_CCID.Correct_All_Invalid_CCID()+');
274: arp_standard.debug(' p_submission_id :' || p_submission_id);
275: END IF;
276:
277: /* Correct GL_DIST ccids */

Line 274: arp_standard.debug(' p_submission_id :' || p_submission_id);

270:
271: BEGIN
272: IF PG_DEBUG in ('Y', 'C') THEN
273: arp_standard.debug(' ARP_CORRECT_CCID.Correct_All_Invalid_CCID()+');
274: arp_standard.debug(' p_submission_id :' || p_submission_id);
275: END IF;
276:
277: /* Correct GL_DIST ccids */
278: UPDATE RA_CUST_TRX_LINE_GL_DIST gld

Line 296: arp_standard.debug(' ra_cust_trx_line_gl_dist rows updated: ' ||

292: WHERE submission_id = p_submission_id
293: AND source_table = 'GLD');
294:
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_standard.debug(' ra_cust_trx_line_gl_dist rows updated: ' ||
297: SQL%ROWCOUNT);
298: END IF;
299:
300: /* Correct AR_DISTRIBUTION ccids */

Line 319: arp_standard.debug(' ar_distribution rows updated: ' ||

315: WHERE submission_id = p_submission_id
316: AND source_table IN ('ADJ','CRH','RA','MCD','TH'));
317:
318: IF PG_DEBUG in ('Y', 'C') THEN
319: arp_standard.debug(' ar_distribution rows updated: ' ||
320: SQL%ROWCOUNT);
321: END IF;
322:
323: /* correct parent ADJ records */

Line 343: arp_standard.debug(' ar_adjustments rows updated: ' ||

339: AND source_table = 'ADJ'
340: AND distribution_type = 'ADJ');
341:
342: IF PG_DEBUG in ('Y', 'C') THEN
343: arp_standard.debug(' ar_adjustments rows updated: ' ||
344: SQL%ROWCOUNT);
345: END IF;
346:
347: /* correct parent CRH records */

Line 367: arp_standard.debug(' ar_cash_receipt_history rows updated: ' ||

363: AND source_table = 'CRH'
364: AND distribution_type = 'CASH');
365:
366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_standard.debug(' ar_cash_receipt_history rows updated: ' ||
368: SQL%ROWCOUNT);
369: END IF;
370:
371: /* correct parent MCD records */

Line 391: arp_standard.debug(' ar_misc_cash_distributions rows updated: ' ||

387: AND source_table = 'MCD'
388: AND distribution_type = 'MISCCASH');
389:
390: IF PG_DEBUG in ('Y', 'C') THEN
391: arp_standard.debug(' ar_misc_cash_distributions rows updated: ' ||
392: SQL%ROWCOUNT);
393: arp_standard.debug(' ARP_CORRECT_CCID.Correct_All_Invalid_CCID()-');
394: END IF;
395:

Line 393: arp_standard.debug(' ARP_CORRECT_CCID.Correct_All_Invalid_CCID()-');

389:
390: IF PG_DEBUG in ('Y', 'C') THEN
391: arp_standard.debug(' ar_misc_cash_distributions rows updated: ' ||
392: SQL%ROWCOUNT);
393: arp_standard.debug(' ARP_CORRECT_CCID.Correct_All_Invalid_CCID()-');
394: END IF;
395:
396: EXCEPTION
397: WHEN OTHERS THEN

Line 399: arp_standard.debug('EXCEPTION: ARP_CORRECT_CCID.Correct_All_Invalid_CCID()');

395:
396: EXCEPTION
397: WHEN OTHERS THEN
398: IF PG_DEBUG in ('Y', 'C') THEN
399: arp_standard.debug('EXCEPTION: ARP_CORRECT_CCID.Correct_All_Invalid_CCID()');
400: END IF;
401:
402: END Correct_All_Invalid_CCID;
403: