28: OPEN csr_get_iana_charset;
29: FETCH csr_get_iana_charset INTO lv_iana_charset;
30: CLOSE csr_get_iana_charset;
31:
32: hr_utility.trace('IANA Charset = '||lv_iana_charset);
33: RETURN (lv_iana_charset);
34: END get_IANA_charset;
35: --
36: -------------------------------------------------------------------------------
916: l_payroll_type VARCHAR2(40) DEFAULT NULL;
917: --
918: BEGIN
919: --
920: --hr_utility.trace_on(NULL,'NL_NWR');
921: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
922: hr_utility.trace('p_action_context_id :'||p_action_context_id);
923: hr_utility.trace('p_template_name :'||p_template_name);
924: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
917: --
918: BEGIN
919: --
920: --hr_utility.trace_on(NULL,'NL_NWR');
921: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
922: hr_utility.trace('p_action_context_id :'||p_action_context_id);
923: hr_utility.trace('p_template_name :'||p_template_name);
924: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
925: hr_utility.trace('p_sort_order :'||p_sort_order);
918: BEGIN
919: --
920: --hr_utility.trace_on(NULL,'NL_NWR');
921: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
922: hr_utility.trace('p_action_context_id :'||p_action_context_id);
923: hr_utility.trace('p_template_name :'||p_template_name);
924: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
925: hr_utility.trace('p_sort_order :'||p_sort_order);
926: --
919: --
920: --hr_utility.trace_on(NULL,'NL_NWR');
921: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
922: hr_utility.trace('p_action_context_id :'||p_action_context_id);
923: hr_utility.trace('p_template_name :'||p_template_name);
924: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
925: hr_utility.trace('p_sort_order :'||p_sort_order);
926: --
927: l_cntr_sql := 1;
920: --hr_utility.trace_on(NULL,'NL_NWR');
921: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
922: hr_utility.trace('p_action_context_id :'||p_action_context_id);
923: hr_utility.trace('p_template_name :'||p_template_name);
924: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
925: hr_utility.trace('p_sort_order :'||p_sort_order);
926: --
927: l_cntr_sql := 1;
928: g_action_ctx_id := p_action_context_id;
921: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
922: hr_utility.trace('p_action_context_id :'||p_action_context_id);
923: hr_utility.trace('p_template_name :'||p_template_name);
924: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
925: hr_utility.trace('p_sort_order :'||p_sort_order);
926: --
927: l_cntr_sql := 1;
928: g_action_ctx_id := p_action_context_id;
929: --