APPS.PAYPLNK dependencies on HR_GENERAL

Line 78: hr_general.end_of_time)

74: from hr_lookups hlk
75: where hlk.lookup_type = 'BATCH_STATUS'
76: and sysdate between nvl(hlk.start_date_active,sysdate)
77: and nvl(hlk.end_date_active,
78: hr_general.end_of_time)
79: and hlk.enabled_flag = 'Y'
80: and hlk.lookup_code = upper(l_user_status);
81: --
82: g_header_record csr_header%ROWTYPE;

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

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

Line 2273: hr_general.end_of_time)

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

Line 2307: hr_general.end_of_time)

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

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

3012: from per_absence_attendance_types paat
3013: where paat.input_value_id = l_passed_inp_val
3014: and paat.business_group_id +0 = l_business_group_id
3015: and date_effective <= l_passed_start_date
3016: and (nvl(date_end,hr_general.end_of_time) >= l_passed_end_date
3017: or l_passed_end_date is null);
3018: --
3019: -- Bug 488335 - new declaration to avoid invalid parameter modes in
3020: -- Oracle 8. Declare temporary line_record variable in order to

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

4471: l_reject_if_future_changes_chk := true;
4472: end if;
4473: --
4474: if (g_header_record.reject_if_future_changes = 'Y') and
4475: (l_effective_end_date <> hr_general.end_of_time) then
4476: raise future_changes_exist;
4477: elsif l_date_effective_changes_chk = false then
4478: l_column_name1 := 'DATE EFFECTIVE CHANGES';
4479: --

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

4483: --
4484: l_date_effective_changes_chk := true;
4485: end if;
4486: --
4487: if (l_effective_end_date = hr_general.end_of_time) then
4488: --
4489: if g_header_record.date_effective_changes = 'C' then
4490: l_update_mode := 'CORRECTION';
4491: l_allow_rollback := FALSE;

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

4516: l_passed_inp_tbl,
4517: l_passed_val_tbl);
4518: --
4519: elsif (g_header_record.reject_if_future_changes = 'N') and
4520: (l_effective_end_date <> hr_general.end_of_time) then
4521: --
4522: if g_header_record.date_effective_changes = 'C' then
4523: l_update_mode := 'CORRECTION';
4524: l_allow_rollback := FALSE;

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

4713: g_line_error := true;
4714: g_count := g_count + 1;
4715: --
4716: hr_utility.set_message(801,'HR_7014_ELE_ENTRY_CREATOR_UPD');
4717: hr_utility.set_message_token('CREATOR_MEANING', hr_general.decode_lookup('CREATOR_TYPE','SP'));
4718: l_error_text := substrb(hr_utility.get_message, 1, 240);
4719: --
4720: l_line_id_tbl(g_count) := g_line_record.batch_line_id;
4721: l_status_tbl(g_count) := 'F';