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_VARIABLES

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 121: FROM pay_report_variables

117:
118: CURSOR csr_report_variable_id(p_report_variable_id IN NUMBER,
119: p_business_group_id IN NUMBER) IS
120: SELECT report_variable_id
121: FROM pay_report_variables
122: WHERE report_variable_id = p_report_variable_id
123: AND business_group_id = p_business_group_id
124: AND legislation_code IS NULL;
125:

Line 139: ln_report_variable_id pay_report_variables.report_variable_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;
143:

Line 140: pn_report_variable_id pay_report_variables.report_variable_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;
143:
144: BEGIN

Line 232: hr_utility.trace('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);

228: FETCH csr_report_variable_id INTO ln_report_variable_id;
229: IF csr_report_variable_id%FOUND THEN
230: fnd_file.put_line(fnd_file.log,'Removing Variable Id : ' || ln_style_sheet_id);
231: IF DEBUG_MODE THEN
232: hr_utility.trace('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);
233: ELSE
234: DELETE FROM pay_report_variables
235: WHERE report_variable_id = ln_report_variable_id;
236: END IF;

Line 234: DELETE FROM pay_report_variables

230: fnd_file.put_line(fnd_file.log,'Removing Variable Id : ' || ln_style_sheet_id);
231: IF DEBUG_MODE THEN
232: hr_utility.trace('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);
233: ELSE
234: DELETE FROM pay_report_variables
235: WHERE report_variable_id = ln_report_variable_id;
236: END IF;
237: END IF;
238: CLOSE csr_report_variable_id;

Line 255: fnd_file.put_line(fnd_file.log,'Inserting Record Into PAY_REPORT_VARIABLES');

251:
252: ln_definition_id := get_definition_id(ln_report_group_id,lv_template_type_code,lv_template_code);
253:
254: fnd_file.put_line(fnd_file.log,'+---------------------------------------------------------------------------+');
255: fnd_file.put_line(fnd_file.log,'Inserting Record Into PAY_REPORT_VARIABLES');
256: fnd_file.put_line(fnd_file.log,'Definition Id ' || ln_definition_id);
257: fnd_file.put_line(fnd_file.log,'Template Name ' || lv_template_name);
258: fnd_file.put_line(fnd_file.log,'Template Code ' || lv_template_code);
259: fnd_file.put_line(fnd_file.log,'Business Group Id ' || p_business_group_id);

Line 400: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;

396: l_proc_name := 'INSERT_REPORT_VARIABLE';
397: hr_utility.trace('Entering '||l_proc_name);
398: hr_utility.trace('Inserting report variable '|| p_name);
399:
400: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
401:
402: IF DEBUG_MODE THEN
403: hr_utility.trace('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
404: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');

Line 403: hr_utility.trace('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||

399:
400: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
401:
402: IF DEBUG_MODE THEN
403: hr_utility.trace('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
404: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');
405: ELSE
406: INSERT INTO pay_report_variables(report_variable_id,
407: report_definition_id,

Line 406: INSERT INTO pay_report_variables(report_variable_id,

402: IF DEBUG_MODE THEN
403: hr_utility.trace('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
404: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');
405: ELSE
406: INSERT INTO pay_report_variables(report_variable_id,
407: report_definition_id,
408: definition_type,
409: name,
410: value,