APPS.CSP_NOTIFICATIONS_ORDER_PKG dependencies on DUAL

Line 233: FROM sys.dual;

229:
230: -- requisition_header_id
231: SELECT po_requisition_headers_s.nextval
232: INTO l_requisition_header_id
233: FROM sys.dual;
234:
235: -- Get unique requisition_line_id
236: SELECT po_requisition_lines_s.nextval
237: INTO l_requisition_line_id

Line 238: FROM sys.dual;

234:
235: -- Get unique requisition_line_id
236: SELECT po_requisition_lines_s.nextval
237: INTO l_requisition_line_id
238: FROM sys.dual;
239:
240: -- create po order
241: INSERT INTO po_requisitions_interface_all(
242: LAST_UPDATE_DATE,

Line 342: FROM dual;

338: END IF;
339: ELSIF (p_src_type = 'WIP') THEN
340: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
341: INTO l_wip_id
342: FROM dual;
343:
344: IF (l_item_attr_rec.build_in_wip <> 'Y' OR
345: l_item_attr_rec.pick_components <> 'N') THEN
346: x_ret_status := -1;

Line 500: select x_ret_status,x_msg from dual;

496: );
497: END IF;
498: end if;
499: open l_notif_order_cur for
500: select x_ret_status,x_msg from dual;
501: Return l_notif_order_cur;
502: END;
503: END;