APPS.BEN_DM_INPUT_FILE_PKG dependencies on BEN_DM_INPUT_FILE

Line 1: Package Body ben_dm_input_file_pkg as

1: Package Body ben_dm_input_file_pkg as
2: /* $Header: benfdmdmfile.pkb 120.0 2006/05/04 04:48:06 nkkrishn noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 31: g_package varchar2(33) := 'ben_dm_input_file.';

27: ind number);
28: Type contactTab is Table of contactRec index by binary_integer;
29: --
30: g_debug boolean := hr_utility.debug_enabled;
31: g_package varchar2(33) := 'ben_dm_input_file.';
32: g_missing_fields exception;
33: g_invalid_record exception;
34: --
35: -- ----------------------------------------------------------------------------

Line 336: delete from ben_dm_input_file;

332: end loop;
333: --
334: hr_utility.set_location('deleting existing records',10);
335: --
336: delete from ben_dm_input_file;
337: --
338: hr_utility.set_location('bulk inserting new records',10);
339: --
340: l_line_count := l_inp_rec.count;

Line 366: insert into ben_dm_input_file

362: --
363: for i in 1..l_line_count
364: loop
365: if nvl(l_inp_rec(i).process_flag,'Y') <> 'N' then
366: insert into ben_dm_input_file
367: (input_file_id,
368: status,
369: source_business_group_name,
370: source_national_identifier,

Line 378: (ben_dm_input_file_s.nextval,

374: group_order,
375: person_type,
376: data_source)
377: values
378: (ben_dm_input_file_s.nextval,
379: 'NS',
380: l_inp_rec(i).source_bg,
381: l_inp_rec(i).source_ssn,
382: l_inp_rec(i).source_person_id,

Line 391: --Check to remove the duplicate records from the ben_dm_input_file

387: l_inp_rec(i).data_source);
388: end if;
389: end loop;
390: --
391: --Check to remove the duplicate records from the ben_dm_input_file
392: --There should be always only one record for the following record combination
393: -- source_business_group_name
394: -- source_national_identifier
395: -- source_person_id

Line 399: DELETE FROM ben_dm_input_file mas

395: -- source_person_id
396: -- target_national_identifier
397: -- target_business_group_name
398: --
399: DELETE FROM ben_dm_input_file mas
400: WHERE ROWID > ( SELECT min(rowid)
401: FROM ben_dm_input_file chi
402: WHERE mas.source_business_group_name = chi.source_business_group_name
403: and mas.source_national_identifier = chi.source_national_identifier

Line 401: FROM ben_dm_input_file chi

397: -- target_business_group_name
398: --
399: DELETE FROM ben_dm_input_file mas
400: WHERE ROWID > ( SELECT min(rowid)
401: FROM ben_dm_input_file chi
402: WHERE mas.source_business_group_name = chi.source_business_group_name
403: and mas.source_national_identifier = chi.source_national_identifier
404: and mas.source_person_id = chi.source_person_id
405: and mas.group_order = chi.group_order

Line 525: end ben_dm_input_file_pkg;

521: raise;
522:
523: end read_file;
524:
525: end ben_dm_input_file_pkg;