DBA Data[Home] [Help]

APPS.PER_EVT_BUS dependencies on PER_EVENTS

Line 29: , per_events evt

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_events evt
30: where evt.event_id = p_event_id
31: and pbg.business_group_id = evt.business_group_id;
32: --
33: -- Declare local variables

Line 89: , per_events evt

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_events evt
90: where evt.event_id = p_event_id
91: and pbg.business_group_id = evt.business_group_id;
92: --
93: -- Declare local variables

Line 237: ,p_descflex_name => 'PER_EVENTS'

233: -- b) During insert.
234: --
235: hr_dflex_utility.ins_or_upd_descflex_attribs
236: (p_appl_short_name => 'PER'
237: ,p_descflex_name => 'PER_EVENTS'
238: ,p_attribute_category => p_rec.attribute_category
239: ,p_attribute1_name => 'ATTRIBUTE1'
240: ,p_attribute1_value => p_rec.attribute1
241: ,p_attribute2_name => 'ATTRIBUTE2'

Line 374: (p_type in per_events.type%TYPE

370: -- Internal Development Use Only
371: --
372:
373: Procedure chk_event_type
374: (p_type in per_events.type%TYPE
375: ) is
376: --
377: l_proc varchar2(72):=g_package||'chk_type';
378: --

Line 425: (p_date_start in per_events.date_start%TYPE

421: -- Internal Development Use Only
422: --
423:
424: Procedure chk_event_times
425: (p_date_start in per_events.date_start%TYPE
426: ,p_date_end in per_events.date_end%TYPE
427: ,p_time_start in per_events.time_start%TYPE
428: ,p_time_end in per_events.time_end%TYPE
429: ) is

Line 426: ,p_date_end in per_events.date_end%TYPE

422: --
423:
424: Procedure chk_event_times
425: (p_date_start in per_events.date_start%TYPE
426: ,p_date_end in per_events.date_end%TYPE
427: ,p_time_start in per_events.time_start%TYPE
428: ,p_time_end in per_events.time_end%TYPE
429: ) is
430: --

Line 427: ,p_time_start in per_events.time_start%TYPE

423:
424: Procedure chk_event_times
425: (p_date_start in per_events.date_start%TYPE
426: ,p_date_end in per_events.date_end%TYPE
427: ,p_time_start in per_events.time_start%TYPE
428: ,p_time_end in per_events.time_end%TYPE
429: ) is
430: --
431: l_proc varchar2(72):=g_package||'chk_event_times';

Line 428: ,p_time_end in per_events.time_end%TYPE

424: Procedure chk_event_times
425: (p_date_start in per_events.date_start%TYPE
426: ,p_date_end in per_events.date_end%TYPE
427: ,p_time_start in per_events.time_start%TYPE
428: ,p_time_end in per_events.time_end%TYPE
429: ) is
430: --
431: l_proc varchar2(72):=g_package||'chk_event_times';
432: l_time_start date;

Line 511: (p_emp_or_apl in per_events.emp_or_apl%TYPE

507: -- Access Status
508: -- Internal Table Handler Use Only.
509: --
510: procedure chk_emp_or_apl
511: (p_emp_or_apl in per_events.emp_or_apl%TYPE
512: ,p_date_start in date
513: )
514: is
515: --

Line 579: (p_event_or_interview in per_events.event_or_interview%TYPE

575: -- Internal Table Handler Use Only.
576: --
577: --
578: procedure chk_event_or_interview
579: (p_event_or_interview in per_events.event_or_interview%TYPE
580: ,p_date_start in date
581: )
582: is
583: --

Line 653: (p_object_version_number in per_events.object_version_number%TYPE

649: --
650: -- {End Of Comments}
651: -- ----------------------------------------------------------------------------
652: procedure chk_internal_contact_person_id
653: (p_object_version_number in per_events.object_version_number%TYPE
654: ,p_internal_contact_person_id in per_events.internal_contact_person_id%TYPE
655: ,p_business_group_id in per_events.business_group_id%TYPE
656: ,p_date_start in per_events.date_start%TYPE
657: )

Line 654: ,p_internal_contact_person_id in per_events.internal_contact_person_id%TYPE

650: -- {End Of Comments}
651: -- ----------------------------------------------------------------------------
652: procedure chk_internal_contact_person_id
653: (p_object_version_number in per_events.object_version_number%TYPE
654: ,p_internal_contact_person_id in per_events.internal_contact_person_id%TYPE
655: ,p_business_group_id in per_events.business_group_id%TYPE
656: ,p_date_start in per_events.date_start%TYPE
657: )
658: is

Line 655: ,p_business_group_id in per_events.business_group_id%TYPE

651: -- ----------------------------------------------------------------------------
652: procedure chk_internal_contact_person_id
653: (p_object_version_number in per_events.object_version_number%TYPE
654: ,p_internal_contact_person_id in per_events.internal_contact_person_id%TYPE
655: ,p_business_group_id in per_events.business_group_id%TYPE
656: ,p_date_start in per_events.date_start%TYPE
657: )
658: is
659: --

Line 656: ,p_date_start in per_events.date_start%TYPE

652: procedure chk_internal_contact_person_id
653: (p_object_version_number in per_events.object_version_number%TYPE
654: ,p_internal_contact_person_id in per_events.internal_contact_person_id%TYPE
655: ,p_business_group_id in per_events.business_group_id%TYPE
656: ,p_date_start in per_events.date_start%TYPE
657: )
658: is
659: --
660: l_proc varchar2(72) := g_package||'chk_internal_contact_person_id';

Line 753: (p_object_version_number in per_events.object_version_number%TYPE

749: --
750: -- {End Of Comments}
751: -- ----------------------------------------------------------------------------
752: procedure chk_organization_run_by_id
753: (p_object_version_number in per_events.object_version_number%TYPE
754: ,p_organization_run_by_id in per_events.organization_run_by_id%TYPE
755: ,p_business_group_id in per_events.business_group_id%TYPE
756: ,p_date_start in per_events.date_start%TYPE
757: )

Line 754: ,p_organization_run_by_id in per_events.organization_run_by_id%TYPE

750: -- {End Of Comments}
751: -- ----------------------------------------------------------------------------
752: procedure chk_organization_run_by_id
753: (p_object_version_number in per_events.object_version_number%TYPE
754: ,p_organization_run_by_id in per_events.organization_run_by_id%TYPE
755: ,p_business_group_id in per_events.business_group_id%TYPE
756: ,p_date_start in per_events.date_start%TYPE
757: )
758: is

Line 755: ,p_business_group_id in per_events.business_group_id%TYPE

751: -- ----------------------------------------------------------------------------
752: procedure chk_organization_run_by_id
753: (p_object_version_number in per_events.object_version_number%TYPE
754: ,p_organization_run_by_id in per_events.organization_run_by_id%TYPE
755: ,p_business_group_id in per_events.business_group_id%TYPE
756: ,p_date_start in per_events.date_start%TYPE
757: )
758: is
759: --

Line 756: ,p_date_start in per_events.date_start%TYPE

752: procedure chk_organization_run_by_id
753: (p_object_version_number in per_events.object_version_number%TYPE
754: ,p_organization_run_by_id in per_events.organization_run_by_id%TYPE
755: ,p_business_group_id in per_events.business_group_id%TYPE
756: ,p_date_start in per_events.date_start%TYPE
757: )
758: is
759: --
760: l_proc varchar2(72) := g_package||'chk_organization_run_by_id';

Line 839: p_assignment_id in per_events.assignment_id%type

835:
836: -- ----------------------------------------------------------------------------
837: Procedure chk_assignment_id
838: (
839: p_assignment_id in per_events.assignment_id%type
840: ,p_date_start in per_events.date_start%type
841: ,p_business_group_id in per_events.business_group_id%TYPE
842: ) is
843: --

Line 840: ,p_date_start in per_events.date_start%type

836: -- ----------------------------------------------------------------------------
837: Procedure chk_assignment_id
838: (
839: p_assignment_id in per_events.assignment_id%type
840: ,p_date_start in per_events.date_start%type
841: ,p_business_group_id in per_events.business_group_id%TYPE
842: ) is
843: --
844: l_proc varchar2(72) := g_package||'chk_assignment_id';

Line 841: ,p_business_group_id in per_events.business_group_id%TYPE

837: Procedure chk_assignment_id
838: (
839: p_assignment_id in per_events.assignment_id%type
840: ,p_date_start in per_events.date_start%type
841: ,p_business_group_id in per_events.business_group_id%TYPE
842: ) is
843: --
844: l_proc varchar2(72) := g_package||'chk_assignment_id';
845: l_business_group_id per_all_assignments_f.business_group_id%type;

Line 846: l_assignment_id per_events.assignment_id%type;

842: ) is
843: --
844: l_proc varchar2(72) := g_package||'chk_assignment_id';
845: l_business_group_id per_all_assignments_f.business_group_id%type;
846: l_assignment_id per_events.assignment_id%type;
847: --
848: cursor c_valid_asg(v_assignment_id number) is
849: select business_group_id
850: from per_all_assignments_f asg

Line 924: (p_object_version_number in per_events.object_version_number%TYPE

920: --
921: -- {End Of Comments}
922: -- ----------------------------------------------------------------------------
923: procedure chk_location_id
924: (p_object_version_number in per_events.object_version_number%TYPE
925: ,p_location_id in per_events.location_id%TYPE
926: ,p_business_group_id in per_events.business_group_id%TYPE
927: )
928: is

Line 925: ,p_location_id in per_events.location_id%TYPE

921: -- {End Of Comments}
922: -- ----------------------------------------------------------------------------
923: procedure chk_location_id
924: (p_object_version_number in per_events.object_version_number%TYPE
925: ,p_location_id in per_events.location_id%TYPE
926: ,p_business_group_id in per_events.business_group_id%TYPE
927: )
928: is
929: --

Line 926: ,p_business_group_id in per_events.business_group_id%TYPE

922: -- ----------------------------------------------------------------------------
923: procedure chk_location_id
924: (p_object_version_number in per_events.object_version_number%TYPE
925: ,p_location_id in per_events.location_id%TYPE
926: ,p_business_group_id in per_events.business_group_id%TYPE
927: )
928: is
929: --
930: l_proc varchar2(72) := g_package||'chk_location_id';

Line 1009: l_party_id per_events.party_id%TYPE;

1005: p_rec in out nocopy per_evt_shd.g_rec_type
1006: )is
1007: --
1008: l_proc varchar2(72) := g_package||'chk_party_id';
1009: l_party_id per_events.party_id%TYPE;
1010: l_party_id2 per_events.party_id%TYPE;
1011: --
1012: --
1013: -- cursor to get party_id

Line 1010: l_party_id2 per_events.party_id%TYPE;

1006: )is
1007: --
1008: l_proc varchar2(72) := g_package||'chk_party_id';
1009: l_party_id per_events.party_id%TYPE;
1010: l_party_id2 per_events.party_id%TYPE;
1011: --
1012: --
1013: -- cursor to get party_id
1014: --