APPS.PAYPLNK dependencies on HR_GENERAL

Line 83: hr_general.end_of_time)

79: from hr_lookups hlk
80: where hlk.lookup_type = 'BATCH_STATUS'
81: and sysdate between nvl(hlk.start_date_active,sysdate)
82: and nvl(hlk.end_date_active,
83: hr_general.end_of_time)
84: and hlk.enabled_flag = 'Y'
85: and hlk.lookup_code = upper(l_user_status);
86: --
87: g_header_record csr_header%ROWTYPE;

Line 202: hr_utility.set_message_token ('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', p_uom_value ));

198: --
199: exception
200: when others then
201: hr_utility.set_message ('PAY','PAY_6306_INPUT_VALUE_FORMAT');
202: hr_utility.set_message_token ('UNIT_OF_MEASURE', hr_general.decode_lookup ('UNITS', p_uom_value ));
203: hr_utility.raise_error;
204: --
205: end convert_internal_to_display;
206: --

Line 2271: hr_general.end_of_time)

2267: from hr_lookups hlk
2268: where upper( hlk.lookup_type) = 'CONTROL_TYPE'
2269: and sysdate between nvl(hlk.start_date_active,sysdate)
2270: and nvl(hlk.end_date_active,
2271: hr_general.end_of_time)
2272: and hlk.enabled_flag = 'Y');
2273: --
2274: exception
2275: when no_data_found then

Line 2305: hr_general.end_of_time)

2301: where hlk.lookup_type = 'CONTROL_TYPE'
2302: and sysdate between nvl(hlk.start_date_active,
2303: sysdate)
2304: and nvl(hlk.end_date_active,
2305: hr_general.end_of_time)
2306: and hlk.enabled_flag = 'Y'
2307: and upper(g_control_record.control_type) in (hlk.lookup_code);
2308: --
2309: hr_utility.set_location('payplnk.validate_controls',15);

Line 3008: and (nvl(date_end,hr_general.end_of_time) >= l_passed_end_date

3004: from per_absence_attendance_types paat
3005: where paat.input_value_id = l_passed_inp_val
3006: and paat.business_group_id +0 = l_business_group_id
3007: and date_effective <= l_passed_start_date
3008: and (nvl(date_end,hr_general.end_of_time) >= l_passed_end_date
3009: or l_passed_end_date is null);
3010: --
3011: -- Bug 488335 - new declaration to avoid invalid parameter modes in
3012: -- Oracle 8. Declare temporary line_record variable in order to

Line 4456: (l_effective_end_date <> hr_general.end_of_time) then

4452: l_reject_if_future_changes_chk := true;
4453: end if;
4454: --
4455: if (g_header_record.reject_if_future_changes = 'Y') and
4456: (l_effective_end_date <> hr_general.end_of_time) then
4457: raise future_changes_exist;
4458: elsif l_date_effective_changes_chk = false then
4459: l_column_name1 := 'DATE EFFECTIVE CHANGES';
4460: --

Line 4468: if (l_effective_end_date = hr_general.end_of_time) then

4464: --
4465: l_date_effective_changes_chk := true;
4466: end if;
4467: --
4468: if (l_effective_end_date = hr_general.end_of_time) then
4469: --
4470: if g_header_record.date_effective_changes = 'C' then
4471: l_update_mode := 'CORRECTION';
4472: l_allow_rollback := FALSE;

Line 4501: (l_effective_end_date <> hr_general.end_of_time) then

4497: l_passed_inp_tbl,
4498: l_passed_val_tbl);
4499: --
4500: elsif (g_header_record.reject_if_future_changes = 'N') and
4501: (l_effective_end_date <> hr_general.end_of_time) then
4502: --
4503: if g_header_record.date_effective_changes = 'C' then
4504: l_update_mode := 'CORRECTION';
4505: l_allow_rollback := FALSE;

Line 4698: hr_utility.set_message_token('CREATOR_MEANING', hr_general.decode_lookup('CREATOR_TYPE','SP'));

4694: g_line_error := true;
4695: g_count := g_count + 1;
4696: --
4697: hr_utility.set_message(801,'HR_7014_ELE_ENTRY_CREATOR_UPD');
4698: hr_utility.set_message_token('CREATOR_MEANING', hr_general.decode_lookup('CREATOR_TYPE','SP'));
4699: l_error_text := substrb(hr_utility.get_message, 1, 240);
4700: --
4701: l_line_id_tbl(g_count) := g_line_record.batch_line_id;
4702: l_status_tbl(g_count) := 'F';