DBA Data[Home] [Help]

APPS.OTA_BATCH_ACTION_API dependencies on DUAL

Line 17: Cursor C_Sel1 is select OTA_BATCH_RANGES_S.nextval from sys.dual;

13:
14: l_range_id OTA_BATCH_RANGES.RANGE_ID%type;
15: l_object_verion_number OTA_BATCH_RANGES.OBJECT_VERSION_NUMBER%Type := 1;
16:
17: Cursor C_Sel1 is select OTA_BATCH_RANGES_S.nextval from sys.dual;
18:
19: begin
20:
21: Open C_Sel1;

Line 65: Cursor C_Sel1 is select OTA_BULK_ENR_REQUESTS_S.nextval from sys.dual;

61: )as
62:
63: l_bulk_enr_request_id ota_bulk_enr_requests.BULK_ENR_REQUEST_ID%Type;
64:
65: Cursor C_Sel1 is select OTA_BULK_ENR_REQUESTS_S.nextval from sys.dual;
66:
67: begin
68:
69: Open C_Sel1;

Line 111: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;

107: ,p_booking_id in number default null) as
108:
109: l_person_action_id ota_bulk_enr_req_members.PERSON_ACTION_ID%type;
110:
111: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;
112:
113: begin
114:
115: Open C_Sel1;