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.XDO_DGF_RPT_PKG dependencies on XDO_DGF_RPT_PKG

Line 1: PACKAGE BODY xdo_dgf_rpt_pkg as

1: PACKAGE BODY xdo_dgf_rpt_pkg as
2: /* $Header: XDODGFRPB.pls 120.0 2008/01/19 00:13:41 bgkim noship $ */
3:
4:
5: -- global private variables to store filtered lists

Line 197: 'xdo_dgf_rpt_pkg.get_context_reports.write_rule',

193: BEGIN
194:
195: IF (g_level_statement >= g_current_runtime_level ) THEN
196: FND_LOG.STRING(g_level_statement,
197: 'xdo_dgf_rpt_pkg.get_context_reports.write_rule',
198: 'write_rule START: p_rule_id = ' || p_rule_id);
199: END IF;
200:
201: -- find out whether the corresponding catalog rule is already recorded

Line 206: 'xdo_dgf_rpt_pkg.get_context_reports.write_rule',

202: IF NOT l_rule_table.exists(p_rule_id) THEN
203:
204: IF (g_level_statement >= g_current_runtime_level ) THEN
205: FND_LOG.STRING(g_level_statement,
206: 'xdo_dgf_rpt_pkg.get_context_reports.write_rule',
207: 'go to fetch new RULE record; id = ' || p_rule_id);
208: END IF;
209:
210: OPEN c_rule_catalog(p_rule_id);

Line 250: 'xdo_dgf_rpt_pkg.get_context_reports',

246:
247: BEGIN
248: IF (g_level_statement >= g_current_runtime_level ) THEN
249: FND_LOG.STRING(g_level_statement,
250: 'xdo_dgf_rpt_pkg.get_context_reports',
251: 'START: pp_form_code = ' || p_form_code
252: || ' p_block_code = ' || p_block_code);
253: END IF;
254:

Line 259: 'xdo_dgf_rpt_pkg.get_context_reports',

255: fnd_profile.get('RESP_ID',l_resp_id);
256:
257: IF (g_level_statement >= g_current_runtime_level ) THEN
258: FND_LOG.STRING(g_level_statement,
259: 'xdo_dgf_rpt_pkg.get_context_reports',
260: 'RESP_ID = ' || l_resp_id);
261: END IF;
262:
263: FOR rec IN c_contexts(l_resp_id)

Line 285: 'xdo_dgf_rpt_pkg.get_context_reports',

281: l_template_table(j).template_lang_territory_desc);
282:
283: IF (g_level_statement >= g_current_runtime_level ) THEN
284: FND_LOG.STRING(g_level_statement,
285: 'xdo_dgf_rpt_pkg.get_context_reports',
286: 'l_template_table(' || j || ').template_lang_territory_codes=' || l_template_table(j).template_lang_territory_codes || ';' ||
287: 'l_template_table(' || j || ').template_lang_territory_desc=' || l_template_table(j).template_lang_territory_desc);
288: END IF;
289:

Line 353: 'xdo_dgf_rpt_pkg.get_report_parameters',

349: c_params ref_cursor_type;
350: BEGIN
351: IF (g_level_statement >= g_current_runtime_level ) THEN
352: FND_LOG.STRING(g_level_statement,
353: 'xdo_dgf_rpt_pkg.get_report_parameters',
354: 'START');
355: END IF;
356:
357: FOR i IN 1..p_rpt_contexts.count LOOP

Line 386: 'xdo_dgf_rpt_pkg.get_report_parameters',

382: END LOOP;
383:
384: IF (g_level_statement >= g_current_runtime_level ) THEN
385: FND_LOG.STRING(g_level_statement,
386: 'xdo_dgf_rpt_pkg.get_report_parameters',
387: 'END: p_parameters.count = ' || p_parameters.count);
388: END IF;
389:
390: END;

Line 422: FUNCTION apply_tpl_rules(p_template_list XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE,

418: END;
419:
420: -- procedure apply_tpl_rules()
421: -- applies evaluated rules in g_rule_list on g_template_list
422: FUNCTION apply_tpl_rules(p_template_list XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE,
423: p_rule_list RULE_TABLE_TYPE,
424: p_tpl_rule_id_list TPL_RULE_ID_TABLE_TYPE)
425: RETURN XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE
426: IS

Line 425: RETURN XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE

421: -- applies evaluated rules in g_rule_list on g_template_list
422: FUNCTION apply_tpl_rules(p_template_list XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE,
423: p_rule_list RULE_TABLE_TYPE,
424: p_tpl_rule_id_list TPL_RULE_ID_TABLE_TYPE)
425: RETURN XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE
426: IS
427: l_template_list XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE;
428: l_result_value boolean;
429: -- vars for filtering allowed output formats

Line 427: l_template_list XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE;

423: p_rule_list RULE_TABLE_TYPE,
424: p_tpl_rule_id_list TPL_RULE_ID_TABLE_TYPE)
425: RETURN XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE
426: IS
427: l_template_list XDO_DGF_RPT_PKG.TPLT_TABLE_TYPE;
428: l_result_value boolean;
429: -- vars for filtering allowed output formats
430: l_result_value_PDF boolean;
431: l_result_value_RTF boolean;

Line 440: 'xdo_dgf_rpt_pkg.apply_tpl_rules',

436: j integer;
437: BEGIN
438: IF (g_level_statement >= g_current_runtime_level ) THEN
439: FND_LOG.STRING(g_level_statement,
440: 'xdo_dgf_rpt_pkg.apply_tpl_rules',
441: 'START ...p_template_list.count = ' || p_template_list.count);
442: END IF;
443:
444: FOR i IN 1..p_template_list.count

Line 458: 'xdo_dgf_rpt_pkg.apply_tpl_rules',

454: j := p_template_list(i).first_r_id;
455:
456: IF (g_level_statement >= g_current_runtime_level ) THEN
457: FND_LOG.STRING(g_level_statement,
458: 'xdo_dgf_rpt_pkg.apply_tpl_rules',
459: 'p_template_list(i).template_code = ' || p_template_list(i).template_code
460: || ' p_template_list(i).first_r_id = '|| p_template_list(i).first_r_id);
461: END IF;
462:

Line 482: 'xdo_dgf_rpt_pkg.apply_tpl_rules',

478: IF p_rule_list(p_tpl_rule_id_list(j).rule_id).return_value THEN
479:
480: IF (g_level_statement >= g_current_runtime_level ) THEN
481: FND_LOG.STRING(g_level_statement,
482: 'xdo_dgf_rpt_pkg.apply_tpl_rules',
483: 'j=' || j ||
484: ' p_rule_list(p_tpl_rule_id_list(j).rule_id).return_value = TRUE');
485: END IF;
486:

Line 491: 'xdo_dgf_rpt_pkg.apply_tpl_rules',

487: ELSE
488:
489: IF (g_level_statement >= g_current_runtime_level ) THEN
490: FND_LOG.STRING(g_level_statement,
491: 'xdo_dgf_rpt_pkg.apply_tpl_rules',
492: 'j=' || j ||
493: ' p_rule_list(p_tpl_rule_id_list(j).rule_id).return_value = FALSE');
494: END IF;
495:

Line 542: 'xdo_dgf_rpt_pkg.apply_tpl_rules',

538: return l_template_list;
539: --log('xxobl_report_pkg.apply_tpl_rules - END ...');
540: IF (g_level_statement >= g_current_runtime_level ) THEN
541: FND_LOG.STRING(g_level_statement,
542: 'xdo_dgf_rpt_pkg.apply_tpl_rules',
543: 'END');
544: END IF;
545:
546: end;

Line 550: l_report_list_final XDO_DGF_RPT_PKG.RPT_TABLE_TYPE;

546: end;
547:
548: PROCEDURE filter_templates(p_resolved_rule_list IN RULE_TABLE_TYPE)
549: IS
550: l_report_list_final XDO_DGF_RPT_PKG.RPT_TABLE_TYPE;
551: BEGIN
552: g_template_list := apply_tpl_rules(g_template_list,
553: xdo_dgf_rule_pkg.evaluate_rules(p_resolved_rule_list),
554: g_tpl_rule_id_list);

Line 559: 'xdo_dgf_rpt_pkg.filter_templates',

555:
556: -- remove reports with no templates
557: IF (g_level_statement >= g_current_runtime_level ) THEN
558: FND_LOG.STRING(g_level_statement,
559: 'xdo_dgf_rpt_pkg.filter_templates',
560: 'check for reports with no templates - start');
561: END IF;
562:
563: IF g_template_list.count > 0 THEN

Line 572: 'xdo_dgf_rpt_pkg.filter_templates',

568: l_no_more_templates BOOLEAN := false;
569: BEGIN
570: IF (g_level_statement >= g_current_runtime_level ) THEN
571: FND_LOG.STRING(g_level_statement,
572: 'xdo_dgf_rpt_pkg.filter_templates',
573: 'g_report_list.count = ' || g_report_list.count);
574: END IF;
575:
576: l_report_list_final.delete;

Line 598: 'xdo_dgf_rpt_pkg.filter_templates',

594: g_report_list := l_report_list_final;
595:
596: IF (g_level_statement >= g_current_runtime_level ) THEN
597: FND_LOG.STRING(g_level_statement,
598: 'xdo_dgf_rpt_pkg.filter_templates',
599: 'l_report_list_final.count = '|| l_report_list_final.count);
600: END IF;
601: END;
602: ELSE -- IF g_template_list.count > 0 THEN

Line 672: 'xdo_dgf_rpt_pkg.store_parameter_list',

668: BEGIN
669:
670: IF (g_level_statement >= g_current_runtime_level ) THEN
671: FND_LOG.STRING(g_level_statement,
672: 'xdo_dgf_rpt_pkg.store_parameter_list',
673: 'START: p_parameter_list.count = ' || p_parameter_list.count);
674: END IF;
675: g_parameter_list := p_parameter_list;
676: END;

Line 683: 'xdo_dgf_rpt_pkg.get_report_list',

679: IS
680: BEGIN
681: IF (g_level_statement >= g_current_runtime_level ) THEN
682: FND_LOG.STRING(g_level_statement,
683: 'xdo_dgf_rpt_pkg.get_report_list',
684: 'START: g_report_list.count = ' || g_report_list.count);
685: END IF;
686:
687: RETURN g_report_list;

Line 702: 'xdo_dgf_rpt_pkg.get_parameter_list',

698: BEGIN
699:
700: IF (g_level_statement >= g_current_runtime_level ) THEN
701: FND_LOG.STRING(g_level_statement,
702: 'xdo_dgf_rpt_pkg.get_parameter_list',
703: 'START2: g_parameter_list.count = ' || g_parameter_list.count);
704: END IF;
705:
706: RETURN g_parameter_list;

Line 715: 'xdo_dgf_rpt_pkg.get_rule_list',

711: BEGIN
712:
713: IF (g_level_statement >= g_current_runtime_level ) THEN
714: FND_LOG.STRING(g_level_statement,
715: 'xdo_dgf_rpt_pkg.get_rule_list',
716: 'START2: g_rule_list.count = ' || g_rule_list.count);
717: END IF;
718:
719: RETURN g_rule_list;

Line 830: 'xdo_dgf_rpt_pkg.get_report_list_o',

826: BEGIN
827:
828: IF (g_level_statement >= g_current_runtime_level ) THEN
829: FND_LOG.STRING(g_level_statement,
830: 'xdo_dgf_rpt_pkg.get_report_list_o',
831: 'g_report_list.count = '|| g_report_list.count);
832: END IF;
833:
834: FOR i in 1..g_report_list.count

Line 848: END XDO_DGF_RPT_PKG;

844:
845: RETURN l_report_list_o;
846: END;
847:
848: END XDO_DGF_RPT_PKG;