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_CATEGORY_COMPONENTS

Line 14: PAY_REPORT_CATEGORY_COMPONENTS AND PAY_REPORT_VARIABLES.

10: File payinscstmplt.pkb
11:
12: Purpose The purpose of this package is to register the user defined custom
13: Templates into Payroll Tables i.e. PAY_REPORT_CATEGORUES,
14: PAY_REPORT_CATEGORY_COMPONENTS AND PAY_REPORT_VARIABLES.
15:
16: Notes Currently this procedure supports the following concurrent programs
17: for which user defined custom templates can be registered :
18: 1. Local Year End Interface Extract

Line 112: FROM pay_report_category_components

108: CURSOR csr_report_cat_comp_id(p_report_category_id IN NUMBER,
109: p_report_definition_id IN NUMBER,
110: p_business_group_id IN NUMBER) IS
111: SELECT style_sheet_variable_id
112: FROM pay_report_category_components
113: WHERE report_category_id = p_report_category_id
114: AND report_definition_id = p_report_definition_id
115: AND business_group_id = p_business_group_id
116: AND legislation_code IS NULL;

Line 138: ln_style_sheet_id pay_report_category_components.style_sheet_variable_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;
140: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;
141: lv_lookup_type_meaning fnd_common_lookup_types.lookup_type_meaning%TYPE;
142: pn_report_category_comp_id pay_report_category_components.report_category_comp_id%TYPE;

Line 142: pn_report_category_comp_id pay_report_category_components.report_category_comp_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;
140: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;
141: lv_lookup_type_meaning fnd_common_lookup_types.lookup_type_meaning%TYPE;
142: pn_report_category_comp_id pay_report_category_components.report_category_comp_id%TYPE;
143:
144: BEGIN
145:
146: fnd_file.put_line(fnd_file.log,'Starting ....');

Line 240: hr_utility.trace('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);

236: END IF;
237: END IF;
238: CLOSE csr_report_variable_id;
239: IF DEBUG_MODE THEN
240: hr_utility.trace('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);
241: ELSE
242: DELETE FROM pay_report_category_components
243: WHERE style_sheet_variable_id = ln_style_sheet_id;
244: END IF;

Line 242: DELETE FROM pay_report_category_components

238: CLOSE csr_report_variable_id;
239: IF DEBUG_MODE THEN
240: hr_utility.trace('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);
241: ELSE
242: DELETE FROM pay_report_category_components
243: WHERE style_sheet_variable_id = ln_style_sheet_id;
244: END IF;
245: END IF;
246: CLOSE csr_report_cat_comp_id;

Line 270: fnd_file.put_line(fnd_file.log,'Inserting Record Into PAY_REPORT_CATEGORY_COMPONENTS');

266: p_report_variable_id => pn_report_variable_id);
267:
268: fnd_file.put_line(fnd_file.log,'Report Variable Id ' || pn_report_variable_id);
269:
270: fnd_file.put_line(fnd_file.log,'Inserting Record Into PAY_REPORT_CATEGORY_COMPONENTS');
271: fnd_file.put_line(fnd_file.log,'Category Id ' || ln_report_category_id_new);
272: fnd_file.put_line(fnd_file.log,'Definition Id ' || ln_definition_id);
273: fnd_file.put_line(fnd_file.log,'Style Sheet Id ' || pn_report_variable_id);
274: fnd_file.put_line(fnd_file.log,'Business Group Id ' || p_business_group_id);

Line 447: hr_utility.trace('INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,report_category_id,report_definition_id,breakout_variable_id,order_by_variable_id,style_sheet_variable_id,legislation_code,business_group_id) ' ||

443:
444: hr_utility.trace('Inserting report category component.');
445:
446: IF DEBUG_MODE THEN
447: hr_utility.trace('INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,report_category_id,report_definition_id,breakout_variable_id,order_by_variable_id,style_sheet_variable_id,legislation_code,business_group_id) ' ||
448: 'VALUES (' ||p_report_category_comp_id||','||p_report_category_id||','||p_report_definition_id||','||p_breakout_variable_id||','||p_order_by_variable_id||','||p_style_sheet_variable_id||','||NULL||','||
449: p_business_group_id||');');
450: ELSE
451: INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,

Line 451: INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,

447: hr_utility.trace('INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,report_category_id,report_definition_id,breakout_variable_id,order_by_variable_id,style_sheet_variable_id,legislation_code,business_group_id) ' ||
448: 'VALUES (' ||p_report_category_comp_id||','||p_report_category_id||','||p_report_definition_id||','||p_breakout_variable_id||','||p_order_by_variable_id||','||p_style_sheet_variable_id||','||NULL||','||
449: p_business_group_id||');');
450: ELSE
451: INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,
452: report_category_id,
453: report_definition_id,
454: breakout_variable_id,
455: order_by_variable_id,