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.PAY_INS_CUSTOM_TEMPLATE dependencies on PAY_REPORT_CATEGORIES

Line 97: FROM pay_report_categories

93: p_category_short_name IN VARCHAR2,
94: p_business_group_id IN NUMBER
95: ) IS
96: SELECT report_category_id
97: FROM pay_report_categories
98: WHERE report_group_id = p_report_group_id
99: AND short_name = p_category_short_name
100: AND business_group_id = p_business_group_id
101: AND legislation_code IS NULL;

Line 134: ln_report_category_id pay_report_categories.report_category_id%TYPE;

130: lv_template_type_code xdo_templates_b.template_type_code%TYPE;
131: lv_rg_short_name fnd_common_lookups.description%TYPE;
132: lv_legislation_code hr_organization_information.org_information9%TYPE;
133: ln_report_group_id pay_report_groups.report_group_id%TYPE;
134: ln_report_category_id pay_report_categories.report_category_id%TYPE;
135: ln_report_category_id_new pay_report_categories.report_category_id%TYPE;
136: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
137: ln_definition_id pay_report_definitions.report_definition_id%TYPE;
138: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;

Line 135: ln_report_category_id_new pay_report_categories.report_category_id%TYPE;

131: lv_rg_short_name fnd_common_lookups.description%TYPE;
132: lv_legislation_code hr_organization_information.org_information9%TYPE;
133: ln_report_group_id pay_report_groups.report_group_id%TYPE;
134: ln_report_category_id pay_report_categories.report_category_id%TYPE;
135: ln_report_category_id_new pay_report_categories.report_category_id%TYPE;
136: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
137: ln_definition_id pay_report_definitions.report_definition_id%TYPE;
138: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;
139: ln_report_variable_id pay_report_variables.report_variable_id%TYPE;

Line 176: SELECT pay_report_categories_s.nextval INTO ln_report_category_id_new

172: WHEN OTHERS THEN
173: fnd_file.put_line(fnd_file.log,'Report Category Not Found : Please Contact Your Support Representative');
174: END;
175:
176: SELECT pay_report_categories_s.nextval INTO ln_report_category_id_new
177: FROM DUAL;
178: fnd_file.put_line(fnd_file.log,'New Category Id : ' || ln_report_category_id_new);
179: fnd_file.put_line(fnd_file.log,'+---------------------------------------------------------------------------+');
180:

Line 294: hr_utility.trace('DELETE FROM pay_report_categories WHERE report_category_id = ' || ln_report_category_id);

290: END LOOP;
291: CLOSE csr_get_temp_codes;
292:
293: IF DEBUG_MODE THEN
294: hr_utility.trace('DELETE FROM pay_report_categories WHERE report_category_id = ' || ln_report_category_id);
295: ELSE
296: DELETE FROM pay_report_categories
297: WHERE report_category_id = ln_report_category_id;
298: END IF;

Line 296: DELETE FROM pay_report_categories

292:
293: IF DEBUG_MODE THEN
294: hr_utility.trace('DELETE FROM pay_report_categories WHERE report_category_id = ' || ln_report_category_id);
295: ELSE
296: DELETE FROM pay_report_categories
297: WHERE report_category_id = ln_report_category_id;
298: END IF;
299:
300: fnd_file.put_line(fnd_file.log,'+---------------------------------------------------------------------------+');

Line 301: fnd_file.put_line(fnd_file.log,'Inserting Record Into PAY_REPORT_CATEGORIES');

297: WHERE report_category_id = ln_report_category_id;
298: END IF;
299:
300: fnd_file.put_line(fnd_file.log,'+---------------------------------------------------------------------------+');
301: fnd_file.put_line(fnd_file.log,'Inserting Record Into PAY_REPORT_CATEGORIES');
302: fnd_file.put_line(fnd_file.log,'Report Group Id ' || ln_report_group_id);
303: fnd_file.put_line(fnd_file.log,'Category Name ' || lv_lookup_type_meaning);
304: fnd_file.put_line(fnd_file.log,'Category Short Name ' || p_lookup_type_name);
305: fnd_file.put_line(fnd_file.log,'Business Group Id ' || p_business_group_id);

Line 489: hr_utility.trace('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||

485: hr_utility.trace('Entering '||l_proc_name);
486: hr_utility.trace('Inserting report category '|| p_short_name);
487:
488: IF DEBUG_MODE THEN
489: hr_utility.trace('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||
490: 'VALUES ('||p_report_category_id||','||p_report_group_id||','||p_category_name||','||p_short_name||','||p_legislation_code||','||p_business_group_id||');');
491: ELSE
492: INSERT INTO pay_report_categories(report_category_id,
493: report_group_id,

Line 492: INSERT INTO pay_report_categories(report_category_id,

488: IF DEBUG_MODE THEN
489: hr_utility.trace('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||
490: 'VALUES ('||p_report_category_id||','||p_report_group_id||','||p_category_name||','||p_short_name||','||p_legislation_code||','||p_business_group_id||');');
491: ELSE
492: INSERT INTO pay_report_categories(report_category_id,
493: report_group_id,
494: category_name,
495: short_name,
496: legislation_code,