APPS.PAY_INS_CUSTOM_TEMPLATE dependencies on HR_UTILITY

Line 388: hr_utility.trace('Entering '||l_proc_name);

384: l_proc_name VARCHAR2(50);
385: BEGIN
386:
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:

Line 389: hr_utility.trace('Inserting report variable '|| p_name);

385: BEGIN
386:
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

Line 413: hr_utility.trace('Leaving '||l_proc_name);

409: NULL,
410: p_business_group_id);
411: END IF;
412:
413: hr_utility.trace('Leaving '||l_proc_name);
414:
415: END insert_report_variable;
416:
417: PROCEDURE insert_report_catg_comp(p_report_category_id NUMBER,

Line 430: hr_utility.trace('Entering '||l_proc_name);

426:
427: BEGIN
428:
429: l_proc_name := 'INSERT_REPORT_CATEGORY_COMPONENT';
430: hr_utility.trace('Entering '||l_proc_name);
431: hr_utility.trace('Deleting report category component.');
432:
433: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;
434:

Line 431: hr_utility.trace('Deleting report category component.');

427: BEGIN
428:
429: l_proc_name := 'INSERT_REPORT_CATEGORY_COMPONENT';
430: hr_utility.trace('Entering '||l_proc_name);
431: hr_utility.trace('Deleting report category component.');
432:
433: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;
434:
435: hr_utility.trace('Inserting report category component.');

Line 435: hr_utility.trace('Inserting report category component.');

431: hr_utility.trace('Deleting report category component.');
432:
433: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;
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||','||

Line 460: hr_utility.trace('Leaving '||l_proc_name);

456: NULL,
457: p_business_group_id);
458: END IF;
459:
460: hr_utility.trace('Leaving '||l_proc_name);
461:
462: END insert_report_catg_comp;
463:
464: PROCEDURE insert_report_category(p_report_group_id IN NUMBER,

Line 476: hr_utility.trace('Entering '||l_proc_name);

472:
473: BEGIN
474:
475: l_proc_name := 'INSERT_REPORT_CATEGORY';
476: hr_utility.trace('Entering '||l_proc_name);
477: hr_utility.trace('Inserting report category '|| p_short_name);
478:
479: IF DEBUG_MODE THEN
480: dbms_output.put_line('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||

Line 477: hr_utility.trace('Inserting report category '|| p_short_name);

473: BEGIN
474:
475: l_proc_name := 'INSERT_REPORT_CATEGORY';
476: hr_utility.trace('Entering '||l_proc_name);
477: hr_utility.trace('Inserting report category '|| p_short_name);
478:
479: IF DEBUG_MODE THEN
480: dbms_output.put_line('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||
481: 'VALUES ('||p_report_category_id||','||p_report_group_id||','||p_category_name||','||p_short_name||','||p_legislation_code||','||p_business_group_id||');');

Line 497: hr_utility.trace('Leaving '||l_proc_name);

493: p_legislation_code,
494: p_business_group_id);
495: END IF;
496:
497: hr_utility.trace('Leaving '||l_proc_name);
498:
499: END insert_report_category;
500:
501: FUNCTION GET_NAME(p_conc_prog IN VARCHAR2)