DBA Data[Home] [Help]

APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on HR_UTILITY

Line 36: hr_utility.trace('IANA Charset = '||lv_iana_charset);

32: OPEN csr_get_iana_charset;
33: FETCH csr_get_iana_charset INTO lv_iana_charset;
34: CLOSE csr_get_iana_charset;
35:
36: hr_utility.trace('IANA Charset = '||lv_iana_charset);
37: RETURN (lv_iana_charset);
38: END get_IANA_charset;
39: --
40: -------------------------------------------------------------------------------

Line 1398: --hr_utility.trace_on(NULL,'NL_NWR');

1394: l_prev_corr_year VARCHAR2(100); --10100628
1395: l_ER_ONLY VARCHAR2(10); --10100628
1396: BEGIN
1397: --
1398: --hr_utility.trace_on(NULL,'NL_NWR');
1399: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
1400: hr_utility.trace('p_action_context_id :'||p_action_context_id);
1401: hr_utility.trace('p_template_name :'||p_template_name);
1402: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);

Line 1399: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);

1395: l_ER_ONLY VARCHAR2(10); --10100628
1396: BEGIN
1397: --
1398: --hr_utility.trace_on(NULL,'NL_NWR');
1399: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
1400: hr_utility.trace('p_action_context_id :'||p_action_context_id);
1401: hr_utility.trace('p_template_name :'||p_template_name);
1402: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
1403: hr_utility.trace('p_sort_order :'||p_sort_order);

Line 1400: hr_utility.trace('p_action_context_id :'||p_action_context_id);

1396: BEGIN
1397: --
1398: --hr_utility.trace_on(NULL,'NL_NWR');
1399: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
1400: hr_utility.trace('p_action_context_id :'||p_action_context_id);
1401: hr_utility.trace('p_template_name :'||p_template_name);
1402: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
1403: hr_utility.trace('p_sort_order :'||p_sort_order);
1404: --

Line 1401: hr_utility.trace('p_template_name :'||p_template_name);

1397: --
1398: --hr_utility.trace_on(NULL,'NL_NWR');
1399: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
1400: hr_utility.trace('p_action_context_id :'||p_action_context_id);
1401: hr_utility.trace('p_template_name :'||p_template_name);
1402: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
1403: hr_utility.trace('p_sort_order :'||p_sort_order);
1404: --
1405: l_cntr_sql := 1;

Line 1402: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);

1398: --hr_utility.trace_on(NULL,'NL_NWR');
1399: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
1400: hr_utility.trace('p_action_context_id :'||p_action_context_id);
1401: hr_utility.trace('p_template_name :'||p_template_name);
1402: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
1403: hr_utility.trace('p_sort_order :'||p_sort_order);
1404: --
1405: l_cntr_sql := 1;
1406: g_action_ctx_id := p_action_context_id;

Line 1403: hr_utility.trace('p_sort_order :'||p_sort_order);

1399: hr_utility.trace('p_nwr_report_type :'||p_nwr_report_type);
1400: hr_utility.trace('p_action_context_id :'||p_action_context_id);
1401: hr_utility.trace('p_template_name :'||p_template_name);
1402: hr_utility.trace('p_assignment_set_id :'||p_assignment_set_id);
1403: hr_utility.trace('p_sort_order :'||p_sort_order);
1404: --
1405: l_cntr_sql := 1;
1406: g_action_ctx_id := p_action_context_id;
1407: --

Line 1454: hr_utility.trace('g_SOURCE :'||g_SOURCE);

1450: g_SOURCE := g_SOURCE||upper(I.Source)||lower(I.Source);
1451: g_TARGET := g_TARGET||upper(I.Target)||lower(I.Target);
1452: END LOOP;
1453:
1454: hr_utility.trace('g_SOURCE :'||g_SOURCE);
1455: hr_utility.trace('g_TARGET :'||g_TARGET);
1456:
1457: END IF;
1458: --11900414 Ends

Line 1455: hr_utility.trace('g_TARGET :'||g_TARGET);

1451: g_TARGET := g_TARGET||upper(I.Target)||lower(I.Target);
1452: END LOOP;
1453:
1454: hr_utility.trace('g_SOURCE :'||g_SOURCE);
1455: hr_utility.trace('g_TARGET :'||g_TARGET);
1456:
1457: END IF;
1458: --11900414 Ends
1459: