[Home] [Help]
PACKAGE: APPS.OTA_EVT_BUS2
Source
1 Package ota_evt_bus2 AUTHID CURRENT_USER as
2 /* $Header: otevt02t.pkh 120.1 2007/11/21 13:42:02 shwnayak noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< Lock_Event >----------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 --
9 -- Description: Locks the Event
10 Procedure Lock_Event (p_event_id in number);
11 --
12 -- ----------------------------------------------------------------------------
13 -- |--------------------------< Get Total Places >----------------------------|
14 -- ----------------------------------------------------------------------------
15 --
16 -- Description: Get total number of placed delegates.
17 --
18 --
19 Function Get_Total_Places(p_all_or_internal in varchar2
20 ,p_event_id in number) return number;
21 --
22 -- ----------------------------------------------------------------------------
23 -- |--------------------------< Check Places >--------------------------------|
24 -- ----------------------------------------------------------------------------
25 --
26 -- Description: Checks the Maximum_Attendees and Maximum_Internal_Attendees
27 -- when updated.
28 --
29 --
30 Procedure Check_Places(p_event_id in number
31 ,p_maximum_attendees in number
32 ,p_maximum_internal_attendees in number);
33 --
34 -- ----------------------------------------------------------------------------
35 -- |------------------------------< Reset_Event_Status >----------------------|
36 -- ----------------------------------------------------------------------------
37 --
38 -- Description: Reset Event Status
39 --
40 -- Resets the Event Status for the event record if event is reached
41 -- to full.
42 --
43 Procedure Reset_Event_Status(p_event_id in number
44 ,p_object_version_number in out nocopy number
45 ,p_event_status in varchar2
46 ,p_maximum_attendees in number);
47 --
48 -- ----------------------------------------------------------------------------
49 -- |--------------------------< Resource Bookings Exists >--------------------|
50 -- ----------------------------------------------------------------------------
51 --
52 --
53 -- Description: Checks whether Resource bookings exists for a particular event.
54 --
55 --
56 Function Resource_Booking_Exists (p_event_id in number) return boolean;
57 --
58 --
59 -- ----------------------------------------------------------------------------
60 -- |--------------------------< Finance Line Exists >-------------------------|
61 -- ----------------------------------------------------------------------------
62 --
63 -- Description: Checks whether a finance line exists for a particular booking_Id.
64 --
65 --
66 Function Finance_Line_Exists (p_booking_id in number
67 ,p_cancelled_flag in varchar2) return boolean;
68 --
69 -- ----------------------------------------------------------------------------
70 -- |--------------------------< Get Vacancies >-------------------------------|
71 -- ----------------------------------------------------------------------------
72 --
73 -- Description: Get Vacancies
74 --
75 -- Get current vacancies for a particular event.
76 --
77 Function Get_Vacancies(p_event_id in number) return number;
78 --
79 -- ----------------------------------------------------------------------------
80 -- |--------------------------< Wait List Required >--------------------------|
81 -- ----------------------------------------------------------------------------
82 --
83 -- Description: Check if Wait List window is required.
84 --
85 -- Returns Boolean
86 --
87 Function Wait_List_Required (p_event_type in varchar2
88 ,p_event_id in number
89 ,p_event_status in varchar2
90 ,p_booking_status_type_id in number default null)
91 Return Boolean;
92 --
93 ----------------------------------------------------------------------------
94 -- |--------------------------< Check Mandatory Association for event >--------------------------|
95 -- ----------------------------------------------------------------------------
96 --
97 -- Description: Check if mandatory enrollments exist for the event
98 --
99
100 procedure Check_Mandatory_Associations(p_event_id in number
101 ,p_maximum_attendees in number
102 ,p_maximum_internal_attendees in number);
103
104
105 -- --------------------------------------------------------------------------------------------
106 -- |--------------------------< Check if Mandatory Asociation exists for a particular event >--------------------------------|
107 -- ------------------------------------------------------------------------------------------
108 --
109 -- Returns Boolean
110 --
111 function mandatory_associations_exists(p_event_id in number)return boolean ;
112 --
113 end ota_evt_bus2;