59: ,p_business_group_id in number default null
60: ,p_conc_program_request_id in number
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
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;
69: Open C_Sel1;
70: Fetch C_Sel1 Into l_bulk_enr_request_id;
71: Close C_Sel1;
72:
73: insert into OTA_BULK_ENR_REQUESTS
74: (BULK_ENR_REQUEST_ID,
75: REQUESTOR_ID,
76: OBJECT_TYPE,
77: BUSINESS_GROUP_ID,
89: p_bulk_enr_request_id := l_bulk_enr_request_id;
90:
91: Exception
92: when others then
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while creating OTA_BULK_ENR_REQUESTS record');
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error:'||substr(SQLERRM,1,2000));
95: raise;
96: end create_bulk_enr_request;
97: