[Home] [Help]
24: bst.BST_INFORMATION9,bst.BST_INFORMATION10,bst.BST_INFORMATION11,
25: bst.BST_INFORMATION12,bst.BST_INFORMATION13,bst.BST_INFORMATION14,
26: bst.BST_INFORMATION15,bst.BST_INFORMATION16,bst.BST_INFORMATION17,
27: bst.BST_INFORMATION18,bst.BST_INFORMATION19,bst.BST_INFORMATION20
28: FROM ota_booking_status_types bst, ota_booking_status_types_tl bstt
29: WHERE bst.business_group_id = p_business_group_id
30: AND bst.booking_status_type_id = bstt.booking_status_type_id
31: AND bstt.language=userenv('LANG')
32: AND bst.ACTIVE_FLAG = 'Y'
41: AND ( (bstt.name like 'W:%' and bst.ACTIVE_FLAG = 'Y')
42: -- There are no names like W:, so a defaulted required status is
43: -- the second choice.
44: OR ( NOT EXISTS (SELECT 1
45: FROM ota_booking_status_types bst1, ota_booking_status_types_tl bstt1
46: WHERE bst1.business_group_id = p_business_group_id
47: AND bst1.booking_status_type_id = bstt1.booking_status_type_id
48: AND bstt1.language=userenv('LANG')
49: AND bst1.type =
57: AND ( (bst.default_flag = 'Y')
58: -- If there are no names like 'W:%' and no defaulted status of type
59: -- required, then select one that is of type required
60: OR NOT EXISTS (SELECT 1
61: FROM ota_booking_status_types
62: WHERE business_group_id = p_business_group_id
63: AND type =
64: DECODE(p_web_booking_status_type, 'REQUESTED', 'R'
65: , 'WAITLISTED','W'
303:
304:
305: FUNCTION Get_Booking_Status_For_Web (p_web_booking_status_type VARCHAR2
306: ,p_business_group_id NUMBER)
307: RETURN OTA_BOOKING_STATUS_TYPES%ROWTYPE;
308:
309: Procedure supervisor_exists ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
310: itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
311: actid IN NUMBER,
826: -- Description: Retrieves the default cancellation enrollment status id
827: --
828: --
829: Function getCancellationStatusId
830: RETURN ota_booking_status_types.booking_status_type_id%type;
831:
832: end ota_learner_enroll_ss ;