APPS.OT_WORKFLOW_SS dependencies on HR_API_TRANSACTIONS

Line 18: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

14:
15: ---------- private function to get item type for current transaction ---------
16: -------------------------------------------------------------------------------
17: function get_item_type
18: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
19: return varchar2 is
20: c_item_type varchar2(50);
21:
22: begin

Line 49: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

45: -------------------------------------------------------------------------------
46:
47:
48: function get_item_key
49: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
50: return varchar2 is
51: c_item_key varchar2(100);
52:
53: begin

Line 82: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

78: -- Get the event standard price
79: --
80:
81: function get_event_standard_price
82: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
83: return number is
84: c_event_standard_price ota_events.standard_price%type;
85: c_event_id ota_events.event_id%type;
86: c_item_type varchar2(50);

Line 131: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

127: --
128: -- Get the activity type
129: --
130: function get_activity_type
131: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
132: return varchar2 is
133:
134: c_activity_name ota_activity_definitions.name%type;
135: c_event_id ota_events.event_id%type;

Line 185: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

181: --
182: -- Get the activity category
183: --
184: function get_act_pm_category
185: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
186: return varchar2 is
187:
188: c_activity_category ota_act_cat_inclusions.activity_category%type;
189: c_event_id ota_events.event_id%type;

Line 245: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

241: --
242: -- Get the activity primary delivery method
243: --
244: function get_act_pm_delivery_method
245: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
246: return varchar2 is
247:
248: c_delivery_method ota_act_cat_inclusions.activity_category%type;
249: c_event_id ota_events.event_id%type;

Line 306: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

302: --
303: -- Get the enrollment status
304: --
305: function get_enrollment_status
306: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
307: return varchar2 is
308:
309: c_enrollment_status ota_booking_status_types.name%type;
310: c_booking_id ota_delegate_bookings.booking_id%type;