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 144: l_display_flag psp_report_templates_h.display_all_emp_distrib_flag%TYPE;

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

Line 154: psp_report_templates_h prth,

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

Line 176: psp_report_templates_h prth,

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

Line 199: FROM psp_report_templates_h prt

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

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

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

Line 583: FROM psp_report_templates_h prt

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

Line 610: psp_report_templates_h prth

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

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

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

Line 1674: psp_report_templates_h prth

1670: per.template_id,
1671: per.set_of_books_id,
1672: prth.report_template_code
1673: FROM psp_eff_reports per,
1674: psp_report_templates_h prth
1675: WHERE per.request_id = p_request_id
1676: AND prth.request_id = per.request_id
1677: AND ROWNUM = 1;
1678:

Line 2165: FROM psp_report_templates_h prth

2161:
2162: CURSOR er_dates_cur IS
2163: SELECT fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_2)) start_date,
2164: fnd_date.canonical_to_date(fnd_date.date_to_canonical(prth.parameter_value_3)) end_date
2165: FROM psp_report_templates_h prth
2166: WHERE prth.request_id = p_request_id;
2167:
2168: l_start_date DATE;
2169: l_end_date DATE;