128: SELECT cur.precision
129: FROM gl_sets_of_books sob,
130: fnd_currencies cur
131: WHERE sob.currency_code = cur.currency_code
132: AND sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
133:
134: BEGIN
135:
136: -- This routine populate the interface table so the detail RXi report
203: sysdate creation_date,
204: p_user_id last_udpated_by,
205: sysdate last_update_date,
206: p_user_id last_update_login,
207: arp_standard.sysparm.set_of_books_id,
208: MAX(fnd_flex_ext.get_segs(
209: 'SQLGL',
210: 'GL#',
211: gcc.chart_of_accounts_id,
368:
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN
371: IF pg_debug in ('Y', 'C') THEN
372: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');
373: END IF;
374: RAISE;
375:
376: WHEN OTHERS THEN
374: RAISE;
375:
376: WHEN OTHERS THEN
377: IF pg_debug in ('Y', 'C') THEN
378: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');
379: END IF;
380: RAISE;
381:
382: END populate_rows;
406: SELECT cur.precision
407: FROM gl_sets_of_books sob,
408: fnd_currencies cur
409: WHERE sob.currency_code = cur.currency_code
410: AND sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
411:
412: CURSOR summary_rows IS
413: SELECT cogs_gl_account,
414: cogs_acct_description,
504: sysdate,
505: p_user_id,
506: sysdate,
507: p_user_id,
508: arp_standard.sysparm.set_of_books_id,
509: l_gl_acct_tbl(i),
510: l_gl_acct_desc_tbl(i),
511: l_cogs_adjustment_tbl(i)
512: );
529:
530: EXCEPTION
531: WHEN NO_DATA_FOUND THEN
532: IF pg_debug in ('Y', 'C') THEN
533: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');
534: END IF;
535: RAISE;
536:
537: WHEN OTHERS THEN
535: RAISE;
536:
537: WHEN OTHERS THEN
538: IF pg_debug in ('Y', 'C') THEN
539: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');
540: END IF;
541: RAISE;
542:
543: END populate_summary;
555: NULL;
556:
557: EXCEPTION
558: WHEN NO_DATA_FOUND THEN
559: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');
560: RAISE;
561:
562: WHEN OTHERS THEN
563: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');
559: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');
560: RAISE;
561:
562: WHEN OTHERS THEN
563: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');
564: RAISE;
565:
566: END arrx_cogs_rep_inner;