eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_PAYROLL dependencies on BEN_EXT_PERSON

Line 20: 13 Mar 99 Ty Hayden 115.3 Moved globals to ben_ext_person.

16: ---- --- ------- -----
17: 18 Dec 98 Ty Hayden 115.0 Created.
18: 21 Dec 98 Ty Hayden 115.1 Added g_chg_input_value_idn to cursor.
19: 09 Mar 99 G Perry 115.2 IS to AS.
20: 13 Mar 99 Ty Hayden 115.3 Moved globals to ben_ext_person.
21: 17 May 99 Isen 115.4 Removed null others exception handler
22: - bug 2422.
23: 25 May 99 Isen 115.5 Added procedure to initialize the globals
24: 01 Jul 99 Asen 115.6 Added code for decode fields.

Line 56: ben_ext_person.g_element_name := null;

52: --
53: --
54: hr_utility.set_location('Entering'||l_proc, 5);
55: --
56: ben_ext_person.g_element_name := null;
57: ben_ext_person.g_element_id := null;
58: ben_ext_person.g_element_reporting_name := null;
59: ben_ext_person.g_element_description := null;
60: ben_ext_person.g_element_classification_name := null;

Line 57: ben_ext_person.g_element_id := null;

53: --
54: hr_utility.set_location('Entering'||l_proc, 5);
55: --
56: ben_ext_person.g_element_name := null;
57: ben_ext_person.g_element_id := null;
58: ben_ext_person.g_element_reporting_name := null;
59: ben_ext_person.g_element_description := null;
60: ben_ext_person.g_element_classification_name := null;
61: ben_ext_person.g_element_classification_id := null;

Line 58: ben_ext_person.g_element_reporting_name := null;

54: hr_utility.set_location('Entering'||l_proc, 5);
55: --
56: ben_ext_person.g_element_name := null;
57: ben_ext_person.g_element_id := null;
58: ben_ext_person.g_element_reporting_name := null;
59: ben_ext_person.g_element_description := null;
60: ben_ext_person.g_element_classification_name := null;
61: ben_ext_person.g_element_classification_id := null;
62: ben_ext_person.g_element_processing_type := null;

Line 59: ben_ext_person.g_element_description := null;

55: --
56: ben_ext_person.g_element_name := null;
57: ben_ext_person.g_element_id := null;
58: ben_ext_person.g_element_reporting_name := null;
59: ben_ext_person.g_element_description := null;
60: ben_ext_person.g_element_classification_name := null;
61: ben_ext_person.g_element_classification_id := null;
62: ben_ext_person.g_element_processing_type := null;
63: ben_ext_person.g_element_input_currency_code := null;

Line 60: ben_ext_person.g_element_classification_name := null;

56: ben_ext_person.g_element_name := null;
57: ben_ext_person.g_element_id := null;
58: ben_ext_person.g_element_reporting_name := null;
59: ben_ext_person.g_element_description := null;
60: ben_ext_person.g_element_classification_name := null;
61: ben_ext_person.g_element_classification_id := null;
62: ben_ext_person.g_element_processing_type := null;
63: ben_ext_person.g_element_input_currency_code := null;
64: ben_ext_person.g_element_output_currency_code := null;

Line 61: ben_ext_person.g_element_classification_id := null;

57: ben_ext_person.g_element_id := null;
58: ben_ext_person.g_element_reporting_name := null;
59: ben_ext_person.g_element_description := null;
60: ben_ext_person.g_element_classification_name := null;
61: ben_ext_person.g_element_classification_id := null;
62: ben_ext_person.g_element_processing_type := null;
63: ben_ext_person.g_element_input_currency_code := null;
64: ben_ext_person.g_element_output_currency_code := null;
65: ben_ext_person.g_element_skip_rule := null;

Line 62: ben_ext_person.g_element_processing_type := null;

58: ben_ext_person.g_element_reporting_name := null;
59: ben_ext_person.g_element_description := null;
60: ben_ext_person.g_element_classification_name := null;
61: ben_ext_person.g_element_classification_id := null;
62: ben_ext_person.g_element_processing_type := null;
63: ben_ext_person.g_element_input_currency_code := null;
64: ben_ext_person.g_element_output_currency_code := null;
65: ben_ext_person.g_element_skip_rule := null;
66: ben_ext_person.g_element_skip_rule_id := null;

Line 63: ben_ext_person.g_element_input_currency_code := null;

59: ben_ext_person.g_element_description := null;
60: ben_ext_person.g_element_classification_name := null;
61: ben_ext_person.g_element_classification_id := null;
62: ben_ext_person.g_element_processing_type := null;
63: ben_ext_person.g_element_input_currency_code := null;
64: ben_ext_person.g_element_output_currency_code := null;
65: ben_ext_person.g_element_skip_rule := null;
66: ben_ext_person.g_element_skip_rule_id := null;
67: ben_ext_person.g_element_input_value_name := null;

Line 64: ben_ext_person.g_element_output_currency_code := null;

60: ben_ext_person.g_element_classification_name := null;
61: ben_ext_person.g_element_classification_id := null;
62: ben_ext_person.g_element_processing_type := null;
63: ben_ext_person.g_element_input_currency_code := null;
64: ben_ext_person.g_element_output_currency_code := null;
65: ben_ext_person.g_element_skip_rule := null;
66: ben_ext_person.g_element_skip_rule_id := null;
67: ben_ext_person.g_element_input_value_name := null;
68: ben_ext_person.g_element_input_value_id := null;

Line 65: ben_ext_person.g_element_skip_rule := null;

61: ben_ext_person.g_element_classification_id := null;
62: ben_ext_person.g_element_processing_type := null;
63: ben_ext_person.g_element_input_currency_code := null;
64: ben_ext_person.g_element_output_currency_code := null;
65: ben_ext_person.g_element_skip_rule := null;
66: ben_ext_person.g_element_skip_rule_id := null;
67: ben_ext_person.g_element_input_value_name := null;
68: ben_ext_person.g_element_input_value_id := null;
69: ben_ext_person.g_element_input_value_units := null;

Line 66: ben_ext_person.g_element_skip_rule_id := null;

62: ben_ext_person.g_element_processing_type := null;
63: ben_ext_person.g_element_input_currency_code := null;
64: ben_ext_person.g_element_output_currency_code := null;
65: ben_ext_person.g_element_skip_rule := null;
66: ben_ext_person.g_element_skip_rule_id := null;
67: ben_ext_person.g_element_input_value_name := null;
68: ben_ext_person.g_element_input_value_id := null;
69: ben_ext_person.g_element_input_value_units := null;
70: ben_ext_person.g_element_input_value_sequence := null;

Line 67: ben_ext_person.g_element_input_value_name := null;

63: ben_ext_person.g_element_input_currency_code := null;
64: ben_ext_person.g_element_output_currency_code := null;
65: ben_ext_person.g_element_skip_rule := null;
66: ben_ext_person.g_element_skip_rule_id := null;
67: ben_ext_person.g_element_input_value_name := null;
68: ben_ext_person.g_element_input_value_id := null;
69: ben_ext_person.g_element_input_value_units := null;
70: ben_ext_person.g_element_input_value_sequence := null;
71: ben_ext_person.g_element_entry_value := null;

Line 68: ben_ext_person.g_element_input_value_id := null;

64: ben_ext_person.g_element_output_currency_code := null;
65: ben_ext_person.g_element_skip_rule := null;
66: ben_ext_person.g_element_skip_rule_id := null;
67: ben_ext_person.g_element_input_value_name := null;
68: ben_ext_person.g_element_input_value_id := null;
69: ben_ext_person.g_element_input_value_units := null;
70: ben_ext_person.g_element_input_value_sequence := null;
71: ben_ext_person.g_element_entry_value := null;
72: ben_ext_person.g_element_entry_costing := null;

Line 69: ben_ext_person.g_element_input_value_units := null;

65: ben_ext_person.g_element_skip_rule := null;
66: ben_ext_person.g_element_skip_rule_id := null;
67: ben_ext_person.g_element_input_value_name := null;
68: ben_ext_person.g_element_input_value_id := null;
69: ben_ext_person.g_element_input_value_units := null;
70: ben_ext_person.g_element_input_value_sequence := null;
71: ben_ext_person.g_element_entry_value := null;
72: ben_ext_person.g_element_entry_costing := null;
73: ben_ext_person.g_element_entry_costing_id := null;

Line 70: ben_ext_person.g_element_input_value_sequence := null;

66: ben_ext_person.g_element_skip_rule_id := null;
67: ben_ext_person.g_element_input_value_name := null;
68: ben_ext_person.g_element_input_value_id := null;
69: ben_ext_person.g_element_input_value_units := null;
70: ben_ext_person.g_element_input_value_sequence := null;
71: ben_ext_person.g_element_entry_value := null;
72: ben_ext_person.g_element_entry_costing := null;
73: ben_ext_person.g_element_entry_costing_id := null;
74: ben_ext_person.g_element_entry_reason := null;

Line 71: ben_ext_person.g_element_entry_value := null;

67: ben_ext_person.g_element_input_value_name := null;
68: ben_ext_person.g_element_input_value_id := null;
69: ben_ext_person.g_element_input_value_units := null;
70: ben_ext_person.g_element_input_value_sequence := null;
71: ben_ext_person.g_element_entry_value := null;
72: ben_ext_person.g_element_entry_costing := null;
73: ben_ext_person.g_element_entry_costing_id := null;
74: ben_ext_person.g_element_entry_reason := null;
75: ben_ext_person.g_element_entry_id := null;

Line 72: ben_ext_person.g_element_entry_costing := null;

68: ben_ext_person.g_element_input_value_id := null;
69: ben_ext_person.g_element_input_value_units := null;
70: ben_ext_person.g_element_input_value_sequence := null;
71: ben_ext_person.g_element_entry_value := null;
72: ben_ext_person.g_element_entry_costing := null;
73: ben_ext_person.g_element_entry_costing_id := null;
74: ben_ext_person.g_element_entry_reason := null;
75: ben_ext_person.g_element_entry_id := null;
76: ben_ext_person.g_element_entry_eff_start_date := null;

Line 73: ben_ext_person.g_element_entry_costing_id := null;

69: ben_ext_person.g_element_input_value_units := null;
70: ben_ext_person.g_element_input_value_sequence := null;
71: ben_ext_person.g_element_entry_value := null;
72: ben_ext_person.g_element_entry_costing := null;
73: ben_ext_person.g_element_entry_costing_id := null;
74: ben_ext_person.g_element_entry_reason := null;
75: ben_ext_person.g_element_entry_id := null;
76: ben_ext_person.g_element_entry_eff_start_date := null;
77: ben_ext_person.g_element_entry_eff_end_date := null;

Line 74: ben_ext_person.g_element_entry_reason := null;

70: ben_ext_person.g_element_input_value_sequence := null;
71: ben_ext_person.g_element_entry_value := null;
72: ben_ext_person.g_element_entry_costing := null;
73: ben_ext_person.g_element_entry_costing_id := null;
74: ben_ext_person.g_element_entry_reason := null;
75: ben_ext_person.g_element_entry_id := null;
76: ben_ext_person.g_element_entry_eff_start_date := null;
77: ben_ext_person.g_element_entry_eff_end_date := null;
78: ben_ext_person.g_element_entry_value_id := null;

Line 75: ben_ext_person.g_element_entry_id := null;

71: ben_ext_person.g_element_entry_value := null;
72: ben_ext_person.g_element_entry_costing := null;
73: ben_ext_person.g_element_entry_costing_id := null;
74: ben_ext_person.g_element_entry_reason := null;
75: ben_ext_person.g_element_entry_id := null;
76: ben_ext_person.g_element_entry_eff_start_date := null;
77: ben_ext_person.g_element_entry_eff_end_date := null;
78: ben_ext_person.g_element_entry_value_id := null;
79: ben_ext_person.g_element_eev_eff_strt_date := null;

Line 76: ben_ext_person.g_element_entry_eff_start_date := null;

72: ben_ext_person.g_element_entry_costing := null;
73: ben_ext_person.g_element_entry_costing_id := null;
74: ben_ext_person.g_element_entry_reason := null;
75: ben_ext_person.g_element_entry_id := null;
76: ben_ext_person.g_element_entry_eff_start_date := null;
77: ben_ext_person.g_element_entry_eff_end_date := null;
78: ben_ext_person.g_element_entry_value_id := null;
79: ben_ext_person.g_element_eev_eff_strt_date := null;
80: ben_ext_person.g_element_eev_eff_end_date := null;

Line 77: ben_ext_person.g_element_entry_eff_end_date := null;

73: ben_ext_person.g_element_entry_costing_id := null;
74: ben_ext_person.g_element_entry_reason := null;
75: ben_ext_person.g_element_entry_id := null;
76: ben_ext_person.g_element_entry_eff_start_date := null;
77: ben_ext_person.g_element_entry_eff_end_date := null;
78: ben_ext_person.g_element_entry_value_id := null;
79: ben_ext_person.g_element_eev_eff_strt_date := null;
80: ben_ext_person.g_element_eev_eff_end_date := null;
81: --

Line 78: ben_ext_person.g_element_entry_value_id := null;

74: ben_ext_person.g_element_entry_reason := null;
75: ben_ext_person.g_element_entry_id := null;
76: ben_ext_person.g_element_entry_eff_start_date := null;
77: ben_ext_person.g_element_entry_eff_end_date := null;
78: ben_ext_person.g_element_entry_value_id := null;
79: ben_ext_person.g_element_eev_eff_strt_date := null;
80: ben_ext_person.g_element_eev_eff_end_date := null;
81: --
82: hr_utility.set_location('Exiting'||l_proc, 15);

Line 79: ben_ext_person.g_element_eev_eff_strt_date := null;

75: ben_ext_person.g_element_entry_id := null;
76: ben_ext_person.g_element_entry_eff_start_date := null;
77: ben_ext_person.g_element_entry_eff_end_date := null;
78: ben_ext_person.g_element_entry_value_id := null;
79: ben_ext_person.g_element_eev_eff_strt_date := null;
80: ben_ext_person.g_element_eev_eff_end_date := null;
81: --
82: hr_utility.set_location('Exiting'||l_proc, 15);
83: --

Line 80: ben_ext_person.g_element_eev_eff_end_date := null;

76: ben_ext_person.g_element_entry_eff_start_date := null;
77: ben_ext_person.g_element_entry_eff_end_date := null;
78: ben_ext_person.g_element_entry_value_id := null;
79: ben_ext_person.g_element_eev_eff_strt_date := null;
80: ben_ext_person.g_element_eev_eff_end_date := null;
81: --
82: hr_utility.set_location('Exiting'||l_proc, 15);
83: --
84: End initialize_globals;

Line 129: and (ben_ext_person.g_chg_input_value_id is null

125: asg.person_id = p_person_id
126: and asg.assignment_id = ee.assignment_id
127: and ee.element_entry_id = eev.element_entry_id
128: and iv.input_value_id = eev.input_value_id
129: and (ben_ext_person.g_chg_input_value_id is null
130: or ben_ext_person.g_chg_input_value_id = iv.input_value_id
131: )
132: and p_effective_date between asg.effective_start_date and asg.effective_end_date
133: and p_effective_date between ee.effective_start_date and ee.effective_end_date

Line 130: or ben_ext_person.g_chg_input_value_id = iv.input_value_id

126: and asg.assignment_id = ee.assignment_id
127: and ee.element_entry_id = eev.element_entry_id
128: and iv.input_value_id = eev.input_value_id
129: and (ben_ext_person.g_chg_input_value_id is null
130: or ben_ext_person.g_chg_input_value_id = iv.input_value_id
131: )
132: and p_effective_date between asg.effective_start_date and asg.effective_end_date
133: and p_effective_date between ee.effective_start_date and ee.effective_end_date
134: and p_effective_date between eev.effective_start_date and eev.effective_end_date

Line 257: and iv.input_value_id = nvl(ben_ext_person.g_chg_input_value_id,iv.input_value_id)

253: ff_formulas_f ff,
254: pay_cost_allocation_keyflex ca
255: where
256: per.person_id = p_person_id
257: and iv.input_value_id = nvl(ben_ext_person.g_chg_input_value_id,iv.input_value_id)
258: and ee.element_entry_id = eev.element_entry_id
259: and asg.assignment_id = ee.assignment_id
260: and per.person_id = asg.person_id
261: and iv.input_value_id = eev.input_value_id

Line 339: and (ben_ext_person.g_chg_input_value_id is null

335: Where rule.element_set_id = usg.element_set_id
336: AND usg.event_group_id = grp.event_group_id
337: AND grp.event_group_name = 'PQP_GB_PSI_ALL_ELEMENT_ENTRIES'
338: AND grp.legislation_code = 'GB')
339: and (ben_ext_person.g_chg_input_value_id is null
340: or ben_ext_person.g_chg_input_value_id = iv.input_value_id
341: )
342: and p_effective_date between asg.effective_start_date and asg.effective_end_date
343: and p_effective_date between ee.effective_start_date and ee.effective_end_date

Line 340: or ben_ext_person.g_chg_input_value_id = iv.input_value_id

336: AND usg.event_group_id = grp.event_group_id
337: AND grp.event_group_name = 'PQP_GB_PSI_ALL_ELEMENT_ENTRIES'
338: AND grp.legislation_code = 'GB')
339: and (ben_ext_person.g_chg_input_value_id is null
340: or ben_ext_person.g_chg_input_value_id = iv.input_value_id
341: )
342: and p_effective_date between asg.effective_start_date and asg.effective_end_date
343: and p_effective_date between ee.effective_start_date and ee.effective_end_date
344: and p_effective_date between eev.effective_start_date and eev.effective_end_date

Line 374: and (ben_ext_person.g_chg_input_value_id is null

370: asg.person_id = p_person_id
371: and asg.assignment_id = ee.assignment_id
372: and ee.element_entry_id = eev.element_entry_id
373: and iv.input_value_id = eev.input_value_id
374: and (ben_ext_person.g_chg_input_value_id is null
375: or ben_ext_person.g_chg_input_value_id = iv.input_value_id
376: )
377: and p_effective_date between asg.effective_start_date and asg.effective_end_date
378: and p_effective_date between ee.effective_start_date and ee.effective_end_date

Line 375: or ben_ext_person.g_chg_input_value_id = iv.input_value_id

371: and asg.assignment_id = ee.assignment_id
372: and ee.element_entry_id = eev.element_entry_id
373: and iv.input_value_id = eev.input_value_id
374: and (ben_ext_person.g_chg_input_value_id is null
375: or ben_ext_person.g_chg_input_value_id = iv.input_value_id
376: )
377: and p_effective_date between asg.effective_start_date and asg.effective_end_date
378: and p_effective_date between ee.effective_start_date and ee.effective_end_date
379: and p_effective_date between eev.effective_start_date and eev.effective_end_date

Line 390: ben_ext_person.g_element_input_value_name := pay.name;

386:
387: -- initialize the globals - May, 99
388: initialize_globals;
389:
390: ben_ext_person.g_element_input_value_name := pay.name;
391: ben_ext_person.g_element_input_value_units := pay.uom;
392: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
393: ben_ext_person.g_element_input_value_id := pay.input_value_id;
394: ben_ext_person.g_element_id := pay.element_type_id;

Line 391: ben_ext_person.g_element_input_value_units := pay.uom;

387: -- initialize the globals - May, 99
388: initialize_globals;
389:
390: ben_ext_person.g_element_input_value_name := pay.name;
391: ben_ext_person.g_element_input_value_units := pay.uom;
392: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
393: ben_ext_person.g_element_input_value_id := pay.input_value_id;
394: ben_ext_person.g_element_id := pay.element_type_id;
395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;

Line 392: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;

388: initialize_globals;
389:
390: ben_ext_person.g_element_input_value_name := pay.name;
391: ben_ext_person.g_element_input_value_units := pay.uom;
392: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
393: ben_ext_person.g_element_input_value_id := pay.input_value_id;
394: ben_ext_person.g_element_id := pay.element_type_id;
395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;

Line 393: ben_ext_person.g_element_input_value_id := pay.input_value_id;

389:
390: ben_ext_person.g_element_input_value_name := pay.name;
391: ben_ext_person.g_element_input_value_units := pay.uom;
392: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
393: ben_ext_person.g_element_input_value_id := pay.input_value_id;
394: ben_ext_person.g_element_id := pay.element_type_id;
395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;

Line 394: ben_ext_person.g_element_id := pay.element_type_id;

390: ben_ext_person.g_element_input_value_name := pay.name;
391: ben_ext_person.g_element_input_value_units := pay.uom;
392: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
393: ben_ext_person.g_element_input_value_id := pay.input_value_id;
394: ben_ext_person.g_element_id := pay.element_type_id;
395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;

Line 395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;

391: ben_ext_person.g_element_input_value_units := pay.uom;
392: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
393: ben_ext_person.g_element_input_value_id := pay.input_value_id;
394: ben_ext_person.g_element_id := pay.element_type_id;
395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;

Line 396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;

392: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
393: ben_ext_person.g_element_input_value_id := pay.input_value_id;
394: ben_ext_person.g_element_id := pay.element_type_id;
395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
400: ben_ext_person.g_element_entry_reason := pay.reason;

Line 397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;

393: ben_ext_person.g_element_input_value_id := pay.input_value_id;
394: ben_ext_person.g_element_id := pay.element_type_id;
395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
400: ben_ext_person.g_element_entry_reason := pay.reason;
401: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;

Line 398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;

394: ben_ext_person.g_element_id := pay.element_type_id;
395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
400: ben_ext_person.g_element_entry_reason := pay.reason;
401: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
402: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;

Line 399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;

395: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
400: ben_ext_person.g_element_entry_reason := pay.reason;
401: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
402: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
403: ben_ext_person.g_element_entry_id := pay.element_entry_id;

Line 400: ben_ext_person.g_element_entry_reason := pay.reason;

396: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
400: ben_ext_person.g_element_entry_reason := pay.reason;
401: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
402: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
403: ben_ext_person.g_element_entry_id := pay.element_entry_id;
404:

Line 401: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;

397: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
400: ben_ext_person.g_element_entry_reason := pay.reason;
401: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
402: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
403: ben_ext_person.g_element_entry_id := pay.element_entry_id;
404:
405: open c_ele_type(pay.element_type_id) ;

Line 402: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;

398: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
400: ben_ext_person.g_element_entry_reason := pay.reason;
401: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
402: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
403: ben_ext_person.g_element_entry_id := pay.element_entry_id;
404:
405: open c_ele_type(pay.element_type_id) ;
406: fetch c_ele_type into

Line 403: ben_ext_person.g_element_entry_id := pay.element_entry_id;

399: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
400: ben_ext_person.g_element_entry_reason := pay.reason;
401: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
402: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
403: ben_ext_person.g_element_entry_id := pay.element_entry_id;
404:
405: open c_ele_type(pay.element_type_id) ;
406: fetch c_ele_type into
407: ben_ext_person.g_element_name ,

Line 407: ben_ext_person.g_element_name ,

403: ben_ext_person.g_element_entry_id := pay.element_entry_id;
404:
405: open c_ele_type(pay.element_type_id) ;
406: fetch c_ele_type into
407: ben_ext_person.g_element_name ,
408: ben_ext_person.g_element_reporting_name,
409: ben_ext_person.g_element_description ,
410: ben_ext_person.g_element_classification_id ,
411: ben_ext_person.g_element_processing_type,

Line 408: ben_ext_person.g_element_reporting_name,

404:
405: open c_ele_type(pay.element_type_id) ;
406: fetch c_ele_type into
407: ben_ext_person.g_element_name ,
408: ben_ext_person.g_element_reporting_name,
409: ben_ext_person.g_element_description ,
410: ben_ext_person.g_element_classification_id ,
411: ben_ext_person.g_element_processing_type,
412: ben_ext_person.g_element_input_currency_code ,

Line 409: ben_ext_person.g_element_description ,

405: open c_ele_type(pay.element_type_id) ;
406: fetch c_ele_type into
407: ben_ext_person.g_element_name ,
408: ben_ext_person.g_element_reporting_name,
409: ben_ext_person.g_element_description ,
410: ben_ext_person.g_element_classification_id ,
411: ben_ext_person.g_element_processing_type,
412: ben_ext_person.g_element_input_currency_code ,
413: ben_ext_person.g_element_output_currency_code,

Line 410: ben_ext_person.g_element_classification_id ,

406: fetch c_ele_type into
407: ben_ext_person.g_element_name ,
408: ben_ext_person.g_element_reporting_name,
409: ben_ext_person.g_element_description ,
410: ben_ext_person.g_element_classification_id ,
411: ben_ext_person.g_element_processing_type,
412: ben_ext_person.g_element_input_currency_code ,
413: ben_ext_person.g_element_output_currency_code,
414: ben_ext_person.g_element_skip_rule_id;

Line 411: ben_ext_person.g_element_processing_type,

407: ben_ext_person.g_element_name ,
408: ben_ext_person.g_element_reporting_name,
409: ben_ext_person.g_element_description ,
410: ben_ext_person.g_element_classification_id ,
411: ben_ext_person.g_element_processing_type,
412: ben_ext_person.g_element_input_currency_code ,
413: ben_ext_person.g_element_output_currency_code,
414: ben_ext_person.g_element_skip_rule_id;
415: close c_ele_type ;

Line 412: ben_ext_person.g_element_input_currency_code ,

408: ben_ext_person.g_element_reporting_name,
409: ben_ext_person.g_element_description ,
410: ben_ext_person.g_element_classification_id ,
411: ben_ext_person.g_element_processing_type,
412: ben_ext_person.g_element_input_currency_code ,
413: ben_ext_person.g_element_output_currency_code,
414: ben_ext_person.g_element_skip_rule_id;
415: close c_ele_type ;
416: --

Line 413: ben_ext_person.g_element_output_currency_code,

409: ben_ext_person.g_element_description ,
410: ben_ext_person.g_element_classification_id ,
411: ben_ext_person.g_element_processing_type,
412: ben_ext_person.g_element_input_currency_code ,
413: ben_ext_person.g_element_output_currency_code,
414: ben_ext_person.g_element_skip_rule_id;
415: close c_ele_type ;
416: --
417:

Line 414: ben_ext_person.g_element_skip_rule_id;

410: ben_ext_person.g_element_classification_id ,
411: ben_ext_person.g_element_processing_type,
412: ben_ext_person.g_element_input_currency_code ,
413: ben_ext_person.g_element_output_currency_code,
414: ben_ext_person.g_element_skip_rule_id;
415: close c_ele_type ;
416: --
417:
418: ben_ext_evaluate_inclusion.Evaluate_Elm_Entry_Incl

Line 419: (p_processing_type => ben_ext_person.g_element_processing_type ,

415: close c_ele_type ;
416: --
417:
418: ben_ext_evaluate_inclusion.Evaluate_Elm_Entry_Incl
419: (p_processing_type => ben_ext_person.g_element_processing_type ,
420: p_input_value_id => pay.input_value_id ,
421: p_business_group_id => p_business_group_id ,
422: p_effective_date => p_effective_date ,
423: p_person_id => p_person_id ,

Line 437: if ben_ext_person.g_element_classification_id is not null then

433: -- assign enrollment info to global variables
434: --
435:
436:
437: if ben_ext_person.g_element_classification_id is not null then
438: open c_ele_clas (ben_ext_person.g_element_classification_id) ;
439: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;
440: close c_ele_clas ;
441: end if ;

Line 438: open c_ele_clas (ben_ext_person.g_element_classification_id) ;

434: --
435:
436:
437: if ben_ext_person.g_element_classification_id is not null then
438: open c_ele_clas (ben_ext_person.g_element_classification_id) ;
439: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;
440: close c_ele_clas ;
441: end if ;
442:

Line 439: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;

435:
436:
437: if ben_ext_person.g_element_classification_id is not null then
438: open c_ele_clas (ben_ext_person.g_element_classification_id) ;
439: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;
440: close c_ele_clas ;
441: end if ;
442:
443: if ben_ext_person.g_element_skip_rule_id is not null then

Line 443: if ben_ext_person.g_element_skip_rule_id is not null then

439: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;
440: close c_ele_clas ;
441: end if ;
442:
443: if ben_ext_person.g_element_skip_rule_id is not null then
444: open c_ff_name (ben_ext_person.g_element_skip_rule_id) ;
445: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;
446: close c_ff_name ;
447: end if ;

Line 444: open c_ff_name (ben_ext_person.g_element_skip_rule_id) ;

440: close c_ele_clas ;
441: end if ;
442:
443: if ben_ext_person.g_element_skip_rule_id is not null then
444: open c_ff_name (ben_ext_person.g_element_skip_rule_id) ;
445: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;
446: close c_ff_name ;
447: end if ;
448:

Line 445: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;

441: end if ;
442:
443: if ben_ext_person.g_element_skip_rule_id is not null then
444: open c_ff_name (ben_ext_person.g_element_skip_rule_id) ;
445: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;
446: close c_ff_name ;
447: end if ;
448:
449: if ben_ext_person.g_element_entry_costing_id is not null then

Line 449: if ben_ext_person.g_element_entry_costing_id is not null then

445: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;
446: close c_ff_name ;
447: end if ;
448:
449: if ben_ext_person.g_element_entry_costing_id is not null then
450: open c_ele_conc (ben_ext_person.g_element_entry_costing_id) ;
451: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;
452: close c_ele_conc ;
453: end if ;

Line 450: open c_ele_conc (ben_ext_person.g_element_entry_costing_id) ;

446: close c_ff_name ;
447: end if ;
448:
449: if ben_ext_person.g_element_entry_costing_id is not null then
450: open c_ele_conc (ben_ext_person.g_element_entry_costing_id) ;
451: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;
452: close c_ele_conc ;
453: end if ;
454:

Line 451: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;

447: end if ;
448:
449: if ben_ext_person.g_element_entry_costing_id is not null then
450: open c_ele_conc (ben_ext_person.g_element_entry_costing_id) ;
451: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;
452: close c_ele_conc ;
453: end if ;
454:
455: hr_utility.set_location('eeveffdate '||ben_ext_person.g_element_eev_eff_strt_date||

Line 455: hr_utility.set_location('eeveffdate '||ben_ext_person.g_element_eev_eff_strt_date||

451: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;
452: close c_ele_conc ;
453: end if ;
454:
455: hr_utility.set_location('eeveffdate '||ben_ext_person.g_element_eev_eff_strt_date||
456: '-'||ben_ext_person.g_element_eev_eff_end_date ,99);
457: --
458: -- format and write
459: --

Line 456: '-'||ben_ext_person.g_element_eev_eff_end_date ,99);

452: close c_ele_conc ;
453: end if ;
454:
455: hr_utility.set_location('eeveffdate '||ben_ext_person.g_element_eev_eff_strt_date||
456: '-'||ben_ext_person.g_element_eev_eff_end_date ,99);
457: --
458: -- format and write
459: --
460: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,

Line 481: ben_ext_person.g_element_input_value_name := pay.name;

477: /* FOR pay IN c_pay LOOP
478: -- initialize the globals - May, 99
479: initialize_globals;
480:
481: ben_ext_person.g_element_input_value_name := pay.name;
482: ben_ext_person.g_element_input_value_units := pay.uom;
483: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
484: ben_ext_person.g_element_input_value_id := pay.input_value_id;
485: ben_ext_person.g_element_id := pay.element_type_id;

Line 482: ben_ext_person.g_element_input_value_units := pay.uom;

478: -- initialize the globals - May, 99
479: initialize_globals;
480:
481: ben_ext_person.g_element_input_value_name := pay.name;
482: ben_ext_person.g_element_input_value_units := pay.uom;
483: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
484: ben_ext_person.g_element_input_value_id := pay.input_value_id;
485: ben_ext_person.g_element_id := pay.element_type_id;
486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;

Line 483: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;

479: initialize_globals;
480:
481: ben_ext_person.g_element_input_value_name := pay.name;
482: ben_ext_person.g_element_input_value_units := pay.uom;
483: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
484: ben_ext_person.g_element_input_value_id := pay.input_value_id;
485: ben_ext_person.g_element_id := pay.element_type_id;
486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;

Line 484: ben_ext_person.g_element_input_value_id := pay.input_value_id;

480:
481: ben_ext_person.g_element_input_value_name := pay.name;
482: ben_ext_person.g_element_input_value_units := pay.uom;
483: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
484: ben_ext_person.g_element_input_value_id := pay.input_value_id;
485: ben_ext_person.g_element_id := pay.element_type_id;
486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;

Line 485: ben_ext_person.g_element_id := pay.element_type_id;

481: ben_ext_person.g_element_input_value_name := pay.name;
482: ben_ext_person.g_element_input_value_units := pay.uom;
483: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
484: ben_ext_person.g_element_input_value_id := pay.input_value_id;
485: ben_ext_person.g_element_id := pay.element_type_id;
486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;

Line 486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;

482: ben_ext_person.g_element_input_value_units := pay.uom;
483: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
484: ben_ext_person.g_element_input_value_id := pay.input_value_id;
485: ben_ext_person.g_element_id := pay.element_type_id;
486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;

Line 487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;

483: ben_ext_person.g_element_input_value_sequence := pay.display_sequence;
484: ben_ext_person.g_element_input_value_id := pay.input_value_id;
485: ben_ext_person.g_element_id := pay.element_type_id;
486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
491: ben_ext_person.g_element_entry_reason := pay.reason;

Line 488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;

484: ben_ext_person.g_element_input_value_id := pay.input_value_id;
485: ben_ext_person.g_element_id := pay.element_type_id;
486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
491: ben_ext_person.g_element_entry_reason := pay.reason;
492: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;

Line 489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;

485: ben_ext_person.g_element_id := pay.element_type_id;
486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
491: ben_ext_person.g_element_entry_reason := pay.reason;
492: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
493: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;

Line 490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;

486: ben_ext_person.g_element_entry_value := pay.screen_entry_value;
487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
491: ben_ext_person.g_element_entry_reason := pay.reason;
492: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
493: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
494: ben_ext_person.g_element_entry_id := pay.element_entry_id;

Line 491: ben_ext_person.g_element_entry_reason := pay.reason;

487: ben_ext_person.g_element_entry_value_id := pay.element_entry_value_id;
488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
491: ben_ext_person.g_element_entry_reason := pay.reason;
492: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
493: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
494: ben_ext_person.g_element_entry_id := pay.element_entry_id;
495:

Line 492: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;

488: ben_ext_person.g_element_entry_eff_start_date := pay.effective_start_date;
489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
491: ben_ext_person.g_element_entry_reason := pay.reason;
492: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
493: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
494: ben_ext_person.g_element_entry_id := pay.element_entry_id;
495:
496:

Line 493: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;

489: ben_ext_person.g_element_entry_eff_end_date := pay.effective_end_date;
490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
491: ben_ext_person.g_element_entry_reason := pay.reason;
492: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
493: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
494: ben_ext_person.g_element_entry_id := pay.element_entry_id;
495:
496:
497: open c_ele_type(pay.element_type_id) ;

Line 494: ben_ext_person.g_element_entry_id := pay.element_entry_id;

490: ben_ext_person.g_element_entry_costing_id := pay.cost_allocation_keyflex_id;
491: ben_ext_person.g_element_entry_reason := pay.reason;
492: ben_ext_person.g_element_eev_eff_strt_date := pay.eev_effective_start_date;
493: ben_ext_person.g_element_eev_eff_end_date := pay.eev_effective_end_date;
494: ben_ext_person.g_element_entry_id := pay.element_entry_id;
495:
496:
497: open c_ele_type(pay.element_type_id) ;
498: fetch c_ele_type into

Line 499: ben_ext_person.g_element_name ,

495:
496:
497: open c_ele_type(pay.element_type_id) ;
498: fetch c_ele_type into
499: ben_ext_person.g_element_name ,
500: ben_ext_person.g_element_reporting_name,
501: ben_ext_person.g_element_description ,
502: ben_ext_person.g_element_classification_id ,
503: ben_ext_person.g_element_processing_type,

Line 500: ben_ext_person.g_element_reporting_name,

496:
497: open c_ele_type(pay.element_type_id) ;
498: fetch c_ele_type into
499: ben_ext_person.g_element_name ,
500: ben_ext_person.g_element_reporting_name,
501: ben_ext_person.g_element_description ,
502: ben_ext_person.g_element_classification_id ,
503: ben_ext_person.g_element_processing_type,
504: ben_ext_person.g_element_input_currency_code ,

Line 501: ben_ext_person.g_element_description ,

497: open c_ele_type(pay.element_type_id) ;
498: fetch c_ele_type into
499: ben_ext_person.g_element_name ,
500: ben_ext_person.g_element_reporting_name,
501: ben_ext_person.g_element_description ,
502: ben_ext_person.g_element_classification_id ,
503: ben_ext_person.g_element_processing_type,
504: ben_ext_person.g_element_input_currency_code ,
505: ben_ext_person.g_element_output_currency_code,

Line 502: ben_ext_person.g_element_classification_id ,

498: fetch c_ele_type into
499: ben_ext_person.g_element_name ,
500: ben_ext_person.g_element_reporting_name,
501: ben_ext_person.g_element_description ,
502: ben_ext_person.g_element_classification_id ,
503: ben_ext_person.g_element_processing_type,
504: ben_ext_person.g_element_input_currency_code ,
505: ben_ext_person.g_element_output_currency_code,
506: ben_ext_person.g_element_skip_rule_id

Line 503: ben_ext_person.g_element_processing_type,

499: ben_ext_person.g_element_name ,
500: ben_ext_person.g_element_reporting_name,
501: ben_ext_person.g_element_description ,
502: ben_ext_person.g_element_classification_id ,
503: ben_ext_person.g_element_processing_type,
504: ben_ext_person.g_element_input_currency_code ,
505: ben_ext_person.g_element_output_currency_code,
506: ben_ext_person.g_element_skip_rule_id
507: ;

Line 504: ben_ext_person.g_element_input_currency_code ,

500: ben_ext_person.g_element_reporting_name,
501: ben_ext_person.g_element_description ,
502: ben_ext_person.g_element_classification_id ,
503: ben_ext_person.g_element_processing_type,
504: ben_ext_person.g_element_input_currency_code ,
505: ben_ext_person.g_element_output_currency_code,
506: ben_ext_person.g_element_skip_rule_id
507: ;
508: close c_ele_type ;

Line 505: ben_ext_person.g_element_output_currency_code,

501: ben_ext_person.g_element_description ,
502: ben_ext_person.g_element_classification_id ,
503: ben_ext_person.g_element_processing_type,
504: ben_ext_person.g_element_input_currency_code ,
505: ben_ext_person.g_element_output_currency_code,
506: ben_ext_person.g_element_skip_rule_id
507: ;
508: close c_ele_type ;
509:

Line 506: ben_ext_person.g_element_skip_rule_id

502: ben_ext_person.g_element_classification_id ,
503: ben_ext_person.g_element_processing_type,
504: ben_ext_person.g_element_input_currency_code ,
505: ben_ext_person.g_element_output_currency_code,
506: ben_ext_person.g_element_skip_rule_id
507: ;
508: close c_ele_type ;
509:
510:

Line 514: (p_processing_type => ben_ext_person.g_element_processing_type ,

510:
511: --
512:
513: ben_ext_evaluate_inclusion.Evaluate_Elm_Entry_Incl
514: (p_processing_type => ben_ext_person.g_element_processing_type ,
515: p_input_value_id => pay.input_value_id ,
516: p_business_group_id => p_business_group_id ,
517: p_effective_date => p_effective_date ,
518: p_person_id => p_person_id ,

Line 533: if ben_ext_person.g_element_classification_id is not null then

529: -- assign enrollment info to global variables
530: --
531:
532:
533: if ben_ext_person.g_element_classification_id is not null then
534: open c_ele_clas (ben_ext_person.g_element_classification_id) ;
535: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;
536: close c_ele_clas ;
537: end if ;

Line 534: open c_ele_clas (ben_ext_person.g_element_classification_id) ;

530: --
531:
532:
533: if ben_ext_person.g_element_classification_id is not null then
534: open c_ele_clas (ben_ext_person.g_element_classification_id) ;
535: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;
536: close c_ele_clas ;
537: end if ;
538:

Line 535: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;

531:
532:
533: if ben_ext_person.g_element_classification_id is not null then
534: open c_ele_clas (ben_ext_person.g_element_classification_id) ;
535: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;
536: close c_ele_clas ;
537: end if ;
538:
539: if ben_ext_person.g_element_skip_rule_id is not null then

Line 539: if ben_ext_person.g_element_skip_rule_id is not null then

535: fetch c_ele_clas into ben_ext_person.g_element_classification_name ;
536: close c_ele_clas ;
537: end if ;
538:
539: if ben_ext_person.g_element_skip_rule_id is not null then
540: open c_ff_name (ben_ext_person.g_element_skip_rule_id) ;
541: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;
542: close c_ff_name ;
543: end if ;

Line 540: open c_ff_name (ben_ext_person.g_element_skip_rule_id) ;

536: close c_ele_clas ;
537: end if ;
538:
539: if ben_ext_person.g_element_skip_rule_id is not null then
540: open c_ff_name (ben_ext_person.g_element_skip_rule_id) ;
541: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;
542: close c_ff_name ;
543: end if ;
544:

Line 541: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;

537: end if ;
538:
539: if ben_ext_person.g_element_skip_rule_id is not null then
540: open c_ff_name (ben_ext_person.g_element_skip_rule_id) ;
541: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;
542: close c_ff_name ;
543: end if ;
544:
545: if ben_ext_person.g_element_entry_costing_id is not null then

Line 545: if ben_ext_person.g_element_entry_costing_id is not null then

541: fetch c_ff_name into ben_ext_person.g_element_skip_rule ;
542: close c_ff_name ;
543: end if ;
544:
545: if ben_ext_person.g_element_entry_costing_id is not null then
546: open c_ele_conc (ben_ext_person.g_element_entry_costing_id) ;
547: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;
548: close c_ele_conc ;
549: end if ;

Line 546: open c_ele_conc (ben_ext_person.g_element_entry_costing_id) ;

542: close c_ff_name ;
543: end if ;
544:
545: if ben_ext_person.g_element_entry_costing_id is not null then
546: open c_ele_conc (ben_ext_person.g_element_entry_costing_id) ;
547: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;
548: close c_ele_conc ;
549: end if ;
550:

Line 547: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;

543: end if ;
544:
545: if ben_ext_person.g_element_entry_costing_id is not null then
546: open c_ele_conc (ben_ext_person.g_element_entry_costing_id) ;
547: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;
548: close c_ele_conc ;
549: end if ;
550:
551: hr_utility.set_location('eeveffdate '||ben_ext_person.g_element_eev_eff_strt_date||

Line 551: hr_utility.set_location('eeveffdate '||ben_ext_person.g_element_eev_eff_strt_date||

547: fetch c_ele_conc into ben_ext_person.g_element_entry_costing ;
548: close c_ele_conc ;
549: end if ;
550:
551: hr_utility.set_location('eeveffdate '||ben_ext_person.g_element_eev_eff_strt_date||
552: '-'||ben_ext_person.g_element_eev_eff_end_date ,99);
553: --
554: -- format and write
555: --

Line 552: '-'||ben_ext_person.g_element_eev_eff_end_date ,99);

548: close c_ele_conc ;
549: end if ;
550:
551: hr_utility.set_location('eeveffdate '||ben_ext_person.g_element_eev_eff_strt_date||
552: '-'||ben_ext_person.g_element_eev_eff_end_date ,99);
553: --
554: -- format and write
555: --
556: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,