APPS.OTA_BATCH_ACTION_API dependencies on OTA_BULK_ENR_REQ_MEMBERS

Line 109: l_person_action_id ota_bulk_enr_req_members.PERSON_ACTION_ID%type;

105: ,p_enrollment_status in varchar2 default null
106: ,p_error_message in varchar2 default null
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

Line 119: insert into ota_bulk_enr_req_members

115: Open C_Sel1;
116: Fetch C_Sel1 Into l_person_action_id;
117: Close C_Sel1;
118:
119: insert into ota_bulk_enr_req_members
120: (PERSON_ACTION_ID,
121: PERSON_ID,
122: BULK_ENR_REQUEST_ID,
123: ACTION_STATUS_CD,

Line 146: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while creating ota_bulk_enr_req_members record');

142: p_person_action_id := l_person_action_id;
143:
144: Exception
145: when others then
146: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while creating ota_bulk_enr_req_members record');
147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error:'||substr(SQLERRM,1,2000));
148: raise;
149: end create_bulk_enr_request_member;
150: