DBA Data[Home] [Help]

APPS.CSP_REPAIR_ORDER_PKG dependencies on DUAL

Line 128: from DUAL;

124: END IF;
125: --dbms_output.put_line(l_supplier_name);
126: open the_cursor FOR
127: select l_supplier_type,l_source_type,l_supplier_name,l_repair_supplier_id,l_dest_org_id,l_item_number,l_qty,l_uom,l_subinv_code,l_item_id,l_org_id
128: from DUAL;
129: RETURN the_cursor;
130: END;
131: FUNCTION create_repair_order
132: (p_item_id NUMBER,

Line 197: SELECT X_ORDER_NUMBER,X_RET_STATUS,X_MSG FROM DUAL;

193: X_RET_STATUS := 0;
194: X_MSG := 'CSP_REPAIR_ORDER_CREATED';
195: END IF;
196: OPEN ORDER_CURSOR FOR
197: SELECT X_ORDER_NUMBER,X_RET_STATUS,X_MSG FROM DUAL;
198: RETURN order_cursor;
199: END;
200: END;