DBA Data[Home] [Help]

APPS.HR_NMF_SYNC dependencies on HR_NAME_FORMATS

Line 6: g_FULL_NAME CONSTANT hr_name_formats.format_name%TYPE := 'FULL_NAME';

2: /* $Header: hrnmfsyn.pkb 120.7 2006/11/03 12:29:14 rvarshne noship $ */
3:
4: --
5: g_package CONSTANT varchar2(30) := 'hr_nmf_sync.';
6: g_FULL_NAME CONSTANT hr_name_formats.format_name%TYPE := 'FULL_NAME';
7: g_ORDER_NAME CONSTANT hr_name_formats.format_name%TYPE := 'ORDER_NAME';
8: g_LIST_NAME CONSTANT hr_name_formats.format_name%TYPE := 'LIST_NAME';
9: --
10: -- Write_Log: writes messages to the LOG file generated by Concurrent Mg.

Line 7: g_ORDER_NAME CONSTANT hr_name_formats.format_name%TYPE := 'ORDER_NAME';

3:
4: --
5: g_package CONSTANT varchar2(30) := 'hr_nmf_sync.';
6: g_FULL_NAME CONSTANT hr_name_formats.format_name%TYPE := 'FULL_NAME';
7: g_ORDER_NAME CONSTANT hr_name_formats.format_name%TYPE := 'ORDER_NAME';
8: g_LIST_NAME CONSTANT hr_name_formats.format_name%TYPE := 'LIST_NAME';
9: --
10: -- Write_Log: writes messages to the LOG file generated by Concurrent Mg.
11: -- ---------------------------------------------------------------------------+

Line 8: g_LIST_NAME CONSTANT hr_name_formats.format_name%TYPE := 'LIST_NAME';

4: --
5: g_package CONSTANT varchar2(30) := 'hr_nmf_sync.';
6: g_FULL_NAME CONSTANT hr_name_formats.format_name%TYPE := 'FULL_NAME';
7: g_ORDER_NAME CONSTANT hr_name_formats.format_name%TYPE := 'ORDER_NAME';
8: g_LIST_NAME CONSTANT hr_name_formats.format_name%TYPE := 'LIST_NAME';
9: --
10: -- Write_Log: writes messages to the LOG file generated by Concurrent Mg.
11: -- ---------------------------------------------------------------------------+
12: PROCEDURE Write_Log

Line 46: from HR_NAME_FORMATS nmf

42: select nmf.legislation_code
43: ,nmf.format_name
44: ,nmf.user_format_choice
45: ,nmf.format_mask
46: from HR_NAME_FORMATS nmf
47: where ((cp_legCode is not null and nmf.legislation_code = cp_legCode)
48: OR ( nmf.legislation_code is null))
49: and ((cp_formatName is not null and nmf.format_name = cp_formatName)
50: OR (cp_formatName is null))

Line 60: from HR_NAME_FORMATS nmf

56: select nmf.legislation_code
57: ,nmf.format_name
58: ,nmf.user_format_choice
59: ,nmf.format_mask
60: from HR_NAME_FORMATS nmf
61: where nmf.legislation_code in
62: (select distinct legislation_code from per_business_groups_perf)
63: and ((cp_formatName is not null and nmf.format_name = cp_formatName)
64: OR (cp_formatName is null))

Line 118: l_format_mask hr_name_formats.format_mask%TYPE;

114: ,p_scope in varchar2 )
115: return varchar2 is
116:
117: l_mask_rec number;
118: l_format_mask hr_name_formats.format_mask%TYPE;
119:
120: begin
121: --
122: l_format_mask := null;

Line 154: l_format_mask hr_name_formats.format_mask%TYPE;

150: ,p_format_name in varchar2
151: ,p_scope in varchar2 )
152: return varchar2 is
153: --
154: l_format_mask hr_name_formats.format_mask%TYPE;
155: --
156: begin
157: --
158: if NOT g_masks_cached then

Line 260: l_format_mask hr_name_formats.format_mask%TYPE;

256: (p_format_name in varchar2
257: ,p_scope in varchar2 ) return varchar2 is
258:
259: l_mask_rec number;
260: l_format_mask hr_name_formats.format_mask%TYPE;
261:
262: begin
263: --
264: l_format_mask := null;

Line 290: l_format_name hr_name_formats.format_name%TYPE;

286: Returns : Nothing.
287: ---------------------------------------------------------------------*/
288: PROCEDURE cache_seeded_pkg IS
289: --
290: l_format_name hr_name_formats.format_name%TYPE;
291: --
292: cursor csr_get_legislations is
293: select leg.territory_code legislation_code
294: from fnd_territories_vl leg

Line 417: l_format_mask hr_name_formats.format_mask%TYPE;

413: ,p_format_name in varchar2
414: ,p_user_format_choice in varchar2
415: ,p_num_rows_processed out nocopy number) IS
416: --
417: l_format_mask hr_name_formats.format_mask%TYPE;
418: l_seeded_format_mask hr_name_formats.format_mask%TYPE;
419: l_pkg_name varchar2(80);
420: l_proc_name varchar2(80);
421:

Line 418: l_seeded_format_mask hr_name_formats.format_mask%TYPE;

414: ,p_user_format_choice in varchar2
415: ,p_num_rows_processed out nocopy number) IS
416: --
417: l_format_mask hr_name_formats.format_mask%TYPE;
418: l_seeded_format_mask hr_name_formats.format_mask%TYPE;
419: l_pkg_name varchar2(80);
420: l_proc_name varchar2(80);
421:
422:

Line 1256: l_format_name hr_name_formats.format_name%TYPE;

1252: l_dev_status varchar2(100);
1253: l_dev_phase varchar2(100);
1254: l_message varchar2(100);
1255: l_request_data varchar2(100);
1256: l_format_name hr_name_formats.format_name%TYPE;
1257: l_user_format_choice hr_name_formats.user_format_choice%TYPE;
1258: l_call_status boolean;
1259: l_trigger_error varchar2(512);
1260: l_data_migrator_mode varchar2(30); -- For Bug 5581236

Line 1257: l_user_format_choice hr_name_formats.user_format_choice%TYPE;

1253: l_dev_phase varchar2(100);
1254: l_message varchar2(100);
1255: l_request_data varchar2(100);
1256: l_format_name hr_name_formats.format_name%TYPE;
1257: l_user_format_choice hr_name_formats.user_format_choice%TYPE;
1258: l_call_status boolean;
1259: l_trigger_error varchar2(512);
1260: l_data_migrator_mode varchar2(30); -- For Bug 5581236
1261: --