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.PSP_XMLGEN dependencies on PSP_REPORT_TEMPLATES_H

Line 17: FROM psp_report_templates_h

13: l_gl_sob NUMBER;
14:
15: CURSOR get_sob_cur IS
16: SELECT set_of_books_id
17: FROM psp_report_templates_h
18: WHERE request_id = p_request_id;
19:
20: CURSOR add_report_error_cur (p_sqlerrm IN VARCHAR2) IS
21: SELECT 1

Line 61: || 'FROM psp_report_templates_h prth, xdo_templates_tl xtt, '

57: || 'flv5.meaning sort_option3, flv6.meaning order_by3, flv7.meaning sort_option4, flv8.meaning order_by4, '
58: || 'DECODE(prth.initiator_person_id, -1, ''' || l_user_name || ''', '
59: || 'psp_general.get_person_name(prth.initiator_person_id, TRUNC(SYSDATE))) initiated_by, '
60: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') run_date '
61: || 'FROM psp_report_templates_h prth, xdo_templates_tl xtt, '
62: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv1, '
63: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv2, '
64: || '(select * from psp_layout_lookup_code_v where set_of_books_id in (-1, ' || TO_CHAR(l_gl_sob) || ')) flv3, '
65: || '(select * from fnd_lookup_values where language = ''' || l_language_code || ''' AND lookup_type = ''PSP_ORDERING_CRITERIA'') flv4, '

Line 142: l_display_flag psp_report_templates_h.display_all_emp_distrib_flag%TYPE;

138: l_investigator_org_name psp_eff_report_details.investigator_org_name%TYPE;
139: l_investigator_primary_org_id psp_eff_report_details.investigator_primary_org_id%TYPE;
140: l_total_pi_proposed_salary VARCHAR2(50);
141: l_total_pi_actual_salary VARCHAR2(50);
142: l_display_flag psp_report_templates_h.display_all_emp_distrib_flag%TYPE;
143: l_report_info VARCHAR2(4000);
144: l_icx_date_format VARCHAR2(20);
145:
146: CURSOR sort_option_cur (p_request_id IN NUMBER) IS

Line 152: psp_report_templates_h prth,

148: plo.value1 || ' ' || DECODE(prtdh.criteria_value2, 'A', 'ASC', 'DESC') sort_option,
149: ' ''' || flv1.meaning || ''' ' sort_option_description,
150: ' ''' || flv2.meaning || ''' ' order_by_description
151: FROM psp_report_template_details_h prtdh,
152: psp_report_templates_h prth,
153: fnd_lookup_values flv1,
154: fnd_lookup_values flv2,
155: psp_layout_options plo
156: WHERE prtdh.request_id = p_request_id

Line 174: psp_report_templates_h prth,

170: plo.value1 || ' ' || DECODE(prtdh.criteria_value2, 'A', 'ASC', 'DESC') sort_option,
171: ' ''' || flv1.meaning || ''' ' sort_option_description,
172: ' ''' || flv2.meaning || ''' ' order_by_description
173: FROM psp_report_template_details_h prtdh,
174: psp_report_templates_h prth,
175: fnd_lookup_values flv1,
176: fnd_lookup_values flv2,
177: psp_layout_options plo
178: WHERE prth.request_id = p_request_id

Line 197: FROM psp_report_templates_h prt

193:
194: CURSOR layout_type_cur IS
195: SELECT SUBSTR(report_template_code, 6, 3) layout_type,
196: display_all_emp_distrib_flag display_flag
197: FROM psp_report_templates_h prt
198: WHERE request_id = l_request_id;
199:
200: CURSOR nls_date_format_cur IS
201: SELECT value

Line 354: || 'FROM psp_report_templates_h prth WHERE prth.request_id = ' || TO_CHAR(l_request_id);

350: query1 := 'SELECT TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)), ''' || l_icx_date_format
351: || ''') start_date, TO_CHAR(fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)), '''
352: || l_icx_date_format || ''') end_date, ''' || l_display_flag || ''' display_flag, ''' || l_gl_header || ''' gl_header, '
353: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') run_date '
354: || 'FROM psp_report_templates_h prth WHERE prth.request_id = ' || TO_CHAR(l_request_id);
355: qryCtx1 := dbms_xmlgen.newContext(query1);
356: dbms_xmlgen.setRowTag(qryCtx1, NULL);
357: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
358: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);

Line 579: FROM psp_report_templates_h prt

575: l_layout_type CHAR(3);
576:
577: CURSOR layout_type_cur IS
578: SELECT SUBSTR(report_template_code, 6, 3) layout_type
579: FROM psp_report_templates_h prt
580: WHERE request_id = p_request_id;
581:
582: /*
583: CURSOR sort_option_cur (p_template_id IN NUMBER) IS

Line 606: psp_report_templates_h prth

602: select prtdh.criteria_value1,
603: decode (substr(prtdh.CRITERIA_LOOKUP_CODE,1,7),'SEGMENT','GL_'||prtdh.CRITERIA_LOOKUP_CODE,plo.VALUE1)
604: || ' ' || DECODE(criteria_value2, 'A', 'ASC', 'DESC') --decode plo.VALUE1
605: from psp_report_template_details_h prtdh ,
606: psp_report_templates_h prth
607: ,psp_layout_options plo
608: where prth.request_id= p_request_id-- 125338 --125188
609: and prth.request_id = prtdh.request_id
610: and prtdh.CRITERIA_LOOKUP_TYPE ='PSP_SORTING_CRITERIA'

Line 815: || 'psp_layout_options plo, fnd_lookup_values_vl lookup, psp_report_templates_h prth '

811: || 'TRIM(TO_CHAR(SUM(NVL(pera.actual_cost_share, 0)), ''999G990D00'')) total_actual_cost_share, '
812: || 'TRIM(MAX(lookup.lookup_code)) category_code, '
813: || 'TRIM(MAX(lookup.meaning)) category_desc '
814: || 'FROM psp_eff_report_details perd, psp_eff_report_approvals pera, '
815: || 'psp_layout_options plo, fnd_lookup_values_vl lookup, psp_report_templates_h prth '
816: || 'WHERE perd.grouping_category = plo.layout_lookup_code '
817: || 'AND plo.layout_lookup_code = lookup.lookup_code '
818: || 'AND plo.layout_lookup_type =''PSP_EFFORT_CATEGORY'' '
819: || 'AND lookup.lookup_type = ''PSP_EFFORT_CATEGORY'' '

Line 1662: psp_report_templates_h prth

1658: per.template_id,
1659: per.set_of_books_id,
1660: prth.report_template_code
1661: FROM psp_eff_reports per,
1662: psp_report_templates_h prth
1663: WHERE per.request_id = p_request_id
1664: AND prth.request_id = per.request_id
1665: AND ROWNUM = 1;
1666:

Line 2006: FROM psp_report_templates_h prth

2002:
2003: CURSOR er_dates_cur IS
2004: SELECT fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)) start_date,
2005: fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)) end_date
2006: FROM psp_report_templates_h prth
2007: WHERE prth.request_id = p_request_id;
2008:
2009: l_start_date DATE;
2010: l_end_date DATE;