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 103: FROM pay_report_category_components

99: CURSOR csr_report_cat_comp_id(p_report_category_id IN NUMBER,
100: p_report_definition_id IN NUMBER,
101: p_business_group_id IN NUMBER) IS
102: SELECT style_sheet_variable_id
103: FROM pay_report_category_components
104: WHERE report_category_id = p_report_category_id
105: AND report_definition_id = p_report_definition_id
106: AND business_group_id = p_business_group_id
107: AND legislation_code IS NULL;

Line 129: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;

125: ln_report_category_id pay_report_categories.report_category_id%TYPE;
126: ln_report_category_id_new pay_report_categories.report_category_id%TYPE;
127: ln_report_definition_id pay_report_definitions.report_definition_id%TYPE;
128: ln_definition_id pay_report_definitions.report_definition_id%TYPE;
129: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;
130: ln_report_variable_id pay_report_variables.report_variable_id%TYPE;
131: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;
132: lv_lookup_type_meaning fnd_common_lookup_types.lookup_type_meaning%TYPE;
133: pn_report_category_comp_id pay_report_category_components.report_category_comp_id%TYPE;

Line 133: pn_report_category_comp_id pay_report_category_components.report_category_comp_id%TYPE;

129: ln_style_sheet_id pay_report_category_components.style_sheet_variable_id%TYPE;
130: ln_report_variable_id pay_report_variables.report_variable_id%TYPE;
131: pn_report_variable_id pay_report_variables.report_variable_id%TYPE;
132: lv_lookup_type_meaning fnd_common_lookup_types.lookup_type_meaning%TYPE;
133: pn_report_category_comp_id pay_report_category_components.report_category_comp_id%TYPE;
134:
135: BEGIN
136:
137: fnd_file.put_line(fnd_file.log,'Starting ....');

Line 231: dbms_output.put_line('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);

227: END IF;
228: END IF;
229: CLOSE csr_report_variable_id;
230: IF DEBUG_MODE THEN
231: dbms_output.put_line('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);
232: ELSE
233: DELETE FROM pay_report_category_components
234: WHERE style_sheet_variable_id = ln_style_sheet_id;
235: END IF;

Line 233: DELETE FROM pay_report_category_components

229: CLOSE csr_report_variable_id;
230: IF DEBUG_MODE THEN
231: dbms_output.put_line('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);
232: ELSE
233: DELETE FROM pay_report_category_components
234: WHERE style_sheet_variable_id = ln_style_sheet_id;
235: END IF;
236: END IF;
237: CLOSE csr_report_cat_comp_id;

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

257: p_report_variable_id => pn_report_variable_id);
258:
259: fnd_file.put_line(fnd_file.log,'Report Variable Id ' || pn_report_variable_id);
260:
261: fnd_file.put_line(fnd_file.log,'Inserting Record Into PAY_REPORT_CATEGORY_COMPONENTS');
262: fnd_file.put_line(fnd_file.log,'Category Id ' || ln_report_category_id_new);
263: fnd_file.put_line(fnd_file.log,'Definition Id ' || ln_definition_id);
264: fnd_file.put_line(fnd_file.log,'Style Sheet Id ' || pn_report_variable_id);
265: fnd_file.put_line(fnd_file.log,'Business Group Id ' || p_business_group_id);

Line 438: dbms_output.put_line('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) ' ||

434:
435: hr_utility.trace('Inserting report category component.');
436:
437: IF DEBUG_MODE THEN
438: dbms_output.put_line('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) ' ||
439: '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||','||
440: p_business_group_id||');');
441: ELSE
442: INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,

Line 442: INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,

438: dbms_output.put_line('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) ' ||
439: '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||','||
440: p_business_group_id||');');
441: ELSE
442: INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,
443: report_category_id,
444: report_definition_id,
445: breakout_variable_id,
446: order_by_variable_id,