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

108:
109: CURSOR csr_report_variable_id(p_report_variable_id IN NUMBER,
110: p_business_group_id IN NUMBER) IS
111: SELECT report_variable_id
112: FROM pay_report_variables
113: WHERE report_variable_id = p_report_variable_id
114: AND business_group_id = p_business_group_id
115: AND legislation_code IS NULL;
116:

Line 130: ln_report_variable_id pay_report_variables.report_variable_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;
134:

Line 131: pn_report_variable_id pay_report_variables.report_variable_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;
134:
135: BEGIN

Line 223: dbms_output.put_line('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);

219: FETCH csr_report_variable_id INTO ln_report_variable_id;
220: IF csr_report_variable_id%FOUND THEN
221: fnd_file.put_line(fnd_file.log,'Removing Variable Id : ' || ln_style_sheet_id);
222: IF DEBUG_MODE THEN
223: dbms_output.put_line('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);
224: ELSE
225: DELETE FROM pay_report_variables
226: WHERE report_variable_id = ln_report_variable_id;
227: END IF;

Line 225: DELETE FROM pay_report_variables

221: fnd_file.put_line(fnd_file.log,'Removing Variable Id : ' || ln_style_sheet_id);
222: IF DEBUG_MODE THEN
223: dbms_output.put_line('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);
224: ELSE
225: DELETE FROM pay_report_variables
226: WHERE report_variable_id = ln_report_variable_id;
227: END IF;
228: END IF;
229: CLOSE csr_report_variable_id;

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

242:
243: ln_definition_id := get_definition_id(ln_report_group_id,lv_template_type_code,lv_template_code);
244:
245: fnd_file.put_line(fnd_file.log,'+---------------------------------------------------------------------------+');
246: fnd_file.put_line(fnd_file.log,'Inserting Record Into PAY_REPORT_VARIABLES');
247: fnd_file.put_line(fnd_file.log,'Definition Id ' || ln_definition_id);
248: fnd_file.put_line(fnd_file.log,'Template Name ' || lv_template_name);
249: fnd_file.put_line(fnd_file.log,'Template Code ' || lv_template_code);
250: fnd_file.put_line(fnd_file.log,'Business Group Id ' || p_business_group_id);

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

387: l_proc_name := 'INSERT_REPORT_VARIABLE';
388: hr_utility.trace('Entering '||l_proc_name);
389: hr_utility.trace('Inserting report variable '|| p_name);
390:
391: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
392:
393: IF DEBUG_MODE THEN
394: dbms_output.put_line('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
395: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');

Line 394: dbms_output.put_line('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||

390:
391: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
392:
393: IF DEBUG_MODE THEN
394: dbms_output.put_line('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
395: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');
396: ELSE
397: INSERT INTO pay_report_variables(report_variable_id,
398: report_definition_id,

Line 397: INSERT INTO pay_report_variables(report_variable_id,

393: IF DEBUG_MODE THEN
394: dbms_output.put_line('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
395: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');
396: ELSE
397: INSERT INTO pay_report_variables(report_variable_id,
398: report_definition_id,
399: definition_type,
400: name,
401: value,