APPS.PER_ENV_BUS dependencies on PER_CAL_ENTRY_VALUES

Line 31: , per_cal_entry_values env

27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups_perf pbg
30: , per_calendar_entries ent
31: , per_cal_entry_values env
32: where env.cal_entry_value_id = p_cal_entry_value_id
33: and env.calendar_entry_id = ent.calendar_entry_id
34: and pbg.business_group_id (+) = ent.business_group_id;
35:

Line 98: , per_cal_entry_values env

94: cursor csr_leg_code is
95: select pbg.legislation_code
96: from per_business_groups_perf pbg
97: , per_calendar_entries ent
98: , per_cal_entry_values env
99: where env.cal_entry_value_id = p_cal_entry_value_id
100: and env.calendar_entry_id = ent.calendar_entry_id
101: and pbg.business_group_id (+) = ent.business_group_id;
102: --

Line 214: ,p_base_table => 'PER_CAL_ENTRY_VALUES'

210: then
211: hr_api.argument_changed_error
212: (p_api_name => l_proc
213: ,p_argument => 'CALENDAR_ENTRY_ID'
214: ,p_base_table => 'PER_CAL_ENTRY_VALUES'
215: );
216: end if;
217: --
218: End chk_non_updateable_args;

Line 283: -- to which the node belongs, and that the node id is unique in per_cal_entry_values

279: --
280: -- Description:
281: -- Validates hierarchy_node_id, if set, exists in per_gen_hierarchy_nodes.
282: -- Also checks that the parent calendar entry is using the same generic hierarchy
283: -- to which the node belongs, and that the node id is unique in per_cal_entry_values
284: -- for the parent calendar_entry_id. Insert only.
285: --
286: -- In Arguments:
287: --

Line 320: -- in per_cal_entry_values;

316: and pgv.version_number = 1);
317:
318: --
319: -- Check that the node is unique for the parent entry id
320: -- in per_cal_entry_values;
321: --
322: CURSOR CSR_ENT_VAL IS
323: SELECT 'X'
324: FROM per_cal_entry_values env

Line 324: FROM per_cal_entry_values env

320: -- in per_cal_entry_values;
321: --
322: CURSOR CSR_ENT_VAL IS
323: SELECT 'X'
324: FROM per_cal_entry_values env
325: WHERE env.hierarchy_node_id = p_hierarchy_node_id
326: AND env.calendar_entry_id = p_calendar_entry_id;
327: --
328: Begin

Line 532: l_type per_cal_entry_values.override_type%type;

528: SELECT name, type from per_calendar_entries
529: WHERE calendar_entry_id = p_calendar_entry_id;
530: --
531: l_proc varchar2(80) := g_package||'chk_override_name_type';
532: l_type per_cal_entry_values.override_type%type;
533: l_name per_cal_entry_values.override_name%type;
534: --
535: Begin
536: --

Line 533: l_name per_cal_entry_values.override_name%type;

529: WHERE calendar_entry_id = p_calendar_entry_id;
530: --
531: l_proc varchar2(80) := g_package||'chk_override_name_type';
532: l_type per_cal_entry_values.override_type%type;
533: l_name per_cal_entry_values.override_name%type;
534: --
535: Begin
536: --
537: hr_utility.set_location('Entering:'||l_proc, 5);

Line 616: -- corresponds to a record in per_cal_entry_values for the current

612: -- b) usage_flag value is one of 'N' entry value,'Y' exception,'O' override.
613: -- c) parent_entry_value_id is mandatory if usage_flag <> 'Y', otherwise
614: -- parent_entry_value_id must be null.
615: -- d) if parent_entry_value_id is not null, checks that parent_entry_value_id
616: -- corresponds to a record in per_cal_entry_values for the current
617: -- calendar_entry_id, and that the parent record is an existing entry value.
618: -- i.e. usage = 'Y'.
619: --
620: -- In Arguments:

Line 631: -- Check the parent exists in per_cal_entry_values

627: ,p_calendar_entry_id IN NUMBER
628: ,p_parent_entry_value_id IN NUMBER
629: ,p_usage_flag IN VARCHAR2) IS
630:
631: -- Check the parent exists in per_cal_entry_values
632: -- as calendar hierarchies only have one version
633: CURSOR CSR_EV IS
634: SELECT env.calendar_entry_id, env.parent_entry_value_id
635: FROM per_cal_entry_values env

Line 635: FROM per_cal_entry_values env

631: -- Check the parent exists in per_cal_entry_values
632: -- as calendar hierarchies only have one version
633: CURSOR CSR_EV IS
634: SELECT env.calendar_entry_id, env.parent_entry_value_id
635: FROM per_cal_entry_values env
636: WHERE env.cal_entry_value_id = p_parent_entry_value_id;
637:
638: l_parent_entry_id NUMBER(15);
639: l_parent_entry_value_id NUMBER(15);

Line 733: FROM PER_CAL_ENTRY_VALUES ENV

729: Procedure chk_identifier_key (p_identifier_key in VARCHAR2) IS
730: --
731: CURSOR c_unique IS
732: SELECT 'Y'
733: FROM PER_CAL_ENTRY_VALUES ENV
734: WHERE ENV.IDENTIFIER_KEY = p_identifier_key;
735:
736: l_proc varchar2(72) := g_package||'chk_identifier_key';
737: l_value varchar2(240):= null;

Line 751: (p_associated_column1 => 'PER_CAL_ENTRY_VALUES.identifier_key');

747: close c_unique;
748: -- Add to MM list as non-fatal
749: fnd_message.set_name('PER','PER_449074_CAL_IDK_EXISTS');
750: hr_multi_message.add
751: (p_associated_column1 => 'PER_CAL_ENTRY_VALUES.identifier_key');
752: ELSE
753: close c_unique;
754: END IF;
755: --