APPS.OKL_LA_STREAM_PVT dependencies on DBMS_ALERT

Line 9255: DBMS_ALERT.REGISTER(l_alert_name);

9251: OPEN get_rep_trans_num(p_chr_id);
9252: FETCH get_rep_trans_num INTO l_alert_name;
9253: CLOSE get_rep_trans_num;
9254:
9255: DBMS_ALERT.REGISTER(l_alert_name);
9256: DBMS_ALERT.WAITONE(l_alert_name,l_message,l_status,l_timeout);
9257: DBMS_ALERT.REMOVE(l_alert_name);
9258:
9259: IF l_status = 1 THEN

Line 9256: DBMS_ALERT.WAITONE(l_alert_name,l_message,l_status,l_timeout);

9252: FETCH get_rep_trans_num INTO l_alert_name;
9253: CLOSE get_rep_trans_num;
9254:
9255: DBMS_ALERT.REGISTER(l_alert_name);
9256: DBMS_ALERT.WAITONE(l_alert_name,l_message,l_status,l_timeout);
9257: DBMS_ALERT.REMOVE(l_alert_name);
9258:
9259: IF l_status = 1 THEN
9260: --Fetching the request status of the Reporting Product

Line 9257: DBMS_ALERT.REMOVE(l_alert_name);

9253: CLOSE get_rep_trans_num;
9254:
9255: DBMS_ALERT.REGISTER(l_alert_name);
9256: DBMS_ALERT.WAITONE(l_alert_name,l_message,l_status,l_timeout);
9257: DBMS_ALERT.REMOVE(l_alert_name);
9258:
9259: IF l_status = 1 THEN
9260: --Fetching the request status of the Reporting Product
9261: OPEN get_stream_req_status_csr(p_chr_id);

Line 9326: DBMS_ALERT.SIGNAL(l_alert_name,l_rep_message);

9322: OPEN get_rep_trans_num(p_chr_id);
9323: FETCH get_rep_trans_num INTO l_alert_name;
9324: CLOSE get_rep_trans_num;
9325:
9326: DBMS_ALERT.SIGNAL(l_alert_name,l_rep_message);
9327: COMMIT;
9328: -- Bug 4541302 - End of Changes
9329: END IF;
9330: ELSE